Re: buffer_pool_recycle in 11.2.0.3

From: joel garry <joel-garry_at_home.com>
Date: Mon, 12 Dec 2011 11:11:34 -0800 (PST)
Message-ID: <0dfb45ad-74b0-44ad-924a-8852daeac8c3_at_k5g2000pra.googlegroups.com>

On Dec 9, 8:54 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> 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.com

See http://docs.oracle.com/cd/E11882_01/server.112/e23633/changes.htm#UPGRD12570 and MOS Oracle Multiple Buffer Pools Feature [ID 135223.1]

I guess cleaning out the garage isn't high on development priorities. It must be a pain trying to slowly wean some dinosaurs off their parameters. Bug 4331420: DBUA FAILS WITH "STRING INDEX OUT OF RANGE: -8" ERROR is an example that dbua has to be able to handle all kinds of bizarro version skips.

jg

--
_at_home.com is bogus.
http://www.businessweek.com/news/2011-12-12/rimini-street-to-delay-ipo-to-fight-oracle-lawsuit-founder-says.html

Received on Mon Dec 12 2011 - 13:11:34 CST