Databases Reference
In-Depth Information
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:
F
OBJ
: The object identifier
F
HLADDR
: The address of the child latch
F
TS#
: The tablespace identifier number
F
FILE#
: The file identifier number
F
BLOCK#
: The database block identifier number
