Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!k5g2000pra.googlegroups.com!not-for-mail From: joel garry Newsgroups: comp.databases.oracle.server Subject: Re: buffer_pool_recycle in 11.2.0.3 Date: Mon, 12 Dec 2011 11:11:34 -0800 (PST) Organization: http://groups.google.com Lines: 41 Message-ID: <0dfb45ad-74b0-44ad-924a-8852daeac8c3@k5g2000pra.googlegroups.com> References: NNTP-Posting-Host: 64.58.150.28 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1323717108 20681 127.0.0.1 (12 Dec 2011 19:11:48 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 12 Dec 2011 19:11:48 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: k5g2000pra.googlegroups.com; posting-host=64.58.150.28; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv User-Agent: G2/1.0 X-Google-Web-Client: true X-Google-Header-Order: HUALESNKRC X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18 ( .NET CLR 3.5.30729),gzip(gfe) Xref: news.cambrium.nl On Dec 9, 8:54=A0pm, Mladen Gogala wrote: > I did "show parameter recycle" and got the following reply: > > SQL> show parameter recycle > > NAME =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 TYPE= =A0 =A0 =A0 =A0VALUE > ------------------------------------ ----------- > ------------------------------ > buffer_pool_recycle =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0string > db_recycle_cache_size =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0big integer 0 > recyclebin =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 string =A0= =A0 =A0on > 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#UPGRD= 12570 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/2011-12-12/rimini-street-to-delay-ipo-to-f= ight-oracle-lawsuit-founder-says.html