[Home] [Help] [Dependency Information]
Object Name: | GV_$STREAMS_POOL_STATISTICS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
TOTAL_MEMORY_ALLOCATED | NUMBER | |||
CURRENT_SIZE | NUMBER | |||
SGA_TARGET_VALUE | NUMBER | |||
SHRINK_PHASE | NUMBER | |||
ADVICE_DISABLED | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, TOTAL_MEMORY_ALLOCATED
, CURRENT_SIZE
, SGA_TARGET_VALUE
, SHRINK_PHASE
, ADVICE_DISABLED
, CON_ID
FROM SYS.GV_$STREAMS_POOL_STATISTICS;
|
|
|