Re: recycle pool

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 2 Aug 2002 15:31:20 +1000
Message-ID: <7Ho29.51026$Hj3.152021@newsfeeds.bigpond.com>

Hi Daud,

If a table has a buffer_pool that is not configured, the default pool is used instead. This is to prevent issues when moving tables between different databases that may different SGA configurations.

My notes suggest issues with buffer pool stats on 8.1.5, not sure they were fixed in 8.1.7.

Cheers

Richard
"Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0208012008.14eb5880_at_posting.google.com...
> Oracle 8.1.7.3.0
>
> I was testing setting up multiple buffer pools when I came across this
> situation. I configured db_block_buffer and buffer_pool_keep but not
> buffer_pool_recycle. I then created a new table and assigned it to the
> recycle pool. Oracle didn't complained. Why?
>
> Another question. I read somewhere that says there is a bug in oracle
> where v$buffer_pool_statistics does not show the correct statistics in
> oracle 8.1.7.0.0. Cannot remember where I read it. Is this true?
>
> thanks
> Daud
Received on Fri Aug 02 2002 - 00:31:20 CDT