DB_RECYCLE_CACHE_SIZE

Property	Description
Parameter type	Big integer
Syntax	DB_RECYCLE_CACHE_SIZE = integer [K | M | G]
Default value	0 (DB_RECYCLE_CACHE_SIZE is not configured by default)
Modifiable	ALTER SYSTEM
Range of values	Minimum: 0 (values greater than zero are automatically modified to be either the user-specified size rounded up to the granule size or 4 MB * number of CPUs, whichever is greater) Maximum: operating system-dependent
Basic	No

DB_RECYCLE_CACHE_SIZE specifies the size of the RECYCLE buffer pool. The size of the buffers in the RECYCLE pool is the primary block size (the block size defined by the DB_BLOCK_SIZE initialization parameter).

Note:

1. This parameter was introduced in Oracle9i.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘DB_RECYCLE_CACHE_SIZE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_recycle_cache_size	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Size of RECYCLE buffer pool for standard block size buffers

Oracle initializatoin parameters