| to find object in buffer pool [message #187958] |
Wed, 16 August 2006 09:14  |
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  |
 |
BlackSwan
Messages: 26766
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
