[Home] [Help] [Dependency Information]
Object Name: | V_$SQL_SHARED_MEMORY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SQL_TEXT | VARCHAR2 | (1000) | ||
SQL_FULLTEXT | CLOB | (4000) | ||
HASH_VALUE | NUMBER | |||
SQL_ID | VARCHAR2 | (13) | ||
HEAP_DESC | RAW | (8) | ||
STRUCTURE | VARCHAR2 | (16) | ||
FUNCTION | VARCHAR2 | (16) | ||
CHUNK_COM | VARCHAR2 | (16) | ||
CHUNK_PTR | RAW | (8) | ||
CHUNK_SIZE | NUMBER | |||
ALLOC_CLASS | VARCHAR2 | (8) | ||
CHUNK_TYPE | NUMBER | |||
SUBHEAP_DESC | RAW | (8) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SQL_TEXT
, SQL_FULLTEXT
, HASH_VALUE
, SQL_ID
, HEAP_DESC
, STRUCTURE
, FUNCTION
, CHUNK_COM
, CHUNK_PTR
, CHUNK_SIZE
, ALLOC_CLASS
, CHUNK_TYPE
, SUBHEAP_DESC
, CON_ID
FROM SYS.V_$SQL_SHARED_MEMORY;
|
|
|