Re: recycle pool

Richard Foote wrote:
>
> 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

8.1.7.0 has '0' for some of the stats in v$buffer_pool_statistics - can't recall when it was fixed.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."