Home Oracle Commands v$ Performance views
Oracle Data Dictionary

V$SQL

Data Dictionary View

Columns
   ___________________________
 
   CHILD_LATCH
   SQL_TEXT
   SHARABLE_MEM
   PERSISTENT_MEM
   RUNTIME_MEM
   SORTS
   LOADED_VERSIONS
   OPEN_VERSIONS
   USERS_OPENING
   FETCHES
   EXECUTIONS
   USERS_EXECUTING
   LOADS
   FIRST_LOAD_TIME
   INVALIDATIONS
   PARSE_CALLS
   DISK_READS
   BUFFER_GETS
   ROWS_PROCESSED
   COMMAND_TYPE
   OPTIMIZER_MODE
   OPTIMIZER_COST
   PARSING_USER_ID
   PARSING_SCHEMA_ID
   KEPT_VERSIONS
   ADDRESS
   TYPE_CHK_HEAP
   HASH_VALUE
   PLAN_HASH_VALUE
   CHILD_NUMBER
   MODULE
   MODULE_HASH
   ACTION
   ACTION_HASH
   SERIALIZABLE_ABORTS
   OUTLINE_CATEGORY
   CPU_TIME
   ELAPSED_TIME
   OUTLINE_SID
   CHILD_ADDRESS
   SQLTYPE
   REMOTE
   OBJECT_STATUS
   LITERAL_HASH_VALUE
   LAST_LOAD_TIME
   IS_OBSOLETE

Related:

V$OPEN_CURSOR 
V$SQLAREA 
V$SQLTEXT 
V$SQLTEXT_WITH_NEWLINES 
V$SQL_BIND_DATA 
V$SQL_BIND_METADATA 
V$SQL_CURSOR 
V$SQL_SHARED_MEMORY



Simon Sheppard
SS64.com