Re: Diff between recycle pool and nocache keywords

"April Nine" <april94111_at_yahoo.com> wrote in message news:cdf76ce3.0305090730.6f31359d_at_posting.google.com...
> Hi,
>
> suppose I run these commands:
>
> CREATE TABLE dropme2 (x DATE)
> STORAGE ( BUFFER_POOL RECYCLE);
>
> CREATE TABLE dropme3 (x DATE)
> STORAGE ( BUFFER_POOL RECYCLE)
> NOCACHE;
>
> How is the behavior of the resulting tables
> different from each other?
>
> I really want to make sure that blocks get aged
> out of the buffer cache very quickly.
>
> Would dropme3 blocks get aged out quicker than
> dropme2 blocks?
>
> Do you know of any V$ views which might help me answer
> the question myself by running some experiments.
>
> -April Nine
> april94111_at_yahoo.com

Any problem with reading a manual?
So why do you bore this group with quiz questions?

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address