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: 25531
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: Sun Jul 23 00:24:20 CDT 2017

Total time taken to generate the page: 0.04333 seconds