Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Diff between KEEP pool and CACHE keywords
Hi,
suppose I run these commands:
CREATE TABLE dropme2 (x DATE)
STORAGE ( BUFFER_POOL KEEP);
CREATE TABLE dropme3 (x DATE)
STORAGE ( BUFFER_POOL KEEP)
CACHE;
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 slowly (or possibly pinned).
Would dropme3 blocks get aged out slower 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
Received on Fri May 09 2003 - 10:33:18 CDT