Init parameterFiles & storage

RECYCLEBIN

What it controls

Whether dropped tables go to the recycle bin so they can be flashed back.

Know this before you change it

Turning it off instance-wide applies to new sessions only. Purge the recycle bin to reclaim space rather than switching it off.

Default: ON

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'recyclebin';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'recyclebin' AND isspecified = 'TRUE';8 9-- Applies to sessions that connect after the change10ALTER SYSTEM SET recyclebin = OFF DEFERRED SCOPE = BOTH SID = '*';11 12-- Or for your own session only13ALTER SESSION SET recyclebin = OFF;14 15-- Remove it from the spfile to go back to the default at the next restart16ALTER SYSTEM RESET recyclebin SCOPE = SPFILE SID = '*';

Related scripts

• Recycle bin contents by ownerDropped objects still taking up space. Oracle reclaims it under space pressure, but a large recycle bin can make tablespace reports look worse than…

Open in the parameter referenceOracle's reference

More in Files & storage

• DB_CREATE_FILE_DESTDefault location for Oracle-managed datafiles and tempfiles.
• DB_CREATE_ONLINE_LOG_DEST_NLocations for Oracle-managed online redo logs and control files. Numbered 1 to 5; each one holds a member of every group.
• CONTROL_FILESThe control file copies the instance opens at startup.
• DB_FILESThe most datafiles the database can have open.
• FILESYSTEMIO_OPTIONSAsynchronous and direct I/O for datafiles on file systems.
• DEFERRED_SEGMENT_CREATIONWhether new tables and indexes get space only when the first row arrives.
• MAX_STRING_SIZEEXTENDED raises VARCHAR2, NVARCHAR2 and RAW limits from 4000 to 32767 bytes.