buffer_pool_recycle in 11.2.0.3
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 10 Dec 2011 04:54:55 +0000 (UTC)
Message-ID: <pan.2011.12.10.04.54.55_at_gmail.com>
I did "show parameter recycle" and got the following reply:
SQL> What is surprising is BUFFER_POOL_RECYCLE, a parameter that has been obsolete since the version 9.2. It wasn't documented in 10g and I don't understand why was this obvious atavism retained in 11.2? Here is the link to 9.2 documentation that qualifies this parameter as obsolete:
Date: Sat, 10 Dec 2011 04:54:55 +0000 (UTC)
Message-ID: <pan.2011.12.10.04.54.55_at_gmail.com>
I did "show parameter recycle" and got the following reply:
SQL> show parameter recycle
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ buffer_pool_recycle string db_recycle_cache_size big integer 0 recyclebin string on
SQL> What is surprising is BUFFER_POOL_RECYCLE, a parameter that has been obsolete since the version 9.2. It wasn't documented in 10g and I don't understand why was this obvious atavism retained in 11.2? Here is the link to 9.2 documentation that qualifies this parameter as obsolete:
http://docs.oracle.com/cd/A97630_01/server.920/a96536/ch119.htm
This should have been removed altogether or retained as an underscore parameter. It isn't documented, but it's there.
-- http://mgogala.byethost5.comReceived on Fri Dec 09 2011 - 22:54:55 CST