Home » RDBMS Server » Server Administration » to find object in buffer pool
to find object in buffer pool [message #187958] Wed, 16 August 2006 09:14 Go to next message
speaker
Messages: 30
Registered: April 2006
Member

I want to keep the table in memory
so i issue the following command.

ALTER TABLE MI_FULL_PLAIN STORAGE (BUFFER_POOL KEEP);

please help me with an SQL to find what tables are cached in the buffer_pool.

Whether the table is present or not.
Re: to find object in buffer pool [message #188041 is a reply to message #187958] Wed, 16 August 2006 19:27 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member

9 rows selected.

SQL> desc V_$BUFFER_POOL
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
RESIZE_STATE VARCHAR2(10)
CURRENT_SIZE NUMBER
BUFFERS NUMBER
TARGET_SIZE NUMBER
TARGET_BUFFERS NUMBER
PREV_SIZE NUMBER
PREV_BUFFERS NUMBER
LO_BNUM NUMBER
HI_BNUM NUMBER
LO_SETID NUMBER
HI_SETID NUMBER
SET_COUNT NUMBER
Previous Topic: Output columns of ps=ef |grep pmon
Next Topic: job save where?
Goto Forum:
  


Current Time: Fri Dec 02 14:21:18 CST 2016

Total time taken to generate the page: 0.09986 seconds