在10g中v$sql很有意思
SQL*Plus: Release 10.1.0.2.0 - Production on Thu May 27 13:54:42 2004
Copyright (c) 1982, 2004, Oracle.All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning and Data Mining options
SQL> desc v$sqlarea;
Name
Null?Type
----------------------------------------------------------------- -------- ---------------------------------------------
SQL_TEXT
VARCHAR2(1000)
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
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(25)
PARSING_USER_ID
NUMBER
PARSING_SCHEMA_ID
NUMBER
KEPT_VERSIONS
NUMBER
ADDRESS
RAW(4)
HASH_VALUE
NUMBER
OLD_HASH_VALUE
NUMBER
MODULE
VARCHAR2(64)
MODULE_HASH
NUMBER
ACTION
VARCHAR2(64)
ACTION_HASH
NUMBER
SERIALIZABLE_ABORTS
NUMBER
CPU_TIME
NUMBER
ELAPSED_TIME
NUMBER
IS_OBSOLETE
VARCHAR2(1)
CHILD_LATCH
NUMBER
PROGRAM_ID
NUMBER
SQL> desc v$sqltext;
Name
Null?Type
----------------------------------------------------------------- -------- ---------------------------------------------
ADDRESS
RAW(4)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
COMMAND_TYPE
NUMBER
PIECE
NUMBER
SQL_TEXT
VARCHAR2(64)
SQL> desc v$sql;
Name
Null?Type
----------------------------------------------------------------- -------- ---------------------------------------------
SQL_TEXT
VARCHAR2(1000)
SQL_FULLTEXT
CLOB
SQL_ID
VARCHAR2(13)
SHARABLE_MEM
NUMBER
PERSISTENT_MEM
NUMBER
RUNTIME_MEM
NUMBER
SORTS
NUMBER
LOADED_VERSIONS
NUMBER
OPEN_VERSIONS
NUMBER
USERS_OPENING
NUMBER
FETCHES
NUMBER
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(652)
OPTIMIZER_ENV_HASH_VALUE
NUMBER
PARSING_USER_ID
NUMBER
PARSING_SCHEMA_ID
NUMBER
KEPT_VERSIONS
NUMBER
ADDRESS
RAW(4)
TYPE_CHK_HEAP
RAW(4)
HASH_VALUE
NUMBER
OLD_HASH_VALUE
NUMBER
PLAN_HASH_VALUE
NUMBER
CHILD_NUMBER
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
NUMBER
CHILD_ADDRESS
RAW(4)
SQLTYPE
NUMBER
REMOTE
VARCHAR2(1)
OBJECT_STATUS
VARCHAR2(19)
LITERAL_HASH_VALUE
NUMBER
LAST_LOAD_TIME
VARCHAR2(19)
IS_OBSOLETE
VARCHAR2(1)
CHILD_LATCH
NUMBER
SQL_PROFILE
VARCHAR2(64)
PROGRAM_ID
NUMBER
PROGRAM_LINE#
NUMBER
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> desc v$sql
Name
Null?Type
----------------------------------------------------------------- -------- ---------------------------------------------
SQL_TEXT
VARCHAR2(1000)
SHARABLE_MEM
NUMBER
PERSISTENT_MEM
NUMBER
RUNTIME_MEM
NUMBER
SORTS
NUMBER
LOADED_VERSIONS
NUMBER
OPEN_VERSIONS
NUMBER
USERS_OPENING
NUMBER
FETCHES
NUMBER
EXECUTIONS
NUMBER
USERS_EXECUTING
NUMBER
LOADS
NUMBER
FIRST_LOAD_TIME
VARCHAR2(19)
INVALIDATIONS
NUMBER
PARSE_CALLS
NUMBER
DISK_READS
NUMBER
BUFFER_GETS
NUMBER
ROWS_PROCESSED
NUMBER
COMMAND_TYPE
NUMBER
OPTIMIZER_MODE
VARCHAR2(10)
OPTIMIZER_COST
NUMBER
PARSING_USER_ID
NUMBER
PARSING_SCHEMA_ID
NUMBER
KEPT_VERSIONS
NUMBER
ADDRESS
RAW(4)
TYPE_CHK_HEAP
RAW(4)
HASH_VALUE
NUMBER
PLAN_HASH_VALUE
NUMBER
CHILD_NUMBER
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
NUMBER
CHILD_ADDRESS
RAW(4)
SQLTYPE
NUMBER
REMOTE
VARCHAR2(1)
OBJECT_STATUS
VARCHAR2(19)
LITERAL_HASH_VALUE
NUMBER
LAST_LOAD_TIME
VARCHAR2(19)
IS_OBSOLETE
VARCHAR2(1)
CHILD_LATCH
NUMBER