eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.GV_$SQLAREA

Object Details

Object Name:	GV_$SQLAREA
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
SQL_TEXT	VARCHAR2	(1000)
SQL_FULLTEXT	CLOB	(4000)
SQL_ID	VARCHAR2	(13)
SHARABLE_MEM	NUMBER
PERSISTENT_MEM	NUMBER
RUNTIME_MEM	NUMBER
SORTS	NUMBER
VERSION_COUNT	NUMBER
LOADED_VERSIONS	NUMBER
OPEN_VERSIONS	NUMBER
USERS_OPENING	NUMBER
FETCHES	NUMBER
EXECUTIONS	NUMBER
PX_SERVERS_EXECUTIONS	NUMBER
END_OF_FETCH_COUNT	NUMBER
USERS_EXECUTING	NUMBER
LOADS	NUMBER
FIRST_LOAD_TIME	VARCHAR2	(19)
INVALIDATIONS	NUMBER
PARSE_CALLS	NUMBER
DISK_READS	NUMBER
DIRECT_WRITES	NUMBER
BUFFER_GETS	NUMBER
APPLICATION_WAIT_TIME	NUMBER
CONCURRENCY_WAIT_TIME	NUMBER
CLUSTER_WAIT_TIME	NUMBER
USER_IO_WAIT_TIME	NUMBER
PLSQL_EXEC_TIME	NUMBER
JAVA_EXEC_TIME	NUMBER
ROWS_PROCESSED	NUMBER
COMMAND_TYPE	NUMBER
OPTIMIZER_MODE	VARCHAR2	(10)
OPTIMIZER_COST	NUMBER
OPTIMIZER_ENV	RAW	(2000)
OPTIMIZER_ENV_HASH_VALUE	NUMBER
PARSING_USER_ID	NUMBER
PARSING_SCHEMA_ID	NUMBER
PARSING_SCHEMA_NAME	VARCHAR2	(30)
KEPT_VERSIONS	NUMBER
ADDRESS	RAW	(8)
HASH_VALUE	NUMBER
OLD_HASH_VALUE	NUMBER
PLAN_HASH_VALUE	NUMBER
FULL_PLAN_HASH_VALUE	NUMBER
MODULE	VARCHAR2	(64)
MODULE_HASH	NUMBER
ACTION	VARCHAR2	(64)
ACTION_HASH	NUMBER
SERIALIZABLE_ABORTS	NUMBER
OUTLINE_CATEGORY	VARCHAR2	(64)
CPU_TIME	NUMBER
ELAPSED_TIME	NUMBER
OUTLINE_SID	VARCHAR2	(40)
LAST_ACTIVE_CHILD_ADDRESS	RAW	(8)
REMOTE	VARCHAR2	(1)
OBJECT_STATUS	VARCHAR2	(19)
LITERAL_HASH_VALUE	NUMBER
LAST_LOAD_TIME	DATE
IS_OBSOLETE	VARCHAR2	(1)
IS_BIND_SENSITIVE	VARCHAR2	(1)
IS_BIND_AWARE	VARCHAR2	(1)
CHILD_LATCH	NUMBER
SQL_PROFILE	VARCHAR2	(64)
SQL_PATCH	VARCHAR2	(30)
SQL_PLAN_BASELINE	VARCHAR2	(30)
PROGRAM_ID	NUMBER
PROGRAM_LINE#	NUMBER
EXACT_MATCHING_SIGNATURE	NUMBER
FORCE_MATCHING_SIGNATURE	NUMBER
LAST_ACTIVE_TIME	DATE
BIND_DATA	RAW	(2000)
TYPECHECK_MEM	NUMBER
IO_CELL_OFFLOAD_ELIGIBLE_BYTES	NUMBER
IO_INTERCONNECT_BYTES	NUMBER
PHYSICAL_READ_REQUESTS	NUMBER
PHYSICAL_READ_BYTES	NUMBER
PHYSICAL_WRITE_REQUESTS	NUMBER
PHYSICAL_WRITE_BYTES	NUMBER
OPTIMIZED_PHY_READ_REQUESTS	NUMBER
LOCKED_TOTAL	NUMBER
PINNED_TOTAL	NUMBER
IO_CELL_UNCOMPRESSED_BYTES	NUMBER
IO_CELL_OFFLOAD_RETURNED_BYTES	NUMBER
CON_ID	NUMBER
IS_REOPTIMIZABLE	VARCHAR2	(1)
IS_RESOLVED_ADAPTIVE_PLAN	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INST_ID
,      SQL_TEXT
,      SQL_FULLTEXT
,      SQL_ID
,      SHARABLE_MEM
,      PERSISTENT_MEM
,      RUNTIME_MEM
,      SORTS
,      VERSION_COUNT
,      LOADED_VERSIONS
,      OPEN_VERSIONS
,      USERS_OPENING
,      FETCHES
,      EXECUTIONS
,      PX_SERVERS_EXECUTIONS
,      END_OF_FETCH_COUNT
,      USERS_EXECUTING
,      LOADS
,      FIRST_LOAD_TIME
,      INVALIDATIONS
,      PARSE_CALLS
,      DISK_READS
,      DIRECT_WRITES
,      BUFFER_GETS
,      APPLICATION_WAIT_TIME
,      CONCURRENCY_WAIT_TIME
,      CLUSTER_WAIT_TIME
,      USER_IO_WAIT_TIME
,      PLSQL_EXEC_TIME
,      JAVA_EXEC_TIME
,      ROWS_PROCESSED
,      COMMAND_TYPE
,      OPTIMIZER_MODE
,      OPTIMIZER_COST
,      OPTIMIZER_ENV
,      OPTIMIZER_ENV_HASH_VALUE
,      PARSING_USER_ID
,      PARSING_SCHEMA_ID
,      PARSING_SCHEMA_NAME
,      KEPT_VERSIONS
,      ADDRESS
,      HASH_VALUE
,      OLD_HASH_VALUE
,      PLAN_HASH_VALUE
,      FULL_PLAN_HASH_VALUE
,      MODULE
,      MODULE_HASH
,      ACTION
,      ACTION_HASH
,      SERIALIZABLE_ABORTS
,      OUTLINE_CATEGORY
,      CPU_TIME
,      ELAPSED_TIME
,      OUTLINE_SID
,      LAST_ACTIVE_CHILD_ADDRESS
,      REMOTE
,      OBJECT_STATUS
,      LITERAL_HASH_VALUE
,      LAST_LOAD_TIME
,      IS_OBSOLETE
,      IS_BIND_SENSITIVE
,      IS_BIND_AWARE
,      CHILD_LATCH
,      SQL_PROFILE
,      SQL_PATCH
,      SQL_PLAN_BASELINE
,      PROGRAM_ID
,      PROGRAM_LINE#
,      EXACT_MATCHING_SIGNATURE
,      FORCE_MATCHING_SIGNATURE
,      LAST_ACTIVE_TIME
,      BIND_DATA
,      TYPECHECK_MEM
,      IO_CELL_OFFLOAD_ELIGIBLE_BYTES
,      IO_INTERCONNECT_BYTES
,      PHYSICAL_READ_REQUESTS
,      PHYSICAL_READ_BYTES
,      PHYSICAL_WRITE_REQUESTS
,      PHYSICAL_WRITE_BYTES
,      OPTIMIZED_PHY_READ_REQUESTS
,      LOCKED_TOTAL
,      PINNED_TOTAL
,      IO_CELL_UNCOMPRESSED_BYTES
,      IO_CELL_OFFLOAD_RETURNED_BYTES
,      CON_ID
,      IS_REOPTIMIZABLE
,      IS_RESOLVED_ADAPTIVE_PLAN
FROM SYS.GV_$SQLAREA;

Dependencies

[top of page]

SYS.GV_$SQLAREA references the following:

SYS.GV_$SQLAREA is referenced by following:

PUBLIC: GV$SQLAREA