dbTalk Databases Forums  

buffer_pool_recycle in 11.2.0.3

comp.databases.oracle.server comp.databases.oracle.server


Discuss buffer_pool_recycle in 11.2.0.3 in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mladen Gogala
 
Posts: n/a

Default buffer_pool_recycle in 11.2.0.3 - 12-09-2011 , 10:54 PM






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/...6536/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

Reply With Quote
  #2  
Old   
joel garry
 
Posts: n/a

Default Re: buffer_pool_recycle in 11.2.0.3 - 12-12-2011 , 01:11 PM






On Dec 9, 8:54*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
Quote:
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/...6536/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/...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
--
@home.com is bogus.
http://www.businessweek.com/news/201...nder-says.html

Reply With Quote
  #3  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: buffer_pool_recycle in 11.2.0.3 - 12-12-2011 , 03:53 PM



On Mon, 12 Dec 2011 11:11:34 -0800, joel garry wrote:

Quote:
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.
This is an interesting bug.



--
http://mgogala.byethost5.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.