X$BH
This view displays the status and number of pings for every buffer in the SGA.
Fields
The most relevant view fields are as follows:
OBJ
: The object identifierHLADDR
: The address of the child latchTS#
: The tablespace identifier numberFILE#
: The file identifier numberBLOCK#
: The database block identifier number
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.