[Home] [Help]
[Dependency Information]
VIEW: SYS.V_$STREAMS_POOL_STATISTICS
Object Details
Object Name: | V_$STREAMS_POOL_STATISTICS |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
TOTAL_MEMORY_ALLOCATED |
NUMBER |
|
|
|
CURRENT_SIZE |
NUMBER |
|
|
|
SGA_TARGET_VALUE |
NUMBER |
|
|
|
SHRINK_PHASE |
NUMBER |
|
|
|
ADVICE_DISABLED |
NUMBER |
|
|
|
CON_ID |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT TOTAL_MEMORY_ALLOCATED
, CURRENT_SIZE
, SGA_TARGET_VALUE
, SHRINK_PHASE
, ADVICE_DISABLED
, CON_ID
FROM SYS.V_$STREAMS_POOL_STATISTICS;
Dependencies
[top of page]
SYS.V_$STREAMS_POOL_STATISTICS references the following:
-
-
SYS.V_$STREAMS_POOL_STATISTICS is referenced by following:
-
PUBLIC
-
V$STREAMS_POOL_STATISTICS