Re: buffer cache

[Tim Gorman]

The X$BH table is a view into the Buffer Cache which has a column OBJ which can be joined to the OBJ$ table (a.k.a. DBA_OBJECTS view) via the column DATAOBJ# (a.k.a. column DATA_OBJECT_ID in DBA_OBJECTS).  But for rollback segments, the OBJ column needs some special treatment, so I wouldn't recommend querying X$BH directly.  Besides, you'd have to be SYS to do that, and it's never a good idea to fool around logged on as SYS often.  Anybody is bound to get burned doing that, sooner or later...   A good view that performs this join (and translates the TYPE# numeric column to a readable string as well as handling the translation of OBJ for rollback segments) is V$CACHE, which is normally associated with OPS/RAC but can be created in non-OPS/RAC environments too.  Just CONNECT INTERNAL and run the script "catparr.sql" in the "$ORACLE_HOME/rdbms/admin" directory to create V$CACHE (and other views)...   Hope this helps... ----- Original Message ----- From: BigP To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 11, 2002 7:08 PM Subject: buffer cache Hi Guys , IS there any way I can find what is occupying how much of buffer cache . Like .. what table is taking most of space etc Thanks , Bp