[Home] [Help] [Dependency Information]
Object Name: | GV_$LATCH_CHILDREN |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
ADDR | RAW | (8) | ||
LATCH# | NUMBER | |||
CHILD# | NUMBER | |||
LEVEL# | NUMBER | |||
NAME | VARCHAR2 | (64) | ||
HASH | NUMBER | |||
GETS | NUMBER | |||
MISSES | NUMBER | |||
SLEEPS | NUMBER | |||
IMMEDIATE_GETS | NUMBER | |||
IMMEDIATE_MISSES | NUMBER | |||
WAITERS_WOKEN | NUMBER | |||
WAITS_HOLDING_LATCH | NUMBER | |||
SPIN_GETS | NUMBER | |||
SLEEP1 | NUMBER | |||
SLEEP2 | NUMBER | |||
SLEEP3 | NUMBER | |||
SLEEP4 | NUMBER | |||
SLEEP5 | NUMBER | |||
SLEEP6 | NUMBER | |||
SLEEP7 | NUMBER | |||
SLEEP8 | NUMBER | |||
SLEEP9 | NUMBER | |||
SLEEP10 | NUMBER | |||
SLEEP11 | NUMBER | |||
WAIT_TIME | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, ADDR
, LATCH#
, CHILD#
, LEVEL#
, NAME
, HASH
, GETS
, MISSES
, SLEEPS
, IMMEDIATE_GETS
, IMMEDIATE_MISSES
, WAITERS_WOKEN
, WAITS_HOLDING_LATCH
, SPIN_GETS
, SLEEP1
, SLEEP2
, SLEEP3
, SLEEP4
, SLEEP5
, SLEEP6
, SLEEP7
, SLEEP8
, SLEEP9
, SLEEP10
, SLEEP11
, WAIT_TIME
, CON_ID
FROM SYS.GV_$LATCH_CHILDREN;
|
|
|