|
Index >
ORACLE Server Parameters >
db_cache_advice
db_cache_advice
NOTE: This is an internal Oracle parameter. Do NOT use it unless instructed
to do so by Oracle Support. Playing with this parameter may be harmful.
Oracle 11.1.0:
| Parameter Name: | db_cache_advice
| | Description: | Buffer cache sizing advisory
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.2.0:
| Parameter Name: | db_cache_advice
| | Description: | Buffer cache sizing advisory
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.1.0:
| Parameter Name: | db_cache_advice
| | Description: | Buffer cache sizing advisory
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 9.2.0:
| Parameter Name: | db_cache_advice
| | Description: | Buffer cache sizing advisory
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 8.1.7:
| Parameter Name: | _db_cache_advice
| | Description: | Buffer cache sizing advisory
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 8.0.6:
No such parmeter in Oracle 8.0.6.
Oracle 7.3.4:
No such parmeter in Oracle 7.3.4.
Related Error Messages:
ORA-00381: cannot use both new and old parameters for buffer cache size specificationCause: User specified one or more of { db_cache_size , db_recycle_cache_size, db_keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32), db_cache_advice } AND one or more of { db_block_buffers, buffer_pool_keep , buffer_pool_recycle }. This is illegal.Action: Use EITHER the old (pre-Oracle_8.2) parameters OR the new ones. Don't specify both. If old size parameters are specified in the parameter file, you may want to replace them with new parameters since the new parameters can be modified dynamically and allow you to configure additional caches for additional block sizes. Cache advisory can only be enabled with the new cache parameters. //
This parameter is not documented and should not be used.
Search for more info about
[ db_cache_advice ]
on the Oracle FAQ.
|
