Oracle Data Dictionary

V$SQL

Columns
   ___________________________
 
   ADDRESS
   INVALIDATIONS
   PARSE_CALLS
   DISK_READS
   BUFFER_GETS
   ROWS_PROCESSED
   COMMAND_TYPE
   OPTIMIZER_MODE
   PARSING_USER_ID
   KEPT_VERSIONS
   OPTIMIZER_COST
   TYPE_CHK_HEAP
   HASH_VALUE
   CHILD_NUMBER
   MODULE
   MODULE_HASH
   ACTION
   ACTION_HASH
   SERIALIZABLE_ABORTS
   OUTLINE_CATEGORY
   FIRST_LOAD_TIME
   PARSING_SCHEMA_ID
   SQL_TEXT
   SHARABLE_MEM
   PERSISTENT_MEM
   RUNTIME_MEM
   SORTS
   LOADED_VERSIONS
   OPEN_VERSIONS
   USERS_OPENING
   EXECUTIONS
   USERS_EXECUTING
   LOADS

Related Views:

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




Back to the Top

Simon Sheppard
SS64.com