SQL> desc V$PROCESS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
PID NUMBER
SPID VARCHAR2(12)
USERNAME VARCHAR2(15)
SERIAL# NUMBER
TERMINAL VARCHAR2(16)
PROGRAM VARCHAR2(64)
TRACEID VARCHAR2(255)
BACKGROUND VARCHAR2(1)
LATCHWAIT VARCHAR2(8)
LATCHSPIN VARCHAR2(8)
PGA_USED_MEM NUMBER
PGA_ALLOC_MEM NUMBER
PGA_FREEABLE_MEM NUMBER
PGA_MAX_MEM NUMBER
SQL> desc V$BGPROCESS;
Name Null? Type
----------------------------------------- -------- ----------------------------
PADDR RAW(4)
PSERIAL# NUMBER
NAME VARCHAR2(5)
DESCRIPTION VARCHAR2(64)
ERROR NUMBER
SQL> desc V$PROCESS_MEMORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
PID NUMBER
SERIAL# NUMBER
CATEGORY VARCHAR2(15)
ALLOCATED NUMBER
USED NUMBER
MAX_ALLOCATED NUMBER
SQL> desc V$PROCESS_MEMORY_DETAIL;
Name Null? Type
----------------------------------------- -------- ----------------------------
PID NUMBER
SERIAL# NUMBER
CATEGORY VARCHAR2(15)
NAME VARCHAR2(26)
HEAP_NAME VARCHAR2(15)
BYTES NUMBER
ALLOCATION_COUNT NUMBER
HEAP_DESCRIPTOR RAW(4)
PARENT_HEAP_DESCRIPTOR RAW(4)
SQL> desc V$PROCESS_MEMORY_DETAIL_PROG;
Name Null? Type
----------------------------------------- -------- ----------------------------
PID NUMBER
SERIAL# NUMBER
STATUS VARCHAR2(10)
SQL> desc V$SESSION;
Name Null? Type
----------------------------------------- -------- ----------------------------
SADDR RAW(4)
SID NUMBER
SERIAL# NUMBER
AUDSID NUMBER
PADDR RAW(4)
USER# NUMBER
USERNAME VARCHAR2(30)
COMMAND NUMBER
OWNERID NUMBER
TADDR VARCHAR2(8)
LOCKWAIT VARCHAR2(8)
STATUS VARCHAR2(8)
SERVER VARCHAR2(9)
SCHEMA# NUMBER
SCHEMANAME VARCHAR2(30)
OSUSER VARCHAR2(30)
PROCESS VARCHAR2(12)
MACHINE VARCHAR2(64)
TERMINAL VARCHAR2(16)
PROGRAM VARCHAR2(64)
TYPE VARCHAR2(10)
SQL_ADDRESS RAW(4)
SQL_HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
SQL_CHILD_NUMBER NUMBER
PREV_SQL_ADDR RAW(4)
PREV_HASH_VALUE NUMBER
PREV_SQL_ID VARCHAR2(13)
PREV_CHILD_NUMBER NUMBER
MODULE VARCHAR2(48)
MODULE_HASH NUMBER
ACTION VARCHAR2(32)
ACTION_HASH NUMBER
CLIENT_INFO VARCHAR2(64)
FIXED_TABLE_SEQUENCE NUMBER
ROW_WAIT_OBJ# NUMBER
ROW_WAIT_FILE# NUMBER
ROW_WAIT_BLOCK# NUMBER
ROW_WAIT_ROW# NUMBER
LOGON_TIME DATE
LAST_CALL_ET NUMBER
PDML_ENABLED VARCHAR2(3)
FAILOVER_TYPE VARCHAR2(13)
FAILOVER_METHOD VARCHAR2(10)
FAILED_OVER VARCHAR2(3)
RESOURCE_CONSUMER_GROUP VARCHAR2(32)
PDML_STATUS VARCHAR2(8)
PDDL_STATUS VARCHAR2(8)
PQ_STATUS VARCHAR2(8)
CURRENT_QUEUE_DURATION NUMBER
CLIENT_IDENTIFIER VARCHAR2(64)
BLOCKING_SESSION_STATUS VARCHAR2(11)
BLOCKING_INSTANCE NUMBER
BLOCKING_SESSION NUMBER
SEQ# NUMBER
EVENT# NUMBER
EVENT VARCHAR2(64)
P1TEXT VARCHAR2(64)
P1 NUMBER
P1RAW RAW(4)
P2TEXT VARCHAR2(64)
P2 NUMBER
P2RAW RAW(4)
P3TEXT VARCHAR2(64)
P3 NUMBER
P3RAW RAW(4)
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
WAIT_TIME NUMBER
SECONDS_IN_WAIT NUMBER
STATE VARCHAR2(19)
SERVICE_NAME VARCHAR2(64)
SQL_TRACE VARCHAR2(8)
SQL_TRACE_WAITS VARCHAR2(5)
SQL_TRACE_BINDS VARCHAR2(5)
SQL> desc V$RSRC_SESSION_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
CURRENT_CONSUMER_GROUP_ID VARCHAR2(40)
ORIG_CONSUMER_GROUP_ID VARCHAR2(40)
MAPPING_ATTRIBUTE VARCHAR2(32)
MAPPED_CONSUMER_GROUP VARCHAR2(32)
STATE VARCHAR2(32)
ACTIVE VARCHAR2(5)
CURRENT_IDLE_TIME NUMBER
CURRENT_CPU_WAIT_TIME NUMBER
CPU_WAIT_TIME NUMBER
CURRENT_CPU_WAITS NUMBER
CPU_WAITS NUMBER
CURRENT_CONSUMED_CPU_TIME NUMBER
CONSUMED_CPU_TIME NUMBER
CURRENT_ACTIVE_TIME NUMBER
ACTIVE_TIME NUMBER
CURRENT_QUEUED_TIME NUMBER
QUEUED_TIME NUMBER
CURRENT_YIELDS NUMBER
YIELDS NUMBER
CURRENT_UNDO_CONSUMPTION NUMBER
MAX_UNDO_CONSUMPTION NUMBER
SQL_CANCELED NUMBER
QUEUE_TIME_OUTS NUMBER
ESTIMATED_EXECUTION_LIMIT_HIT NUMBER
SQL> desc V$BLOCKING_QUIESCE;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SQL> desc V$PX_SESSION ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SADDR RAW(4)
SID NUMBER
SERIAL# NUMBER
QCSID NUMBER
QCSERIAL# NUMBER
QCINST_ID NUMBER
SERVER_GROUP NUMBER
SERVER_SET NUMBER
SERVER# NUMBER
DEGREE NUMBER
REQ_DEGREE NUMBER
SQL> desc V$PX_SESSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SADDR RAW(4)
SID NUMBER
SERIAL# NUMBER
QCSID NUMBER
QCSERIAL# NUMBER
QCINST_ID NUMBER
SERVER_GROUP NUMBER
SERVER_SET NUMBER
SERVER# NUMBER
DEGREE NUMBER
REQ_DEGREE NUMBER
STATISTIC# NUMBER
VALUE NUMBER
SQL> desc V$SESSION_CONNECT_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
AUTHENTICATION_TYPE VARCHAR2(26)
OSUSER VARCHAR2(30)
NETWORK_SERVICE_BANNER VARCHAR2(4000)
SQL> desc V$SESSION_WAIT_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SEQ# NUMBER
EVENT# NUMBER
EVENT VARCHAR2(64)
P1TEXT VARCHAR2(64)
P1 NUMBER
P2TEXT VARCHAR2(64)
P2 NUMBER
P3TEXT VARCHAR2(64)
P3 NUMBER
WAIT_TIME NUMBER
WAIT_COUNT NUMBER
SQL> desc V$SESSION_WAIT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SEQ# NUMBER
EVENT VARCHAR2(64)
P1TEXT VARCHAR2(64)
P1 NUMBER
P1RAW RAW(4)
P2TEXT VARCHAR2(64)
P2 NUMBER
P2RAW RAW(4)
P3TEXT VARCHAR2(64)
P3 NUMBER
P3RAW RAW(4)
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
WAIT_TIME NUMBER
SECONDS_IN_WAIT NUMBER
STATE VARCHAR2(19)
SQL> desc V$SESSION_WAIT_CLASS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
TOTAL_WAITS NUMBER
TIME_WAITED NUMBER
SQL> desc V$SYSTEM_WAIT_CLASS;
Name Null? Type
----------------------------------------- -------- ----------------------------
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
TOTAL_WAITS NUMBER
TIME_WAITED NUMBER
SQL> desc V$SESSION_EVENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
EVENT VARCHAR2(64)
TOTAL_WAITS NUMBER
TOTAL_TIMEOUTS NUMBER
TIME_WAITED NUMBER
AVERAGE_WAIT NUMBER
MAX_WAIT NUMBER
TIME_WAITED_MICRO NUMBER
EVENT_ID NUMBER
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
SQL> desc V$EVENT_HISTOGRAM ;
Name Null? Type
----------------------------------------- -------- ----------------------------
EVENT# NUMBER
EVENT VARCHAR2(64)
WAIT_TIME_MILLI NUMBER
WAIT_COUNT NUMBER
SQL> desc V$SYSTEM_EVENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
EVENT VARCHAR2(64)
TOTAL_WAITS NUMBER
TOTAL_TIMEOUTS NUMBER
TIME_WAITED NUMBER
AVERAGE_WAIT NUMBER
TIME_WAITED_MICRO NUMBER
EVENT_ID NUMBER
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
SQL> desc V$EVENT_NAME ;
Name Null? Type
----------------------------------------- -------- ----------------------------
EVENT# NUMBER
EVENT_ID NUMBER
NAME VARCHAR2(64)
PARAMETER1 VARCHAR2(64)
PARAMETER2 VARCHAR2(64)
PARAMETER3 VARCHAR2(64)
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
SQL> desc V$LICENSE;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSIONS_MAX NUMBER
SESSIONS_WARNING NUMBER
SESSIONS_CURRENT NUMBER
SESSIONS_HIGHWATER NUMBER
USERS_MAX NUMBER
CPU_COUNT_CURRENT NUMBER
CPU_CORE_COUNT_CURRENT NUMBER
CPU_SOCKET_COUNT_CURRENT NUMBER
CPU_COUNT_HIGHWATER NUMBER
CPU_CORE_COUNT_HIGHWATER NUMBER
CPU_SOCKET_COUNT_HIGHWATER NUMBER
SQL> desc V$TRANSACTION ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
XIDUSN NUMBER
XIDSLOT NUMBER
XIDSQN NUMBER
UBAFIL NUMBER
UBABLK NUMBER
UBASQN NUMBER
UBAREC NUMBER
STATUS VARCHAR2(16)
START_TIME VARCHAR2(20)
START_SCNB NUMBER
START_SCNW NUMBER
START_UEXT NUMBER
START_UBAFIL NUMBER
START_UBABLK NUMBER
START_UBASQN NUMBER
START_UBAREC NUMBER
SES_ADDR RAW(4)
FLAG NUMBER
SPACE VARCHAR2(3)
RECURSIVE VARCHAR2(3)
NOUNDO VARCHAR2(3)
PTX VARCHAR2(3)
NAME VARCHAR2(256)
PRV_XIDUSN NUMBER
PRV_XIDSLT NUMBER
PRV_XIDSQN NUMBER
PTX_XIDUSN NUMBER
PTX_XIDSLT NUMBER
PTX_XIDSQN NUMBER
DSCN-B NUMBER
DSCN-W NUMBER
USED_UBLK NUMBER
USED_UREC NUMBER
LOG_IO NUMBER
PHY_IO NUMBER
CR_GET NUMBER
CR_CHANGE NUMBER
START_DATE DATE
DSCN_BASE NUMBER
DSCN_WRAP NUMBER
START_SCN NUMBER
DEPENDENT_SCN NUMBER
XID RAW(8)
PRV_XID RAW(8)
PTX_XID RAW(8)
SQL> desc V$LOCKED_OBJECT;
Name Null? Type
----------------------------------------- -------- ----------------------------
XIDUSN NUMBER
XIDSLOT NUMBER
XIDSQN NUMBER
OBJECT_ID NUMBER
SESSION_ID NUMBER
ORACLE_USERNAME VARCHAR2(30)
OS_USER_NAME VARCHAR2(30)
PROCESS VARCHAR2(12)
LOCKED_MODE NUMBER
SQL> desc V$LATCH ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
LATCH# NUMBER
LEVEL# NUMBER
NAME VARCHAR2(50)
HASH NUMBER
GETS NUMBER
MISSES NUMBER
SLEEPS NUMBER
IMMEDIATE_GETS NUMBER
IMMEDIATE_MISSES NUMBER
WAITERS_WOKEN NUMBER
WAITS_HOLDING_LATCH NUMBER
SPIN_GETS NUMBER
SLEEP1 NUMBER
SLEEP2 NUMBER
SLEEP3 NUMBER
SLEEP4 NUMBER
SLEEP5 NUMBER
SLEEP6 NUMBER
SLEEP7 NUMBER
SLEEP8 NUMBER
SLEEP9 NUMBER
SLEEP10 NUMBER
SLEEP11 NUMBER
WAIT_TIME NUMBER
SQL> desc V$LATCH_CHILDREN ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
LATCH# NUMBER
CHILD# NUMBER
LEVEL# NUMBER
NAME VARCHAR2(50)
HASH NUMBER
GETS NUMBER
MISSES NUMBER
SLEEPS NUMBER
IMMEDIATE_GETS NUMBER
IMMEDIATE_MISSES NUMBER
WAITERS_WOKEN NUMBER
WAITS_HOLDING_LATCH NUMBER
SPIN_GETS NUMBER
SLEEP1 NUMBER
SLEEP2 NUMBER
SLEEP3 NUMBER
SLEEP4 NUMBER
SLEEP5 NUMBER
SLEEP6 NUMBER
SLEEP7 NUMBER
SLEEP8 NUMBER
SLEEP9 NUMBER
SLEEP10 NUMBER
SLEEP11 NUMBER
WAIT_TIME NUMBER
SQL> desc V$LATCH_PARENT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
LATCH# NUMBER
LEVEL# NUMBER
NAME VARCHAR2(50)
HASH NUMBER
GETS NUMBER
MISSES NUMBER
SLEEPS NUMBER
IMMEDIATE_GETS NUMBER
IMMEDIATE_MISSES NUMBER
WAITERS_WOKEN NUMBER
WAITS_HOLDING_LATCH NUMBER
SPIN_GETS NUMBER
SLEEP1 NUMBER
SLEEP2 NUMBER
SLEEP3 NUMBER
SLEEP4 NUMBER
SLEEP5 NUMBER
SLEEP6 NUMBER
SLEEP7 NUMBER
SLEEP8 NUMBER
SLEEP9 NUMBER
SLEEP10 NUMBER
SLEEP11 NUMBER
WAIT_TIME NUMBER
SQL> desc V$LATCHNAME ;
Name Null? Type
----------------------------------------- -------- ----------------------------
LATCH# NUMBER
NAME VARCHAR2(50)
HASH NUMBER
SQL> desc V$LATCHHOLDER;
Name Null? Type
----------------------------------------- -------- ----------------------------
PID NUMBER
SID NUMBER
LADDR RAW(4)
NAME VARCHAR2(64)
GETS NUMBER
SQL> desc V$LATCH_MISSES;
Name Null? Type
----------------------------------------- -------- ----------------------------
PARENT_NAME VARCHAR2(50)
WHERE VARCHAR2(64)
NWFAIL_COUNT NUMBER
SLEEP_COUNT NUMBER
WTR_SLP_COUNT NUMBER
LONGHOLD_COUNT NUMBER
LOCATION VARCHAR2(64)
SQL> desc V$RESOURCE;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
TYPE VARCHAR2(2)
ID1 NUMBER
ID2 NUMBER
SQL> desc V$_LOCK1;
Name Null? Type
----------------------------------------- -------- ----------------------------
LADDR RAW(4)
KADDR RAW(4)
SADDR RAW(4)
RADDR RAW(4)
LMODE NUMBER
REQUEST NUMBER
CTIME NUMBER
BLOCK NUMBER
SQL> desc V$_LOCK ;
Name Null? Type
----------------------------------------- -------- ----------------------------
LADDR RAW(4)
KADDR RAW(4)
SADDR RAW(4)
RADDR RAW(4)
LMODE NUMBER
REQUEST NUMBER
CTIME NUMBER
BLOCK NUMBER
SQL> desc V$LOCK ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
KADDR RAW(4)
SID NUMBER
TYPE VARCHAR2(2)
ID1 NUMBER
ID2 NUMBER
LMODE NUMBER
REQUEST NUMBER
CTIME NUMBER
BLOCK NUMBER
SQL> desc V$ENQUEUE_LOCK;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
KADDR RAW(4)
SID NUMBER
TYPE VARCHAR2(2)
ID1 NUMBER
ID2 NUMBER
LMODE NUMBER
REQUEST NUMBER
CTIME NUMBER
BLOCK NUMBER
SQL> desc V$TRANSACTION_ENQUEUE;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
KADDR RAW(4)
SID NUMBER
TYPE VARCHAR2(2)
ID1 NUMBER
ID2 NUMBER
LMODE NUMBER
REQUEST NUMBER
CTIME NUMBER
BLOCK NUMBER
SQL> desc V$TIMER;
Name Null? Type
----------------------------------------- -------- ----------------------------
HSECS NUMBER
SQL> desc V$SESSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
STATISTIC# NUMBER
VALUE NUMBER
SQL> desc V$MYSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
STATISTIC# NUMBER
VALUE NUMBER
SQL> desc V$SESS_IO;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
BLOCK_GETS NUMBER
CONSISTENT_GETS NUMBER
PHYSICAL_READS NUMBER
BLOCK_CHANGES NUMBER
CONSISTENT_CHANGES NUMBER
SQL> desc V$SYSSTAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTIC# NUMBER
NAME VARCHAR2(64)
CLASS NUMBER
VALUE NUMBER
STAT_ID NUMBER
SQL> desc V$STATNAME ;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTIC# NUMBER
NAME VARCHAR2(64)
CLASS NUMBER
STAT_ID NUMBER
SQL> desc V$OSSTAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
STAT_NAME VARCHAR2(64)
VALUE NUMBER
OSSTAT_ID NUMBER
SQL> desc V$RESOURCE_LIMIT;
Name Null? Type
----------------------------------------- -------- ----------------------------
RESOURCE_NAME VARCHAR2(30)
CURRENT_UTILIZATION NUMBER
MAX_UTILIZATION NUMBER
INITIAL_ALLOCATION VARCHAR2(10)
LIMIT_VALUE VARCHAR2(10)
SQL> desc V$ACCESS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
OWNER VARCHAR2(64)
OBJECT VARCHAR2(1000)
TYPE VARCHAR2(24)
SQL> desc V$OBJECT_DEPENDENCY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FROM_ADDRESS RAW(4)
FROM_HASH NUMBER
TO_OWNER VARCHAR2(64)
TO_NAME VARCHAR2(1000)
TO_ADDRESS RAW(4)
TO_HASH NUMBER
TO_TYPE NUMBER
SQL> desc V$DBFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
NAME VARCHAR2(513)
SQL> desc v$Archive;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
ISCURRENT VARCHAR2(3)
CURRENT VARCHAR2(3)
FIRST_CHANGE# NUMBER
SQL> desc V$FILESTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
PHYRDS NUMBER
PHYWRTS NUMBER
PHYBLKRD NUMBER
PHYBLKWRT NUMBER
SINGLEBLKRDS NUMBER
READTIM NUMBER
WRITETIM NUMBER
SINGLEBLKRDTIM NUMBER
AVGIOTIM NUMBER
LSTIOTIM NUMBER
MINIOTIM NUMBER
MAXIORTM NUMBER
MAXIOWTM NUMBER
SQL> desc V$FILE_HISTOGRAM ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
SINGLEBLKRDTIM_MILLI NUMBER
SINGLEBLKRDS NUMBER
SQL> desc V$TEMP_HISTOGRAM;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
SINGLEBLKRDTIM_MILLI NUMBER
SINGLEBLKRDS NUMBER
SQL> desc V$TEMPSTAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
PHYRDS NUMBER
PHYWRTS NUMBER
PHYBLKRD NUMBER
PHYBLKWRT NUMBER
SINGLEBLKRDS NUMBER
READTIM NUMBER
WRITETIM NUMBER
SINGLEBLKRDTIM NUMBER
AVGIOTIM NUMBER
LSTIOTIM NUMBER
MINIOTIM NUMBER
MAXIORTM NUMBER
MAXIOWTM NUMBER
SQL> desc V$LOGFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# NUMBER
STATUS VARCHAR2(7)
TYPE VARCHAR2(7)
MEMBER VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
SQL> desc V$ROLLSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
USN NUMBER
LATCH NUMBER
EXTENTS NUMBER
RSSIZE NUMBER
WRITES NUMBER
XACTS NUMBER
GETS NUMBER
WAITS NUMBER
OPTSIZE NUMBER
HWMSIZE NUMBER
SHRINKS NUMBER
WRAPS NUMBER
EXTENDS NUMBER
AVESHRINK NUMBER
AVEACTIVE NUMBER
STATUS VARCHAR2(15)
CUREXT NUMBER
CURBLK NUMBER
SQL> desc V$FAST_START_SERVERS;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATE VARCHAR2(11)
UNDOBLOCKSDONE NUMBER
PID NUMBER
XID RAW(8)
SQL> desc V$FAST_START_TRANSACTIONS;
Name Null? Type
----------------------------------------- -------- ----------------------------
USN NUMBER
SLT NUMBER
SEQ NUMBER
STATE VARCHAR2(16)
UNDOBLOCKSDONE NUMBER
UNDOBLOCKSTOTAL NUMBER
PID NUMBER
CPUTIME NUMBER
PARENTUSN NUMBER
PARENTSLT NUMBER
PARENTSEQ NUMBER
XID RAW(8)
PXID RAW(8)
RCVSERVERS NUMBER
SQL> desc V$SGA ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(20)
VALUE NUMBER
SQL> desc V$SGASTAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
POOL VARCHAR2(12)
NAME VARCHAR2(26)
BYTES NUMBER
SQL> desc V$SGAINFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(32)
BYTES NUMBER
RESIZEABLE VARCHAR2(3)
SQL> V$SGA_CURRENT_RESIZE_OPS;
SP2-0734: unknown command beginning "V$SGA_CURR..." - rest of line ignored.
SQL> desc V$SGA_CURRENT_RESIZE_OPS;
Name Null? Type
----------------------------------------- -------- ----------------------------
COMPONENT VARCHAR2(64)
OPER_TYPE VARCHAR2(13)
OPER_MODE VARCHAR2(9)
PARAMETER VARCHAR2(80)
INITIAL_SIZE NUMBER
TARGET_SIZE NUMBER
CURRENT_SIZE NUMBER
START_TIME DATE
LAST_UPDATE_TIME DATE
SQL> desc V$SGA_RESIZE_OPS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
COMPONENT VARCHAR2(64)
OPER_TYPE VARCHAR2(13)
OPER_MODE VARCHAR2(9)
PARAMETER VARCHAR2(80)
INITIAL_SIZE NUMBER
TARGET_SIZE NUMBER
FINAL_SIZE NUMBER
STATUS VARCHAR2(9)
START_TIME DATE
END_TIME DATE
SQL> desc V$SGA_DYNAMIC_COMPONENTS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
COMPONENT VARCHAR2(64)
CURRENT_SIZE NUMBER
MIN_SIZE NUMBER
MAX_SIZE NUMBER
USER_SPECIFIED_SIZE NUMBER
OPER_COUNT NUMBER
LAST_OPER_TYPE VARCHAR2(13)
LAST_OPER_MODE VARCHAR2(9)
LAST_OPER_TIME DATE
GRANULE_SIZE NUMBER
SQL> desc V$SGA_DYNAMIC_FREE_MEMORY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CURRENT_SIZE NUMBER
SQL> desc V$PARAMETER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(512)
DISPLAY_VALUE VARCHAR2(512)
ISDEFAULT VARCHAR2(9)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(10)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
UPDATE_COMMENT VARCHAR2(255)
HASH NUMBER
SQL> desc V$SYSTEM_PARAMETER;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(512)
DISPLAY_VALUE VARCHAR2(512)
ISDEFAULT VARCHAR2(9)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(8)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
UPDATE_COMMENT VARCHAR2(255)
HASH NUMBER
SQL> desc V$PARAMETER2 ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(512)
DISPLAY_VALUE VARCHAR2(512)
ISDEFAULT VARCHAR2(6)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(10)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
ORDINAL NUMBER
UPDATE_COMMENT VARCHAR2(255)
SQL> desc V$SYSTEM_PARAMETER2;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(512)
DISPLAY_VALUE VARCHAR2(512)
ISDEFAULT VARCHAR2(6)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(8)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
ORDINAL NUMBER
UPDATE_COMMENT VARCHAR2(255)
SQL> desc V$OBSOLETE_PARAMETER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(64)
ISSPECIFIED VARCHAR2(5)
SQL> desc V$SPPARAMETER;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID VARCHAR2(80)
NAME VARCHAR2(80)
VALUE VARCHAR2(255)
DISPLAY_VALUE VARCHAR2(255)
ISSPECIFIED VARCHAR2(6)
ORDINAL NUMBER
UPDATE_COMMENT VARCHAR2(255)
SQL> desc V$PARAMETER_VALID_VALUES;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM NUMBER
NAME VARCHAR2(64)
ORDINAL NUMBER
VALUE VARCHAR2(255)
ISDEFAULT VARCHAR2(64)
SQL> desc V$CLUSTER_INTERCONNECTS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(15)
IP_ADDRESS VARCHAR2(16)
IS_PUBLIC VARCHAR2(3)
SOURCE VARCHAR2(31)
SQL> desc V$CONFIGURED_INTERCONNECTS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(15)
IP_ADDRESS VARCHAR2(16)
IS_PUBLIC VARCHAR2(3)
SOURCE VARCHAR2(31)
SQL> desc V$ENABLEDPRIVS;
Name Null? Type
----------------------------------------- -------- ----------------------------
PRIV_NUMBER NUMBER
SQL> desc V$DISPATCHER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(4)
NETWORK VARCHAR2(128)
PADDR RAW(4)
STATUS VARCHAR2(16)
ACCEPT VARCHAR2(3)
MESSAGES NUMBER
BYTES NUMBER
BREAKS NUMBER
OWNED NUMBER
CREATED NUMBER
IDLE NUMBER
BUSY NUMBER
LISTENER NUMBER
CONF_INDX NUMBER
SQL> desc V$DISPATCHER_CONFIG;
Name Null? Type
----------------------------------------- -------- ----------------------------
CONF_INDX NUMBER
NETWORK VARCHAR2(128)
DISPATCHERS NUMBER
CONNECTIONS NUMBER
SESSIONS NUMBER
POOL VARCHAR2(4)
TICKS NUMBER
INBD_TIMOUT NUMBER
OUTBD_TIMOUT NUMBER
MULTIPLEX VARCHAR2(4)
LISTENER VARCHAR2(1200)
SERVICE VARCHAR2(512)
SQL> desc V$DISPATCHER_RATE;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(4)
PADDR RAW(4)
CUR_LOOP_RATE NUMBER
CUR_EVENT_RATE NUMBER
CUR_EVENTS_PER_LOOP NUMBER
CUR_MSG_RATE NUMBER
CUR_SVR_BUF_RATE NUMBER
CUR_SVR_BYTE_RATE NUMBER
CUR_SVR_BYTE_PER_BUF NUMBER
CUR_CLT_BUF_RATE NUMBER
CUR_CLT_BYTE_RATE NUMBER
CUR_CLT_BYTE_PER_BUF NUMBER
CUR_BUF_RATE NUMBER
CUR_BYTE_RATE NUMBER
CUR_BYTE_PER_BUF NUMBER
CUR_IN_CONNECT_RATE NUMBER
CUR_OUT_CONNECT_RATE NUMBER
CUR_RECONNECT_RATE NUMBER
MAX_LOOP_RATE NUMBER
MAX_EVENT_RATE NUMBER
MAX_EVENTS_PER_LOOP NUMBER
MAX_MSG_RATE NUMBER
MAX_SVR_BUF_RATE NUMBER
MAX_SVR_BYTE_RATE NUMBER
MAX_SVR_BYTE_PER_BUF NUMBER
MAX_CLT_BUF_RATE NUMBER
MAX_CLT_BYTE_RATE NUMBER
MAX_CLT_BYTE_PER_BUF NUMBER
MAX_BUF_RATE NUMBER
MAX_BYTE_RATE NUMBER
MAX_BYTE_PER_BUF NUMBER
MAX_IN_CONNECT_RATE NUMBER
MAX_OUT_CONNECT_RATE NUMBER
MAX_RECONNECT_RATE NUMBER
AVG_LOOP_RATE NUMBER
AVG_EVENT_RATE NUMBER
AVG_EVENTS_PER_LOOP NUMBER
AVG_MSG_RATE NUMBER
AVG_SVR_BUF_RATE NUMBER
AVG_SVR_BYTE_RATE NUMBER
AVG_SVR_BYTE_PER_BUF NUMBER
AVG_CLT_BUF_RATE NUMBER
AVG_CLT_BYTE_RATE NUMBER
AVG_CLT_BYTE_PER_BUF NUMBER
AVG_BUF_RATE NUMBER
AVG_BYTE_RATE NUMBER
AVG_BYTE_PER_BUF NUMBER
AVG_IN_CONNECT_RATE NUMBER
AVG_OUT_CONNECT_RATE NUMBER
AVG_RECONNECT_RATE NUMBER
TTL_LOOPS NUMBER
TTL_MSG NUMBER
TTL_SVR_BUF NUMBER
TTL_CLT_BUF NUMBER
TTL_BUF NUMBER
TTL_IN_CONNECT NUMBER
TTL_OUT_CONNECT NUMBER
TTL_RECONNECT NUMBER
SCALE_LOOPS NUMBER
SCALE_MSG NUMBER
SCALE_SVR_BUF NUMBER
SCALE_CLT_BUF NUMBER
SCALE_BUF NUMBER
SCALE_IN_CONNECT NUMBER
SCALE_OUT_CONNECT NUMBER
SCALE_RECONNECT NUMBER
SQL> desc V$SHARED_SERVER;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(4)
PADDR RAW(4)
STATUS VARCHAR2(16)
MESSAGES NUMBER
BYTES NUMBER
BREAKS NUMBER
CIRCUIT RAW(4)
IDLE NUMBER
BUSY NUMBER
REQUESTS NUMBER
SQL> desc V$QUEUE;
Name Null? Type
----------------------------------------- -------- ----------------------------
PADDR RAW(4)
TYPE VARCHAR2(10)
QUEUED NUMBER
WAIT NUMBER
TOTALQ NUMBER
SQL> desc V$REQDIST;
Name Null? Type
----------------------------------------- -------- ----------------------------
BUCKET NUMBER
COUNT NUMBER
SQL> desc V$CIRCUIT;
Name Null? Type
----------------------------------------- -------- ----------------------------
CIRCUIT RAW(4)
DISPATCHER RAW(4)
SERVER RAW(4)
WAITER RAW(4)
SADDR RAW(4)
STATUS VARCHAR2(16)
QUEUE VARCHAR2(16)
MESSAGE0 NUMBER
MESSAGE1 NUMBER
MESSAGE2 NUMBER
MESSAGE3 NUMBER
MESSAGES NUMBER
BYTES NUMBER
BREAKS NUMBER
PRESENTATION VARCHAR2(257)
PCIRCUIT RAW(4)
SQL> desc V$LOADPSTAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(31)
TABNAME VARCHAR2(31)
PARTNAME VARCHAR2(31)
LOADED NUMBER
SQL> desc V$LOADISTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(31)
TABNAME VARCHAR2(31)
INDEXNAME VARCHAR2(31)
SUBNAME VARCHAR2(31)
MESSAGE_NUM NUMBER
MESSAGE VARCHAR2(4000)
SQL> desc V$LIBRARY_CACHE_MEMORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
LC_NAMESPACE VARCHAR2(15)
LC_INUSE_MEMORY_OBJECTS NUMBER
LC_INUSE_MEMORY_SIZE NUMBER
LC_FREEABLE_MEMORY_OBJECTS NUMBER
LC_FREEABLE_MEMORY_SIZE NUMBER
SQL> desc V$SHARED_POOL_ADVICE;
Name Null? Type
----------------------------------------- -------- ----------------------------
SHARED_POOL_SIZE_FOR_ESTIMATE NUMBER
SHARED_POOL_SIZE_FACTOR NUMBER
ESTD_LC_SIZE NUMBER
ESTD_LC_MEMORY_OBJECTS NUMBER
ESTD_LC_TIME_SAVED NUMBER
ESTD_LC_TIME_SAVED_FACTOR NUMBER
ESTD_LC_LOAD_TIME NUMBER
ESTD_LC_LOAD_TIME_FACTOR NUMBER
ESTD_LC_MEMORY_OBJECT_HITS NUMBER
SQL> desc V$JAVA_LIBRARY_CACHE_MEMORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
LC_NAMESPACE VARCHAR2(15)
LC_INUSE_MEMORY_OBJECTS NUMBER
LC_INUSE_MEMORY_SIZE NUMBER
LC_FREEABLE_MEMORY_OBJECTS NUMBER
LC_FREEABLE_MEMORY_SIZE NUMBER
SQL> desc V$JAVA_POOL_ADVICE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
JAVA_POOL_SIZE_FOR_ESTIMATE NUMBER
JAVA_POOL_SIZE_FACTOR NUMBER
ESTD_LC_SIZE NUMBER
ESTD_LC_MEMORY_OBJECTS NUMBER
ESTD_LC_TIME_SAVED NUMBER
ESTD_LC_TIME_SAVED_FACTOR NUMBER
ESTD_LC_LOAD_TIME NUMBER
ESTD_LC_LOAD_TIME_FACTOR NUMBER
ESTD_LC_MEMORY_OBJECT_HITS NUMBER
SQL> desc V$STREAMS_POOL_ADVICE;
Name Null? Type
----------------------------------------- -------- ----------------------------
STREAMS_POOL_SIZE_FOR_ESTIMATE NUMBER
STREAMS_POOL_SIZE_FACTOR NUMBER
ESTD_SPILL_COUNT NUMBER
ESTD_SPILL_TIME NUMBER
ESTD_UNSPILL_COUNT NUMBER
ESTD_UNSPILL_TIME NUMBER
SQL> desc V$LIBRARYCACHE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAMESPACE VARCHAR2(15)
GETS NUMBER
GETHITS NUMBER
GETHITRATIO NUMBER
PINS NUMBER
PINHITS NUMBER
PINHITRATIO NUMBER
RELOADS NUMBER
INVALIDATIONS NUMBER
DLM_LOCK_REQUESTS NUMBER
DLM_PIN_REQUESTS NUMBER
DLM_PIN_RELEASES NUMBER
DLM_INVALIDATION_REQUESTS NUMBER
DLM_INVALIDATIONS NUMBER
SQL> desc V$SQLAREA;
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
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(797)
OPTIMIZER_ENV_HASH_VALUE NUMBER
PARSING_USER_ID NUMBER
PARSING_SCHEMA_ID NUMBER
PARSING_SCHEMA_NAME VARCHAR2(30)
KEPT_VERSIONS NUMBER
ADDRESS RAW(4)
HASH_VALUE NUMBER
OLD_HASH_VALUE NUMBER
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(4)
REMOTE VARCHAR2(1)
OBJECT_STATUS VARCHAR2(19)
LITERAL_HASH_VALUE NUMBER
LAST_LOAD_TIME DATE
IS_OBSOLETE VARCHAR2(1)
CHILD_LATCH NUMBER
SQL_PROFILE VARCHAR2(64)
PROGRAM_ID NUMBER
PROGRAM_LINE# NUMBER
EXACT_MATCHING_SIGNATURE NUMBER
FORCE_MATCHING_SIGNATURE NUMBER
LAST_ACTIVE_TIME DATE
BIND_DATA RAW(2000)
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
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(797)
OPTIMIZER_ENV_HASH_VALUE NUMBER
PARSING_USER_ID NUMBER
PARSING_SCHEMA_ID NUMBER
PARSING_SCHEMA_NAME VARCHAR2(30)
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
SERVICE VARCHAR2(64)
SERVICE_HASH 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
EXACT_MATCHING_SIGNATURE NUMBER
FORCE_MATCHING_SIGNATURE NUMBER
LAST_ACTIVE_TIME DATE
BIND_DATA RAW(2000)
SQL> desc V$SQLAREA_PLAN_HASH;
Name Null? Type
----------------------------------------- -------- ----------------------------
SQL_TEXT VARCHAR2(1000)
SQL_FULLTEXT CLOB
ADDRESS RAW(4)
HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
PLAN_HASH_VALUE NUMBER
VERSION_COUNT NUMBER
LAST_ACTIVE_CHILD_ADDRESS RAW(4)
SHARABLE_MEM NUMBER
PERSISTENT_MEM NUMBER
RUNTIME_MEM NUMBER
SORTS NUMBER
LOADED_VERSIONS NUMBER
OPEN_VERSIONS NUMBER
USERS_OPENING NUMBER
USERS_EXECUTING NUMBER
FETCHES NUMBER
EXECUTIONS NUMBER
PX_SERVERS_EXECUTIONS NUMBER
END_OF_FETCH_COUNT NUMBER
LOADS NUMBER
FIRST_LOAD_TIME DATE
LAST_LOAD_TIME DATE
LAST_ACTIVE_TIME DATE
INVALIDATIONS NUMBER
PARSE_CALLS NUMBER
DISK_READS NUMBER
DIRECT_WRITES NUMBER
BUFFER_GETS NUMBER
CPU_TIME NUMBER
ELAPSED_TIME 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(797)
OPTIMIZER_ENV_HASH_VALUE NUMBER
PARSING_USER_ID NUMBER
PARSING_SCHEMA_ID NUMBER
PARSING_SCHEMA_NAME VARCHAR2(30)
KEPT_VERSIONS NUMBER
MODULE VARCHAR2(64)
MODULE_HASH NUMBER
ACTION VARCHAR2(64)
ACTION_HASH NUMBER
SERIALIZABLE_ABORTS NUMBER
OUTLINE_CATEGORY VARCHAR2(64)
OUTLINE_SID VARCHAR2(40)
REMOTE VARCHAR2(1)
OBJECT_STATUS VARCHAR2(19)
LITERAL_HASH_VALUE NUMBER
SQL_PROFILE VARCHAR2(64)
PROGRAM_ID NUMBER
PROGRAM_LINE# NUMBER
EXACT_MATCHING_SIGNATURE NUMBER
FORCE_MATCHING_SIGNATURE NUMBER
BIND_DATA RAW(2000)
SQL> desc V$SQL_SHARED_MEMORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
SQL_TEXT VARCHAR2(1000)
SQL_FULLTEXT CLOB
HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
HEAP_DESC RAW(4)
STRUCTURE VARCHAR2(16)
FUNCTION VARCHAR2(16)
CHUNK_COM VARCHAR2(16)
CHUNK_PTR RAW(4)
CHUNK_SIZE NUMBER
ALLOC_CLASS VARCHAR2(8)
CHUNK_TYPE NUMBER
SUBHEAP_DESC RAW(4)
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$SQLTEXT_WITH_NEWLINES ;
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$OPEN_CURSOR;
Name Null? Type
----------------------------------------- -------- ----------------------------
SADDR RAW(4)
SID NUMBER
USER_NAME VARCHAR2(30)
ADDRESS RAW(4)
HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
SQL_TEXT VARCHAR2(60)
SQL> desc V$SUBCACHE;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER_NAME VARCHAR2(64)
NAME VARCHAR2(1000)
TYPE NUMBER
HEAP_NUM NUMBER
CACHE_ID NUMBER
CACHE_CNT NUMBER
HEAP_SZ NUMBER
HEAP_ALOC NUMBER
HEAP_USED NUMBER
SQL> desc V$DB_OBJECT_CACHE;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(64)
NAME VARCHAR2(1000)
DB_LINK VARCHAR2(64)
NAMESPACE VARCHAR2(28)
TYPE VARCHAR2(28)
SHARABLE_MEM NUMBER
LOADS NUMBER
EXECUTIONS NUMBER
LOCKS NUMBER
PINS NUMBER
KEPT VARCHAR2(3)
CHILD_LATCH NUMBER
INVALIDATIONS NUMBER
SQL> desc V$DB_PIPES;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNERID NUMBER
NAME VARCHAR2(1000)
TYPE VARCHAR2(7)
PIPE_SIZE NUMBER
SQL> desc V$VERSION ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BANNER VARCHAR2(64)
SQL> desc V$CONTROLFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATUS VARCHAR2(7)
NAME VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
BLOCK_SIZE NUMBER
FILE_SIZE_BLKS NUMBER
SQL> desc V$DATABASE;
Name Null? Type
----------------------------------------- -------- ----------------------------
DBID NUMBER
NAME VARCHAR2(9)
CREATED DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
PRIOR_RESETLOGS_CHANGE# NUMBER
PRIOR_RESETLOGS_TIME DATE
LOG_MODE VARCHAR2(12)
CHECKPOINT_CHANGE# NUMBER
ARCHIVE_CHANGE# NUMBER
CONTROLFILE_TYPE VARCHAR2(7)
CONTROLFILE_CREATED DATE
CONTROLFILE_SEQUENCE# NUMBER
CONTROLFILE_CHANGE# NUMBER
CONTROLFILE_TIME DATE
OPEN_RESETLOGS VARCHAR2(11)
VERSION_TIME DATE
OPEN_MODE VARCHAR2(10)
PROTECTION_MODE VARCHAR2(20)
PROTECTION_LEVEL VARCHAR2(20)
REMOTE_ARCHIVE VARCHAR2(8)
ACTIVATION# NUMBER
SWITCHOVER# NUMBER
DATABASE_ROLE VARCHAR2(16)
ARCHIVELOG_CHANGE# NUMBER
ARCHIVELOG_COMPRESSION VARCHAR2(8)
SWITCHOVER_STATUS VARCHAR2(20)
DATAGUARD_BROKER VARCHAR2(8)
GUARD_STATUS VARCHAR2(7)
SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(3)
FORCE_LOGGING VARCHAR2(3)
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2(101)
RECOVERY_TARGET_INCARNATION# NUMBER
LAST_OPEN_INCARNATION# NUMBER
CURRENT_SCN NUMBER
FLASHBACK_ON VARCHAR2(18)
SUPPLEMENTAL_LOG_DATA_FK VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2(3)
DB_UNIQUE_NAME VARCHAR2(30)
STANDBY_BECAME_PRIMARY_SCN NUMBER
FS_FAILOVER_STATUS VARCHAR2(21)
FS_FAILOVER_CURRENT_TARGET VARCHAR2(30)
FS_FAILOVER_THRESHOLD NUMBER
FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7)
FS_FAILOVER_OBSERVER_HOST VARCHAR2(512)
SQL> desc V$THREAD;
Name Null? Type
----------------------------------------- -------- ----------------------------
THREAD# NUMBER
STATUS VARCHAR2(6)
ENABLED VARCHAR2(8)
GROUPS NUMBER
INSTANCE VARCHAR2(80)
OPEN_TIME DATE
CURRENT_GROUP# NUMBER
SEQUENCE# NUMBER
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
ENABLE_CHANGE# NUMBER
ENABLE_TIME DATE
DISABLE_CHANGE# NUMBER
DISABLE_TIME DATE
LAST_REDO_SEQUENCE# NUMBER
LAST_REDO_BLOCK NUMBER
LAST_REDO_CHANGE# NUMBER
LAST_REDO_TIME DATE
SQL> desc V$INSTANCE_LOG_GROUP;
Name Null? Type
----------------------------------------- -------- ----------------------------
THREAD# NUMBER
STATUS VARCHAR2(6)
ENABLED VARCHAR2(8)
GROUPS NUMBER
INSTANCE VARCHAR2(80)
OPEN_TIME DATE
CURRENT_GROUP# NUMBER
SEQUENCE# NUMBER
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
ENABLE_CHANGE# NUMBER
ENABLE_TIME DATE
DISABLE_CHANGE# NUMBER
DISABLE_TIME DATE
SQL> desc V$LOG ;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
MEMBERS NUMBER
ARCHIVED VARCHAR2(3)
STATUS VARCHAR2(16)
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
SQL> desc V$STANDBY_LOG;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# NUMBER
DBID VARCHAR2(40)
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
USED NUMBER
ARCHIVED VARCHAR2(3)
STATUS VARCHAR2(10)
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
LAST_CHANGE# NUMBER
LAST_TIME DATE
SQL> desc V$DATAFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR2(7)
ENABLED VARCHAR2(10)
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
UNRECOVERABLE_CHANGE# NUMBER
UNRECOVERABLE_TIME DATE
LAST_CHANGE# NUMBER
LAST_TIME DATE
OFFLINE_CHANGE# NUMBER
ONLINE_CHANGE# NUMBER
ONLINE_TIME DATE
BYTES NUMBER
BLOCKS NUMBER
CREATE_BYTES NUMBER
BLOCK_SIZE NUMBER
NAME VARCHAR2(513)
PLUGGED_IN NUMBER
BLOCK1_OFFSET NUMBER
AUX_NAME VARCHAR2(513)
FIRST_NONLOGGED_SCN NUMBER
FIRST_NONLOGGED_TIME DATE
SQL> desc V$TEMPFILE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR2(7)
ENABLED VARCHAR2(10)
BYTES NUMBER
BLOCKS NUMBER
CREATE_BYTES NUMBER
BLOCK_SIZE NUMBER
NAME VARCHAR2(513)
SQL> desc V$LOGHIST;
Name Null? Type
----------------------------------------- -------- ----------------------------
THREAD# NUMBER
SEQUENCE# NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
SWITCH_CHANGE# NUMBER
SQL> desc V$SEGSTAT_NAME ;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTIC# NUMBER
NAME VARCHAR2(64)
SAMPLED VARCHAR2(3)
SQL> desc V$SEGSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
TS# NUMBER
OBJ# NUMBER
DATAOBJ# NUMBER
STATISTIC_NAME VARCHAR2(64)
STATISTIC# NUMBER
VALUE NUMBER
SQL> desc V$SEGMENT_STATISTICS;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
SUBOBJECT_NAME VARCHAR2(30)
TABLESPACE_NAME VARCHAR2(30)
TS# NUMBER
OBJ# NUMBER
DATAOBJ# NUMBER
OBJECT_TYPE VARCHAR2(18)
STATISTIC_NAME VARCHAR2(64)
STATISTIC# NUMBER
VALUE NUMBER
SQL> desc V$BUFFER_POOL ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
RESIZE_STATE VARCHAR2(10)
CURRENT_SIZE NUMBER
BUFFERS NUMBER
TARGET_SIZE NUMBER
TARGET_BUFFERS NUMBER
PREV_SIZE NUMBER
PREV_BUFFERS NUMBER
LO_BNUM NUMBER
HI_BNUM NUMBER
LO_SETID NUMBER
HI_SETID NUMBER
SET_COUNT NUMBER
SQL> desc V$BUFFER_POOL_STATISTICS;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
SET_MSIZE NUMBER
CNUM_REPL NUMBER
CNUM_WRITE NUMBER
CNUM_SET NUMBER
BUF_GOT NUMBER
SUM_WRITE NUMBER
SUM_SCAN NUMBER
FREE_BUFFER_WAIT NUMBER
WRITE_COMPLETE_WAIT NUMBER
BUFFER_BUSY_WAIT NUMBER
FREE_BUFFER_INSPECTED NUMBER
DIRTY_BUFFERS_INSPECTED NUMBER
DB_BLOCK_CHANGE NUMBER
DB_BLOCK_GETS NUMBER
CONSISTENT_GETS NUMBER
PHYSICAL_READS NUMBER
PHYSICAL_WRITES NUMBER
SQL> desc V$INSTANCE;
Name Null? Type
----------------------------------------- -------- ----------------------------
INSTANCE_NUMBER NUMBER
INSTANCE_NAME VARCHAR2(16)
HOST_NAME VARCHAR2(64)
VERSION VARCHAR2(17)
STARTUP_TIME DATE
STATUS VARCHAR2(12)
PARALLEL VARCHAR2(3)
THREAD# NUMBER
ARCHIVER VARCHAR2(7)
LOG_SWITCH_WAIT VARCHAR2(15)
LOGINS VARCHAR2(10)
SHUTDOWN_PENDING VARCHAR2(3)
DATABASE_STATUS VARCHAR2(17)
INSTANCE_ROLE VARCHAR2(18)
ACTIVE_STATE VARCHAR2(9)
BLOCKED VARCHAR2(3)
SQL> desc V$TYPE_SIZE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
COMPONENT VARCHAR2(8)
TYPE VARCHAR2(8)
DESCRIPTION VARCHAR2(32)
TYPE_SIZE NUMBER
SQL> desc V$NLS_PARAMETERS;
Name Null? Type
----------------------------------------- -------- ----------------------------
PARAMETER VARCHAR2(64)
VALUE VARCHAR2(64)
SQL> desc V$NLS_VALID_VALUES;
Name Null? Type
----------------------------------------- -------- ----------------------------
PARAMETER VARCHAR2(64)
VALUE VARCHAR2(64)
ISDEPRECATED VARCHAR2(5)
SQL> desc V$OPTION ;
Name Null? Type
----------------------------------------- -------- ----------------------------
PARAMETER VARCHAR2(64)
VALUE VARCHAR2(64)
SQL> desc V$RECOVER_FILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
ONLINE VARCHAR2(7)
ONLINE_STATUS VARCHAR2(7)
ERROR VARCHAR2(18)
CHANGE# NUMBER
TIME DATE
SQL> desc V$BACKUP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
STATUS VARCHAR2(18)
CHANGE# NUMBER
TIME DATE
SQL> desc V$LOG_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
SQL> desc V$ARCHIVE_GAP;
Name Null? Type
----------------------------------------- -------- ----------------------------
THREAD# NUMBER
LOW_SEQUENCE# NUMBER
HIGH_SEQUENCE# NUMBER
SQL> desc V$RECOVERY_LOG;
Name Null? Type
----------------------------------------- -------- ----------------------------
THREAD# NUMBER
SEQUENCE# NUMBER
TIME DATE
ARCHIVE_NAME VARCHAR2(513)
SQL> desc V$FIXED_TABLE;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(30)
OBJECT_ID NUMBER
TYPE VARCHAR2(5)
TABLE_NUM NUMBER
SQL> desc V$INDEXED_FIXED_COLUMN;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLE_NAME VARCHAR2(30)
INDEX_NUMBER NUMBER
COLUMN_NAME VARCHAR2(30)
COLUMN_POSITION NUMBER
SQL> desc V$FIXED_VIEW_DEFINITION;
Name Null? Type
----------------------------------------- -------- ----------------------------
VIEW_NAME VARCHAR2(30)
VIEW_DEFINITION VARCHAR2(4000)
SQL> desc V$SESSION_CURSOR_CACHE;
Name Null? Type
----------------------------------------- -------- ----------------------------
MAXIMUM NUMBER
COUNT NUMBER
OPENED_ONCE NUMBER
OPEN NUMBER
OPENS NUMBER
HITS NUMBER
HIT_RATIO NUMBER
SQL> desc V$SYSTEM_CURSOR_CACHE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
OPENS NUMBER
HITS NUMBER
HIT_RATIO NUMBER
SQL> desc V$SHARED_SERVER_MONITOR ;
Name Null? Type
----------------------------------------- -------- ----------------------------
MAXIMUM_CONNECTIONS NUMBER
MAXIMUM_SESSIONS NUMBER
SERVERS_STARTED NUMBER
SERVERS_TERMINATED NUMBER
SERVERS_HIGHWATER NUMBER
SQL> desc V$PWFILE_USERS;
Name Null? Type
----------------------------------------- -------- ----------------------------
USERNAME VARCHAR2(30)
SYSDBA VARCHAR2(5)
SYSOPER VARCHAR2(5)
SQL> desc V$DBLINK;
Name Null? Type
----------------------------------------- -------- ----------------------------
DB_LINK VARCHAR2(128)
OWNER_ID NUMBER
LOGGED_ON VARCHAR2(3)
HETEROGENEOUS VARCHAR2(3)
PROTOCOL VARCHAR2(6)
OPEN_CURSORS NUMBER
IN_TRANSACTION VARCHAR2(3)
UPDATE_SENT VARCHAR2(3)
COMMIT_POINT_STRENGTH NUMBER
SQL> desc V$PQ_SLAVE;
Name Null? Type
----------------------------------------- -------- ----------------------------
SLAVE_NAME VARCHAR2(4)
STATUS VARCHAR2(4)
SESSIONS NUMBER
IDLE_TIME_CUR NUMBER
BUSY_TIME_CUR NUMBER
CPU_SECS_CUR NUMBER
MSGS_SENT_CUR NUMBER
MSGS_RCVD_CUR NUMBER
IDLE_TIME_TOTAL NUMBER
BUSY_TIME_TOTAL NUMBER
CPU_SECS_TOTAL NUMBER
MSGS_SENT_TOTAL NUMBER
MSGS_RCVD_TOTAL NUMBER
SQL> desc V$PX_PROCESS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVER_NAME VARCHAR2(4)
STATUS VARCHAR2(9)
PID NUMBER
SPID VARCHAR2(12)
SID NUMBER
SERIAL# NUMBER
SQL> desc V$PQ_SESSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTIC VARCHAR2(30)
LAST_QUERY NUMBER
SESSION_TOTAL NUMBER
SQL> desc V$PQ_SYSSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTIC VARCHAR2(30)
VALUE NUMBER
SQL> desc V$PX_PROCESS_SYSSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTIC VARCHAR2(30)
VALUE NUMBER
SQL> desc V$PX_BUFFER_ADVICE;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTIC VARCHAR2(30)
VALUE NUMBER
SQL> desc V$EXECUTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
PID NUMBER
DEPTH NUMBER
FUNCTION VARCHAR2(10)
TYPE VARCHAR2(7)
NVALS NUMBER
VAL1 NUMBER
VAL2 NUMBER
SEQH NUMBER
SEQL NUMBER
SQL> desc V$RECOVERY_STATUS;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECOVERY_CHECKPOINT DATE
THREAD NUMBER
SEQUENCE_NEEDED NUMBER
SCN_NEEDED VARCHAR2(16)
TIME_NEEDED DATE
PREVIOUS_LOG_NAME VARCHAR2(513)
PREVIOUS_LOG_STATUS VARCHAR2(13)
REASON VARCHAR2(13)
SQL> desc V$RECOVERY_FILE_STATUS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILENUM NUMBER
FILENAME VARCHAR2(513)
STATUS VARCHAR2(13)
SQL> desc V$SHARED_POOL_RESERVED;
Name Null? Type
----------------------------------------- -------- ----------------------------
FREE_SPACE NUMBER
AVG_FREE_SIZE NUMBER
FREE_COUNT NUMBER
MAX_FREE_SIZE NUMBER
USED_SPACE NUMBER
AVG_USED_SIZE NUMBER
USED_COUNT NUMBER
MAX_USED_SIZE NUMBER
REQUESTS NUMBER
REQUEST_MISSES NUMBER
LAST_MISS_SIZE NUMBER
MAX_MISS_SIZE NUMBER
REQUEST_FAILURES NUMBER
LAST_FAILURE_SIZE NUMBER
ABORTED_REQUEST_THRESHOLD NUMBER
ABORTED_REQUESTS NUMBER
LAST_ABORTED_SIZE NUMBER
SQL> desc V$SORT_SEGMENT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME VARCHAR2(31)
SEGMENT_FILE NUMBER
SEGMENT_BLOCK NUMBER
EXTENT_SIZE NUMBER
CURRENT_USERS NUMBER
TOTAL_EXTENTS NUMBER
TOTAL_BLOCKS NUMBER
USED_EXTENTS NUMBER
USED_BLOCKS NUMBER
FREE_EXTENTS NUMBER
FREE_BLOCKS NUMBER
ADDED_EXTENTS NUMBER
EXTENT_HITS NUMBER
FREED_EXTENTS NUMBER
FREE_REQUESTS NUMBER
MAX_SIZE NUMBER
MAX_BLOCKS NUMBER
MAX_USED_SIZE NUMBER
MAX_USED_BLOCKS NUMBER
MAX_SORT_SIZE NUMBER
MAX_SORT_BLOCKS NUMBER
RELATIVE_FNO NUMBER
SQL> desc V$SORT_USAGE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
USERNAME VARCHAR2(30)
USER VARCHAR2(30)
SESSION_ADDR RAW(4)
SESSION_NUM NUMBER
SQLADDR RAW(4)
SQLHASH NUMBER
SQL_ID VARCHAR2(13)
TABLESPACE VARCHAR2(31)
CONTENTS VARCHAR2(9)
SEGTYPE VARCHAR2(9)
SEGFILE# NUMBER
SEGBLK# NUMBER
EXTENTS NUMBER
BLOCKS NUMBER
SEGRFNO# NUMBER
SQL> desc V$TEMP_EXTENT_MAP;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME NOT NULL VARCHAR2(30)
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
OWNER NUMBER
RELATIVE_FNO NUMBER
SQL> desc V$TEMP_EXTENT_POOL;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME NOT NULL VARCHAR2(30)
FILE_ID NUMBER
EXTENTS_CACHED NUMBER
EXTENTS_USED NUMBER
BLOCKS_CACHED NUMBER
BLOCKS_USED NUMBER
BYTES_CACHED NUMBER
BYTES_USED NUMBER
RELATIVE_FNO NUMBER
SQL> desc V$TEMP_SPACE_HEADER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME NOT NULL VARCHAR2(30)
FILE_ID NUMBER
BYTES_USED NUMBER
BLOCKS_USED NUMBER
BYTES_FREE NUMBER
BLOCKS_FREE NUMBER
RELATIVE_FNO NUMBER
SQL> desc V$_SEQUENCES;
Name Null? Type
----------------------------------------- -------- ----------------------------
SEQUENCE_OWNER VARCHAR2(64)
SEQUENCE_NAME VARCHAR2(1000)
OBJECT# NUMBER
ACTIVE_FLAG VARCHAR2(1)
REPLENISH_FLAG VARCHAR2(1)
WRAP_FLAG VARCHAR2(1)
NEXTVALUE NUMBER
MIN_VALUE NUMBER
MAX_VALUE NUMBER
INCREMENT_BY NUMBER
CYCLE_FLAG VARCHAR2(1)
ORDER_FLAG VARCHAR2(1)
CACHE_SIZE NUMBER
HIGHWATER NUMBER
BACKGROUND_INSTANCE_LOCK VARCHAR2(1)
INSTANCE_LOCK_FLAGS NUMBER
SQL> desc V$PQ_TQSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
DFO_NUMBER NUMBER
TQ_ID NUMBER
SERVER_TYPE VARCHAR2(10)
NUM_ROWS NUMBER
BYTES NUMBER
OPEN_TIME NUMBER
AVG_LATENCY NUMBER
WAITS NUMBER
TIMEOUTS NUMBER
PROCESS VARCHAR2(10)
INSTANCE NUMBER
SQL> desc V$ACTIVE_INSTANCES;
Name Null? Type
----------------------------------------- -------- ----------------------------
INST_NUMBER NUMBER
INST_NAME VARCHAR2(60)
SQL> desc V$SQL_CURSOR ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CURNO NUMBER
FLAG NUMBER
STATUS VARCHAR2(9)
PARENT_HANDLE RAW(4)
PARENT_LOCK RAW(4)
CHILD_LOCK RAW(4)
CHILD_PIN RAW(4)
PERS_HEAP_MEM NUMBER
WORK_HEAP_MEM NUMBER
BIND_VARS NUMBER
DEFINE_VARS NUMBER
BIND_MEM_LOC VARCHAR2(64)
INST_FLAG VARCHAR2(64)
INST_FLAG2 VARCHAR2(64)
CHILD_HANDLE RAW(4)
SQL> desc V$SQL_BIND_METADATA;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS RAW(4)
POSITION NUMBER
DATATYPE NUMBER
MAX_LENGTH NUMBER
ARRAY_LEN NUMBER
BIND_NAME VARCHAR2(30)
SQL> desc V$SQL_SHARED_CURSOR;
Name Null? Type
----------------------------------------- -------- ----------------------------
SQL_ID VARCHAR2(13)
ADDRESS RAW(4)
CHILD_ADDRESS RAW(4)
CHILD_NUMBER NUMBER
UNBOUND_CURSOR VARCHAR2(1)
SQL_TYPE_MISMATCH VARCHAR2(1)
OPTIMIZER_MISMATCH VARCHAR2(1)
OUTLINE_MISMATCH VARCHAR2(1)
STATS_ROW_MISMATCH VARCHAR2(1)
LITERAL_MISMATCH VARCHAR2(1)
SEC_DEPTH_MISMATCH VARCHAR2(1)
EXPLAIN_PLAN_CURSOR VARCHAR2(1)
BUFFERED_DML_MISMATCH VARCHAR2(1)
PDML_ENV_MISMATCH VARCHAR2(1)
INST_DRTLD_MISMATCH VARCHAR2(1)
SLAVE_QC_MISMATCH VARCHAR2(1)
TYPECHECK_MISMATCH VARCHAR2(1)
AUTH_CHECK_MISMATCH VARCHAR2(1)
BIND_MISMATCH VARCHAR2(1)
DESCRIBE_MISMATCH VARCHAR2(1)
LANGUAGE_MISMATCH VARCHAR2(1)
TRANSLATION_MISMATCH VARCHAR2(1)
ROW_LEVEL_SEC_MISMATCH VARCHAR2(1)
INSUFF_PRIVS VARCHAR2(1)
INSUFF_PRIVS_REM VARCHAR2(1)
REMOTE_TRANS_MISMATCH VARCHAR2(1)
LOGMINER_SESSION_MISMATCH VARCHAR2(1)
INCOMP_LTRL_MISMATCH VARCHAR2(1)
OVERLAP_TIME_MISMATCH VARCHAR2(1)
SQL_REDIRECT_MISMATCH VARCHAR2(1)
MV_QUERY_GEN_MISMATCH VARCHAR2(1)
USER_BIND_PEEK_MISMATCH VARCHAR2(1)
TYPCHK_DEP_MISMATCH VARCHAR2(1)
NO_TRIGGER_MISMATCH VARCHAR2(1)
FLASHBACK_CURSOR VARCHAR2(1)
ANYDATA_TRANSFORMATION VARCHAR2(1)
INCOMPLETE_CURSOR VARCHAR2(1)
TOP_LEVEL_RPI_CURSOR VARCHAR2(1)
DIFFERENT_LONG_LENGTH VARCHAR2(1)
LOGICAL_STANDBY_APPLY VARCHAR2(1)
DIFF_CALL_DURN VARCHAR2(1)
BIND_UACS_DIFF VARCHAR2(1)
PLSQL_CMP_SWITCHS_DIFF VARCHAR2(1)
CURSOR_PARTS_MISMATCH VARCHAR2(1)
STB_OBJECT_MISMATCH VARCHAR2(1)
ROW_SHIP_MISMATCH VARCHAR2(1)
PQ_SLAVE_MISMATCH VARCHAR2(1)
TOP_LEVEL_DDL_MISMATCH VARCHAR2(1)
MULTI_PX_MISMATCH VARCHAR2(1)
BIND_PEEKED_PQ_MISMATCH VARCHAR2(1)
MV_REWRITE_MISMATCH VARCHAR2(1)
ROLL_INVALID_MISMATCH VARCHAR2(1)
OPTIMIZER_MODE_MISMATCH VARCHAR2(1)
PX_MISMATCH VARCHAR2(1)
MV_STALEOBJ_MISMATCH VARCHAR2(1)
FLASHBACK_TABLE_MISMATCH VARCHAR2(1)
LITREP_COMP_MISMATCH VARCHAR2(1)
SQL> desc V$SQL_BIND_DATA ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CURSOR_NUM NUMBER
POSITION NUMBER
DATATYPE NUMBER
SHARED_MAX_LEN NUMBER
PRIVATE_MAX_LEN NUMBER
ARRAY_SIZE NUMBER
PRECISION NUMBER
SCALE NUMBER
SHARED_FLAG NUMBER
SHARED_FLAG2 NUMBER
BUF_ADDRESS RAW(4)
BUF_LENGTH NUMBER
VAL_LENGTH NUMBER
BUF_FLAG NUMBER
INDICATOR NUMBER
VALUE VARCHAR2(4000)
SQL> desc V$TABLESPACE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TS# NUMBER
NAME VARCHAR2(30)
INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3)
BIGFILE VARCHAR2(3)
FLASHBACK_ON VARCHAR2(3)
ENCRYPT_IN_BACKUP VARCHAR2(3)
SQL> desc V$RMAN_CONFIGURATION;
Name Null? Type
----------------------------------------- -------- ----------------------------
CONF# NUMBER
NAME VARCHAR2(65)
VALUE VARCHAR2(1025)
SQL> desc V$OFFLINE_RANGE;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
FILE# NUMBER
OFFLINE_CHANGE# NUMBER
ONLINE_CHANGE# NUMBER
ONLINE_TIME DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
SQL> desc V$ARCHIVED_LOG;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
NAME VARCHAR2(513)
DEST_ID NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
RESETLOGS_ID NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
NEXT_TIME DATE
BLOCKS NUMBER
BLOCK_SIZE NUMBER
CREATOR VARCHAR2(7)
REGISTRAR VARCHAR2(7)
STANDBY_DEST VARCHAR2(3)
ARCHIVED VARCHAR2(3)
APPLIED VARCHAR2(3)
DELETED VARCHAR2(3)
STATUS VARCHAR2(1)
COMPLETION_TIME DATE
DICTIONARY_BEGIN VARCHAR2(3)
DICTIONARY_END VARCHAR2(3)
END_OF_REDO VARCHAR2(3)
BACKUP_COUNT NUMBER
ARCHIVAL_THREAD# NUMBER
ACTIVATION# NUMBER
IS_RECOVERY_DEST_FILE VARCHAR2(3)
COMPRESSED VARCHAR2(3)
FAL VARCHAR2(3)
END_OF_REDO_TYPE VARCHAR2(10)
SQL> desc V$ARCHIVE_PROCESSES ;
Name Null? Type
----------------------------------------- -------- ----------------------------
PROCESS NUMBER
STATUS VARCHAR2(10)
LOG_SEQUENCE NUMBER
STATE VARCHAR2(4)
SQL> desc V$MANAGED_STANDBY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
PROCESS VARCHAR2(9)
PID NUMBER
STATUS VARCHAR2(12)
CLIENT_PROCESS VARCHAR2(8)
CLIENT_PID VARCHAR2(40)
CLIENT_DBID VARCHAR2(40)
GROUP# VARCHAR2(40)
RESETLOG_ID NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
DELAY_MINS NUMBER
KNOWN_AGENTS NUMBER
ACTIVE_AGENTS NUMBER
SQL> desc V$DATAGUARD_STATUS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FACILITY VARCHAR2(24)
SEVERITY VARCHAR2(13)
DEST_ID NUMBER
MESSAGE_NUM NUMBER
ERROR_CODE NUMBER
CALLOUT VARCHAR2(3)
TIMESTAMP DATE
MESSAGE VARCHAR2(256)
SQL> desc V$ARCHIVE_DEST;
Name Null? Type
----------------------------------------- -------- ----------------------------
DEST_ID NUMBER
DEST_NAME VARCHAR2(256)
STATUS VARCHAR2(9)
BINDING VARCHAR2(9)
NAME_SPACE VARCHAR2(7)
TARGET VARCHAR2(7)
ARCHIVER VARCHAR2(10)
SCHEDULE VARCHAR2(8)
DESTINATION VARCHAR2(256)
LOG_SEQUENCE NUMBER
REOPEN_SECS NUMBER
DELAY_MINS NUMBER
MAX_CONNECTIONS NUMBER
NET_TIMEOUT NUMBER
PROCESS VARCHAR2(10)
REGISTER VARCHAR2(3)
FAIL_DATE DATE
FAIL_SEQUENCE NUMBER
FAIL_BLOCK NUMBER
FAILURE_COUNT NUMBER
MAX_FAILURE NUMBER
ERROR VARCHAR2(256)
ALTERNATE VARCHAR2(256)
DEPENDENCY VARCHAR2(256)
REMOTE_TEMPLATE VARCHAR2(256)
QUOTA_SIZE NUMBER
QUOTA_USED NUMBER
MOUNTID NUMBER
TRANSMIT_MODE VARCHAR2(12)
ASYNC_BLOCKS NUMBER
AFFIRM VARCHAR2(3)
TYPE VARCHAR2(7)
VALID_NOW VARCHAR2(16)
VALID_TYPE VARCHAR2(15)
VALID_ROLE VARCHAR2(12)
DB_UNIQUE_NAME VARCHAR2(30)
VERIFY VARCHAR2(3)
SQL> desc V$ARCHIVE_DEST_STATUS;
Name Null? Type
----------------------------------------- -------- ----------------------------
DEST_ID NUMBER
DEST_NAME VARCHAR2(256)
STATUS VARCHAR2(9)
TYPE VARCHAR2(14)
DATABASE_MODE VARCHAR2(15)
RECOVERY_MODE VARCHAR2(23)
PROTECTION_MODE VARCHAR2(20)
DESTINATION VARCHAR2(256)
STANDBY_LOGFILE_COUNT NUMBER
STANDBY_LOGFILE_ACTIVE NUMBER
ARCHIVED_THREAD# NUMBER
ARCHIVED_SEQ# NUMBER
APPLIED_THREAD# NUMBER
APPLIED_SEQ# NUMBER
ERROR VARCHAR2(256)
SRL VARCHAR2(3)
DB_UNIQUE_NAME VARCHAR2(30)
SYNCHRONIZATION_STATUS VARCHAR2(22)
SYNCHRONIZED VARCHAR2(3)
SQL> desc V$DATAGUARD_CONFIG ;
Name Null? Type
----------------------------------------- -------- ----------------------------
DB_UNIQUE_NAME VARCHAR2(30)
SQL> desc V$SESSION_LONGOPS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
OPNAME VARCHAR2(64)
TARGET VARCHAR2(64)
TARGET_DESC VARCHAR2(32)
SOFAR NUMBER
TOTALWORK NUMBER
UNITS VARCHAR2(32)
START_TIME DATE
LAST_UPDATE_TIME DATE
TIMESTAMP DATE
TIME_REMAINING NUMBER
ELAPSED_SECONDS NUMBER
CONTEXT NUMBER
MESSAGE VARCHAR2(512)
USERNAME VARCHAR2(30)
SQL_ADDRESS RAW(4)
SQL_HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
QCSID NUMBER
SQL> desc V$ADVISOR_PROGRESS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
USERNAME VARCHAR2(30)
OPNAME VARCHAR2(64)
ADVISOR_NAME VARCHAR2(64)
TASK_ID NUMBER
TARGET_DESC VARCHAR2(32)
SOFAR NUMBER
TOTALWORK NUMBER
UNITS VARCHAR2(32)
BENEFIT_SOFAR NUMBER
BENEFIT_MAX NUMBER
FINDINGS NUMBER
RECOMMENDATIONS NUMBER
TIME_REMAINING NUMBER
START_TIME DATE
LAST_UPDATE_TIME DATE
ELAPSED_SECONDS NUMBER
ADVISOR_METRIC1 NUMBER
METRIC1_DESC VARCHAR2(64)
SQL> desc V$DATAFILE_COPy;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
NAME VARCHAR2(513)
TAG VARCHAR2(32)
FILE# NUMBER
RFILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
INCREMENTAL_LEVEL NUMBER
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
ABSOLUTE_FUZZY_CHANGE# NUMBER
RECOVERY_FUZZY_CHANGE# NUMBER
RECOVERY_FUZZY_TIME DATE
ONLINE_FUZZY VARCHAR2(3)
BACKUP_FUZZY VARCHAR2(3)
MARKED_CORRUPT NUMBER
MEDIA_CORRUPT NUMBER
LOGICALLY_CORRUPT NUMBER
BLOCKS NUMBER
BLOCK_SIZE NUMBER
OLDEST_OFFLINE_RANGE NUMBER
DELETED VARCHAR2(3)
STATUS VARCHAR2(1)
COMPLETION_TIME DATE
CONTROLFILE_TYPE VARCHAR2(1)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
SCANNED VARCHAR2(3)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
SQL> desc V$COPY_CORRUPTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
COPY_RECID NUMBER
COPY_STAMP NUMBER
FILE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
CORRUPTION_CHANGE# NUMBER
MARKED_CORRUPT VARCHAR2(3)
CORRUPTION_TYPE VARCHAR2(9)
SQL> desc V$BACKUP_SET;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
BACKUP_TYPE VARCHAR2(1)
CONTROLFILE_INCLUDED VARCHAR2(3)
INCREMENTAL_LEVEL NUMBER
PIECES NUMBER
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
BLOCK_SIZE NUMBER
INPUT_FILE_SCAN_ONLY VARCHAR2(3)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
SQL> desc V$BACKUP_PIECE;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
PIECE# NUMBER
COPY# NUMBER
DEVICE_TYPE VARCHAR2(17)
HANDLE VARCHAR2(513)
COMMENTS VARCHAR2(64)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
CONCUR VARCHAR2(3)
TAG VARCHAR2(32)
STATUS VARCHAR2(1)
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
DELETED VARCHAR2(3)
BYTES NUMBER
IS_RECOVERY_DEST_FILE VARCHAR2(3)
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
COMPRESSED VARCHAR2(3)
SQL> desc V$BACKUP_DATAFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
INCREMENTAL_LEVEL NUMBER
INCREMENTAL_CHANGE# NUMBER
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
ABSOLUTE_FUZZY_CHANGE# NUMBER
MARKED_CORRUPT NUMBER
MEDIA_CORRUPT NUMBER
LOGICALLY_CORRUPT NUMBER
DATAFILE_BLOCKS NUMBER
BLOCKS NUMBER
BLOCK_SIZE NUMBER
OLDEST_OFFLINE_RANGE NUMBER
COMPLETION_TIME DATE
CONTROLFILE_TYPE VARCHAR2(1)
USED_CHANGE_TRACKING VARCHAR2(3)
BLOCKS_READ NUMBER
USED_OPTIMIZATION VARCHAR2(3)
SQL> desc V$BACKUP_REDOLOG;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
NEXT_TIME DATE
BLOCKS NUMBER
BLOCK_SIZE NUMBER
SQL> desc V$BACKUP_CORRUPTION ;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
PIECE# NUMBER
FILE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
CORRUPTION_CHANGE# NUMBER
MARKED_CORRUPT VARCHAR2(3)
CORRUPTION_TYPE VARCHAR2(9)
SQL> desc V$DELETED_OBJECT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
TYPE VARCHAR2(26)
OBJECT_RECID NUMBER
OBJECT_STAMP NUMBER
OBJECT_DATA NUMBER
SQL> desc V$CONTROLFILE_RECORD_SECTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
TYPE VARCHAR2(28)
RECORD_SIZE NUMBER
RECORDS_TOTAL NUMBER
RECORDS_USED NUMBER
FIRST_INDEX NUMBER
LAST_INDEX NUMBER
LAST_RECID NUMBER
SQL> desc V$DATAFILE_HEADER;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
STATUS VARCHAR2(7)
ERROR VARCHAR2(18)
FORMAT NUMBER
RECOVER VARCHAR2(3)
FUZZY VARCHAR2(3)
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TABLESPACE_NAME VARCHAR2(30)
TS# NUMBER
RFILE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
CHECKPOINT_COUNT NUMBER
BYTES NUMBER
BLOCKS NUMBER
NAME VARCHAR2(513)
SPACE_HEADER VARCHAR2(40)
LAST_DEALLOC_SCN VARCHAR2(16)
SQL> desc V$SESSION_OBJECT_CACHE;
Name Null? Type
----------------------------------------- -------- ----------------------------
PINS NUMBER
HITS NUMBER
TRUE_HITS NUMBER
HIT_RATIO NUMBER
TRUE_HIT_RATIO NUMBER
OBJECT_REFRESHES NUMBER
CACHE_REFRESHES NUMBER
OBJECT_FLUSHES NUMBER
CACHE_FLUSHES NUMBER
CACHE_SHRINKS NUMBER
CACHED_OBJECTS NUMBER
PINNED_OBJECTS NUMBER
CACHE_SIZE NUMBER
OPTIMAL_SIZE NUMBER
MAXIMUM_SIZE NUMBER
SQL> desc V$GLOBAL_TRANSACTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
FORMATID NUMBER
GLOBALID RAW(64)
BRANCHID RAW(64)
BRANCHES NUMBER
REFCOUNT NUMBER
PREPARECOUNT NUMBER
STATE VARCHAR2(18)
FLAGS NUMBER
COUPLING VARCHAR2(15)
SQL> desc V$BACKUP_DEVICE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
DEVICE_TYPE VARCHAR2(17)
DEVICE_NAME VARCHAR2(513)
SQL> desc V$DLM_MISC ;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTIC# NUMBER
NAME VARCHAR2(38)
VALUE NUMBER
SQL> desc V$DLM_LATCH ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
LATCH# NUMBER
LEVEL# NUMBER
NAME VARCHAR2(50)
GETS NUMBER
MISSES NUMBER
SLEEPS NUMBER
IMMEDIATE_GETS NUMBER
IMMEDIATE_MISSES NUMBER
WAITERS_WOKEN NUMBER
WAITS_HOLDING_LATCH NUMBER
SPIN_GETS NUMBER
SLEEP1 NUMBER
SLEEP2 NUMBER
SLEEP3 NUMBER
SLEEP4 NUMBER
SLEEP5 NUMBER
SLEEP6 NUMBER
SLEEP7 NUMBER
SLEEP8 NUMBER
SLEEP9 NUMBER
SLEEP10 NUMBER
SLEEP11 NUMBER
WAIT_TIME NUMBER
SQL> desc V$DLM_CONVERT_LOCAL;
Name Null? Type
----------------------------------------- -------- ----------------------------
INST_ID NUMBER
CONVERT_TYPE VARCHAR2(16)
AVERAGE_CONVERT_TIME NUMBER
CONVERT_COUNT NUMBER
SQL> desc V$DLM_CONVERT_REMOTE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
INST_ID NUMBER
CONVERT_TYPE VARCHAR2(16)
AVERAGE_CONVERT_TIME NUMBER
CONVERT_COUNT NUMBER
SQL> desc V$RECOVERY_PROGRESS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
START_TIME DATE
TYPE VARCHAR2(64)
ITEM VARCHAR2(32)
UNITS VARCHAR2(32)
SOFAR NUMBER
TOTAL NUMBER
TIMESTAMP DATE
SQL> desc V$GES_ENQUEUE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
HANDLE RAW(4)
GRANT_LEVEL VARCHAR2(9)
REQUEST_LEVEL VARCHAR2(9)
RESOURCE_NAME1 VARCHAR2(30)
RESOURCE_NAME2 VARCHAR2(30)
PID NUMBER
TRANSACTION_ID0 NUMBER
TRANSACTION_ID1 NUMBER
GROUP_ID NUMBER
OPEN_OPT_DEADLOCK NUMBER
OPEN_OPT_PERSISTENT NUMBER
OPEN_OPT_PROCESS_OWNED NUMBER
OPEN_OPT_NO_XID NUMBER
CONVERT_OPT_GETVALUE NUMBER
CONVERT_OPT_PUTVALUE NUMBER
CONVERT_OPT_NOVALUE NUMBER
CONVERT_OPT_DUBVALUE NUMBER
CONVERT_OPT_NOQUEUE NUMBER
CONVERT_OPT_EXPRESS NUMBER
CONVERT_OPT_NODEADLOCKWAIT NUMBER
CONVERT_OPT_NODEADLOCKBLOCK NUMBER
WHICH_QUEUE NUMBER
STATE VARCHAR2(64)
AST_EVENT0 NUMBER
OWNER_NODE NUMBER
BLOCKED NUMBER
BLOCKER NUMBER
SQL> desc V$GES_BLOCKING_ENQUEUE;
Name Null? Type
----------------------------------------- -------- ----------------------------
HANDLE RAW(4)
GRANT_LEVEL VARCHAR2(9)
REQUEST_LEVEL VARCHAR2(9)
RESOURCE_NAME1 VARCHAR2(30)
RESOURCE_NAME2 VARCHAR2(30)
PID NUMBER
TRANSACTION_ID0 NUMBER
TRANSACTION_ID1 NUMBER
GROUP_ID NUMBER
OPEN_OPT_DEADLOCK NUMBER
OPEN_OPT_PERSISTENT NUMBER
OPEN_OPT_PROCESS_OWNED NUMBER
OPEN_OPT_NO_XID NUMBER
CONVERT_OPT_GETVALUE NUMBER
CONVERT_OPT_PUTVALUE NUMBER
CONVERT_OPT_NOVALUE NUMBER
CONVERT_OPT_DUBVALUE NUMBER
CONVERT_OPT_NOQUEUE NUMBER
CONVERT_OPT_EXPRESS NUMBER
CONVERT_OPT_NODEADLOCKWAIT NUMBER
CONVERT_OPT_NODEADLOCKBLOCK NUMBER
WHICH_QUEUE NUMBER
STATE VARCHAR2(64)
AST_EVENT0 NUMBER
OWNER_NODE NUMBER
BLOCKED NUMBER
BLOCKER NUMBER
SQL> desc V$DLM_ALL_LOCKS;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOCKP RAW(4)
GRANT_LEVEL VARCHAR2(9)
REQUEST_LEVEL VARCHAR2(9)
RESOURCE_NAME1 VARCHAR2(30)
RESOURCE_NAME2 VARCHAR2(30)
PID NUMBER
TRANSACTION_ID0 NUMBER
TRANSACTION_ID1 NUMBER
GROUP_ID NUMBER
OPEN_OPT_DEADLOCK NUMBER
OPEN_OPT_PERSISTENT NUMBER
OPEN_OPT_PROCESS_OWNED NUMBER
OPEN_OPT_NO_XID NUMBER
CONVERT_OPT_GETVALUE NUMBER
CONVERT_OPT_PUTVALUE NUMBER
CONVERT_OPT_NOVALUE NUMBER
CONVERT_OPT_DUBVALUE NUMBER
CONVERT_OPT_NOQUEUE NUMBER
CONVERT_OPT_EXPRESS NUMBER
CONVERT_OPT_NODEADLOCKWAIT NUMBER
CONVERT_OPT_NODEADLOCKBLOCK NUMBER
WHICH_QUEUE NUMBER
LOCKSTATE VARCHAR2(64)
AST_EVENT0 NUMBER
OWNER_NODE NUMBER
BLOCKED NUMBER
BLOCKER NUMBER
SQL> desc V$DLM_LOCKS;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOCKP RAW(4)
GRANT_LEVEL VARCHAR2(9)
REQUEST_LEVEL VARCHAR2(9)
RESOURCE_NAME1 VARCHAR2(30)
RESOURCE_NAME2 VARCHAR2(30)
PID NUMBER
TRANSACTION_ID0 NUMBER
TRANSACTION_ID1 NUMBER
GROUP_ID NUMBER
OPEN_OPT_DEADLOCK NUMBER
OPEN_OPT_PERSISTENT NUMBER
OPEN_OPT_PROCESS_OWNED NUMBER
OPEN_OPT_NO_XID NUMBER
CONVERT_OPT_GETVALUE NUMBER
CONVERT_OPT_PUTVALUE NUMBER
CONVERT_OPT_NOVALUE NUMBER
CONVERT_OPT_DUBVALUE NUMBER
CONVERT_OPT_NOQUEUE NUMBER
CONVERT_OPT_EXPRESS NUMBER
CONVERT_OPT_NODEADLOCKWAIT NUMBER
CONVERT_OPT_NODEADLOCKBLOCK NUMBER
WHICH_QUEUE NUMBER
LOCKSTATE VARCHAR2(64)
AST_EVENT0 NUMBER
OWNER_NODE NUMBER
BLOCKED NUMBER
BLOCKER NUMBER
SQL> desc V$DLM_RESS;
Name Null? Type
----------------------------------------- -------- ----------------------------
RESP RAW(4)
RESOURCE_NAME VARCHAR2(30)
ON_CONVERT_Q NUMBER
ON_GRANT_Q NUMBER
PERSISTENT_RES NUMBER
MASTER_NODE NUMBER
NEXT_CVT_LEVEL VARCHAR2(9)
VALUE_BLK_STATE VARCHAR2(32)
VALUE_BLK VARCHAR2(64)
SQL> desc V$GLOBAL_BLOCKED_LOCKS;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(4)
KADDR RAW(4)
SID NUMBER
TYPE VARCHAR2(2)
ID1 NUMBER
ID2 NUMBER
LMODE NUMBER
REQUEST NUMBER
CTIME NUMBER
SQL> desc V$AQ1 ;
Name Null? Type
----------------------------------------- -------- ----------------------------
QID NUMBER
WAITING NUMBER
READY NUMBER
EXPIRED NUMBER
TOTAL_CONSUMERS NUMBER
TOTAL_WAIT NUMBER
AVERAGE_WAIT NUMBER
SQL> desc V$CONTEXT;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAMESPACE VARCHAR2(31)
ATTRIBUTE VARCHAR2(31)
VALUE VARCHAR2(4000)
SQL> desc V$RSRC_CONSUMER_GROUP_CPU_MTH
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(40)
SQL> desc V$RSRC_PLAN_CPU_MTH;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(40)
SQL> desc V$MAX_ACTIVE_SESS_TARGET_MTH
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(40)
SQL> desc V$ACTIVE_SESS_POOL_MTH
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(40)
SQL> desc V$PARALLEL_DEGREE_LIMIT_MTH
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(40)
SQL> desc V$QUEUEING_MTH;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(40)
SQL> desc V$RSRC_CONSUMER_GROUP
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(32)
ACTIVE_SESSIONS NUMBER
EXECUTION_WAITERS NUMBER
REQUESTS NUMBER
CPU_WAIT_TIME NUMBER
CPU_WAITS NUMBER
CONSUMED_CPU_TIME NUMBER
YIELDS NUMBER
QUEUE_LENGTH NUMBER
CURRENT_UNDO_CONSUMPTION NUMBER
ACTIVE_SESSION_LIMIT_HIT NUMBER
SESSION_SWITCHES_IN NUMBER
SESSION_SWITCHES_OUT NUMBER
UNDO_LIMIT_HIT NUMBER
SQL_CANCELED NUMBER
ACTIVE_SESSIONS_KILLED NUMBER
IDLE_SESSIONS_KILLED NUMBER
IDLE_BLKR_SESSIONS_KILLED NUMBER
QUEUED_TIME NUMBER
QUEUE_TIME_OUTS NUMBER
SQL> desc V$RSRC_PLAN
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(32)
IS_TOP_PLAN VARCHAR2(5)
SQL> desc V$RSRC_PLAN_HISTORY
Name Null? Type
----------------------------------------- -------- ----------------------------
SEQUENCE# NUMBER
ID NUMBER
NAME VARCHAR2(30)
START_TIME DATE
END_TIME DATE
ENABLED_BY_SCHEDULER VARCHAR2(5)
WINDOW_NAME VARCHAR2(30)
ALLOWED_AUTOMATED_SWITCHES VARCHAR2(5)
SQL> desc V$RSRC_CONS_GROUP_HISTORY
Name Null? Type
----------------------------------------- -------- ----------------------------
SEQUENCE# NUMBER
ID NUMBER
NAME VARCHAR2(30)
REQUESTS NUMBER
CPU_WAIT_TIME NUMBER
CPU_WAITS NUMBER
CONSUMED_CPU_TIME NUMBER
YIELDS NUMBER
ACTIVE_SESS_LIMIT_HIT NUMBER
UNDO_LIMIT_HIT NUMBER
SESSION_SWITCHES_IN NUMBER
SESSION_SWITCHES_OUT NUMBER
SQL_CANCELED NUMBER
ACTIVE_SESS_KILLED NUMBER
IDLE_SESS_KILLED NUMBER
IDLE_BLKR_SESS_KILLED NUMBER
QUEUED_TIME NUMBER
QUEUE_TIME_OUTS NUMBER
SQL> desc V$HS_AGENT
Name Null? Type
----------------------------------------- -------- ----------------------------
AGENT_ID NUMBER
MACHINE VARCHAR2(64)
PROCESS VARCHAR2(9)
PROGRAM VARCHAR2(48)
OSUSER VARCHAR2(30)
STARTTIME DATE
AGENT_TYPE NUMBER
FDS_CLASS_ID NUMBER
FDS_INST_ID NUMBER
SQL> desc V$HS_SESSION;
Name Null? Type
----------------------------------------- -------- ----------------------------
HS_SESSION_ID NUMBER
AGENT_ID NUMBER
SID NUMBER
DB_LINK VARCHAR2(128)
DB_LINK_OWNER NUMBER
STARTTIME DATE
SQL> desc V$INSTANCE_RECOVERY;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECOVERY_ESTIMATED_IOS NUMBER
ACTUAL_REDO_BLKS NUMBER
TARGET_REDO_BLKS NUMBER
LOG_FILE_SIZE_REDO_BLKS NUMBER
LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER
LOG_CHKPT_INTERVAL_REDO_BLKS NUMBER
FAST_START_IO_TARGET_REDO_BLKS NUMBER
TARGET_MTTR NUMBER
ESTIMATED_MTTR NUMBER
CKPT_BLOCK_WRITES NUMBER
OPTIMAL_LOGFILE_SIZE NUMBER
ESTD_CLUSTER_AVAILABLE_TIME NUMBER
WRITES_MTTR NUMBER
WRITES_LOGFILE_SIZE NUMBER
WRITES_LOG_CHECKPOINT_SETTINGS NUMBER
WRITES_OTHER_SETTINGS NUMBER
WRITES_AUTOTUNE NUMBER
WRITES_FULL_THREAD_CKPT NUMBER
SQL> desc V$LOGMNR_CONTENTS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SCN NUMBER
CSCN NUMBER
TIMESTAMP DATE
COMMIT_TIMESTAMP DATE
THREAD# NUMBER
LOG_ID NUMBER
XIDUSN NUMBER
XIDSLT NUMBER
XIDSQN NUMBER
PXIDUSN NUMBER
PXIDSLT NUMBER
PXIDSQN NUMBER
RBASQN NUMBER
RBABLK NUMBER
RBABYTE NUMBER
UBAFIL NUMBER
UBABLK NUMBER
UBAREC NUMBER
UBASQN NUMBER
ABS_FILE# NUMBER
REL_FILE# NUMBER
DATA_BLK# NUMBER
DATA_OBJ# NUMBER
DATA_OBJD# NUMBER
SEG_OWNER VARCHAR2(32)
SEG_NAME VARCHAR2(256)
TABLE_NAME VARCHAR2(32)
SEG_TYPE NUMBER
SEG_TYPE_NAME VARCHAR2(32)
TABLE_SPACE VARCHAR2(32)
ROW_ID VARCHAR2(18)
SESSION# NUMBER
SERIAL# NUMBER
USERNAME VARCHAR2(30)
SESSION_INFO VARCHAR2(4000)
TX_NAME VARCHAR2(256)
ROLLBACK NUMBER
OPERATION VARCHAR2(32)
OPERATION_CODE NUMBER
SQL_REDO VARCHAR2(4000)
SQL_UNDO VARCHAR2(4000)
RS_ID VARCHAR2(32)
SEQUENCE# NUMBER
SSN NUMBER
CSF NUMBER
INFO VARCHAR2(32)
STATUS NUMBER
REDO_VALUE NUMBER
UNDO_VALUE NUMBER
SQL_COLUMN_TYPE VARCHAR2(30)
SQL_COLUMN_NAME VARCHAR2(30)
REDO_LENGTH NUMBER
REDO_OFFSET NUMBER
UNDO_LENGTH NUMBER
UNDO_OFFSET NUMBER
DATA_OBJV# NUMBER
SAFE_RESUME_SCN NUMBER
XID RAW(8)
PXID RAW(8)
AUDIT_SESSIONID NUMBER
SQL> desc V$LOGMNR_LOGS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOG_ID NUMBER
FILENAME VARCHAR2(512)
LOW_TIME DATE
HIGH_TIME DATE
DB_ID NUMBER
DB_NAME VARCHAR2(8)
RESET_SCN NUMBER
RESET_SCN_TIME DATE
THREAD_ID NUMBER
THREAD_SQN NUMBER
LOW_SCN NUMBER
NEXT_SCN NUMBER
DICTIONARY_BEGIN VARCHAR2(3)
DICTIONARY_END VARCHAR2(3)
TYPE VARCHAR2(7)
BLOCKSIZE NUMBER
FILESIZE NUMBER
INFO VARCHAR2(32)
STATUS NUMBER
SQL> desc V$LOGMNR_DICTIONARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
DB_NAME VARCHAR2(9)
DB_ID NUMBER
DB_CREATED DATE
TIMESTAMP DATE
RESET_SCN NUMBER
RESET_SCN_TIME DATE
DB_VERSION_TIME DATE
DB_CHARACTER_SET VARCHAR2(30)
DB_VERSION VARCHAR2(64)
DB_STATUS VARCHAR2(64)
DICTIONARY_SCN NUMBER
ENABLED_THREAD_MAP RAW(16)
DB_TXN_SCN NUMBER
FILENAME VARCHAR2(512)
INFO VARCHAR2(32)
STATUS NUMBER
SQL> desc V$LOGMNR_PARAMETERS;
Name Null? Type
----------------------------------------- -------- ----------------------------
START_DATE DATE
REQUIRED_START_DATE DATE
END_DATE DATE
START_SCN NUMBER
REQUIRED_START_SCN NUMBER
END_SCN NUMBER
OPTIONS NUMBER
INFO VARCHAR2(32)
STATUS NUMBER
SQL> desc V$TEMPORARY_LOBS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
CACHE_LOBS NUMBER
NOCACHE_LOBS NUMBER
ABSTRACT_LOBS NUMBER
SQL> desc V$PROXY_DATAFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
DEVICE_TYPE VARCHAR2(17)
HANDLE VARCHAR2(513)
COMMENTS VARCHAR2(81)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
TAG VARCHAR2(32)
STATUS VARCHAR2(1)
DELETED VARCHAR2(3)
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
ABSOLUTE_FUZZY_CHANGE# NUMBER
RECOVERY_FUZZY_CHANGE# NUMBER
RECOVERY_FUZZY_TIME DATE
INCREMENTAL_LEVEL NUMBER
ONLINE_FUZZY VARCHAR2(3)
BACKUP_FUZZY VARCHAR2(3)
BLOCKS NUMBER
BLOCK_SIZE NUMBER
OLDEST_OFFLINE_RANGE NUMBER
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
CONTROLFILE_TYPE VARCHAR2(1)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
SQL> desc V$PROXY_ARCHIVEDLOG;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
DEVICE_TYPE VARCHAR2(17)
HANDLE VARCHAR2(513)
COMMENTS VARCHAR2(81)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
TAG VARCHAR2(32)
STATUS VARCHAR2(1)
DELETED VARCHAR2(3)
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
NEXT_TIME DATE
BLOCKS NUMBER
BLOCK_SIZE NUMBER
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
SQL> desc
V$PGA_TARGET_ADVICE;
Name
Null? Type
-----------------------------------------
-------- -------------------------
PGA_TARGET_FOR_ESTIMATE NUMBER
PGA_TARGET_FACTOR NUMBER
ADVICE_STATUS
VARCHAR2(3)
BYTES_PROCESSED NUMBER
ESTD_EXTRA_BYTES_RW NUMBER
ESTD_PGA_CACHE_HIT_PERCENTAGE NUMBER
ESTD_OVERALLOC_COUNT NUMBER
SQL> desc
V$SYS_OPTIMIZER_ENV;
Name
Null? Type
-----------------------------------------
-------- -------------------------
ID
NUMBER
NAME
VARCHAR2(40)
ISDEFAULT
VARCHAR2(3)
VALUE
VARCHAR2(25)
DEFAULT_VALUE
VARCHAR2(25)
SQL> desc
V$SES_OPTIMIZER_ENV;
Name
Null? Type
-----------------------------------------
-------- -------------------------
SID
NUMBER
ID
NUMBER
NAME
VARCHAR2(40)
ISDEFAULT
VARCHAR2(3)
VALUE VARCHAR2(25)
SQL> desc
V$SQL_OPTIMIZER_ENV ;
Name
Null? Type
-----------------------------------------
-------- -------------------------
ADDRESS
RAW(4)
HASH_VALUE NUMBER
SQL_ID
VARCHAR2(13)
CHILD_ADDRESS RAW(4)
CHILD_NUMBER NUMBER
ID
NUMBER
NAME
VARCHAR2(40)
ISDEFAULT
VARCHAR2(3)
VALUE VARCHAR2(25)
SQL> desc
V$SQL_PLAN ;
Name
Null? Type
-----------------------------------------
-------- -------------------------
ADDRESS RAW(4)
HASH_VALUE NUMBER
SQL_ID
VARCHAR2(13)
PLAN_HASH_VALUE NUMBER
CHILD_ADDRESS RAW(4)
CHILD_NUMBER NUMBER
TIMESTAMP DATE
OPERATION
VARCHAR2(30)
OPTIONS
VARCHAR2(30)
OBJECT_NODE VARCHAR2(40)
OBJECT#
NUMBER
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_TYPE
VARCHAR2(20)
OPTIMIZER
VARCHAR2(20)
ID
NUMBER
PARENT_ID
NUMBER
DEPTH
NUMBER
POSITION
NUMBER
SEARCH_COLUMNS NUMBER
COST NUMBER
CARDINALITY NUMBER
BYTES
NUMBER
OTHER_TAG
VARCHAR2(35)
PARTITION_START VARCHAR2(5)
PARTITION_STOP
VARCHAR2(5)
PARTITION_ID NUMBER
OTHER
VARCHAR2(4000)
DISTRIBUTION VARCHAR2(20)
CPU_COST
NUMBER
IO_COST
NUMBER
TEMP_SPACE NUMBER
ACCESS_PREDICATES VARCHAR2(4000)
FILTER_PREDICATES
VARCHAR2(4000)
PROJECTION
VARCHAR2(4000)
TIME
NUMBER
QBLOCK_NAME VARCHAR2(30)
REMARKS
VARCHAR2(4000)
OTHER_XML CLOB
SQL> desc
V$SQL_PLAN_STATISTICS;
Name
Null? Type
-----------------------------------------
-------- -------------------------
ADDRESS
RAW(4)
HASH_VALUE NUMBER
SQL_ID
VARCHAR2(13)
PLAN_HASH_VALUE NUMBER
CHILD_ADDRESS RAW(4)
CHILD_NUMBER NUMBER
OPERATION_ID NUMBER
EXECUTIONS
NUMBER
LAST_STARTS NUMBER
STARTS
NUMBER
LAST_OUTPUT_ROWS NUMBER
OUTPUT_ROWS NUMBER
LAST_CR_BUFFER_GETS NUMBER
CR_BUFFER_GETS NUMBER
LAST_CU_BUFFER_GETS NUMBER
CU_BUFFER_GETS NUMBER
LAST_DISK_READS NUMBER
DISK_READS NUMBER
LAST_DISK_WRITES NUMBER
DISK_WRITES NUMBER
LAST_ELAPSED_TIME NUMBER
ELAPSED_TIME NUMBER
SQL> desc
V$SQL_PLAN_STATISTICS_ALL;
Name
Null? Type
-----------------------------------------
-------- -------------------------
ADDRESS
RAW(4)
HASH_VALUE NUMBER
SQL_ID
VARCHAR2(13)
PLAN_HASH_VALUE NUMBER
CHILD_ADDRESS RAW(4)
CHILD_NUMBER NUMBER
TIMESTAMP DATE
OPERATION VARCHAR2(30)
OPTIONS
VARCHAR2(30)
OBJECT_NODE
VARCHAR2(40)
OBJECT#
NUMBER
OBJECT_OWNER VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_TYPE
VARCHAR2(20)
OPTIMIZER VARCHAR2(20)
ID
NUMBER
PARENT_ID
NUMBER
DEPTH
NUMBER
POSITION NUMBER
SEARCH_COLUMNS NUMBER
COST
NUMBER
CARDINALITY NUMBER
BYTES
NUMBER
OTHER_TAG
VARCHAR2(35)
PARTITION_START VARCHAR2(5)
PARTITION_STOP
VARCHAR2(5)
PARTITION_ID NUMBER
OTHER
VARCHAR2(4000)
DISTRIBUTION
VARCHAR2(20)
CPU_COST
NUMBER
IO_COST
NUMBER
TEMP_SPACE NUMBER
ACCESS_PREDICATES
VARCHAR2(4000)
FILTER_PREDICATES
VARCHAR2(4000)
PROJECTION
VARCHAR2(4000)
TIME
NUMBER
QBLOCK_NAME
VARCHAR2(30)
REMARKS
VARCHAR2(4000)
OTHER_XML CLOB
EXECUTIONS NUMBER
LAST_STARTS NUMBER
STARTS
NUMBER
LAST_OUTPUT_ROWS NUMBER
OUTPUT_ROWS NUMBER
LAST_CR_BUFFER_GETS NUMBER
CR_BUFFER_GETS NUMBER
LAST_CU_BUFFER_GETS NUMBER
CU_BUFFER_GETS NUMBER
LAST_DISK_READS NUMBER
DISK_READS NUMBER
LAST_DISK_WRITES NUMBER
DISK_WRITES NUMBER
LAST_ELAPSED_TIME NUMBER
ELAPSED_TIME NUMBER
POLICY
VARCHAR2(10)
ESTIMATED_OPTIMAL_SIZE NUMBER
ESTIMATED_ONEPASS_SIZE NUMBER
LAST_MEMORY_USED NUMBER
LAST_EXECUTION
VARCHAR2(10)
LAST_DEGREE NUMBER
TOTAL_EXECUTIONS NUMBER
OPTIMAL_EXECUTIONS NUMBER
ONEPASS_EXECUTIONS NUMBER
MULTIPASSES_EXECUTIONS NUMBER
ACTIVE_TIME NUMBER
MAX_TEMPSEG_SIZE NUMBER
LAST_TEMPSEG_SIZE NUMBER
SQL> desc
V$GLOBALCONTEXT;
Name
Null? Type
-----------------------------------------
-------- -------------------------
NAMESPACE
VARCHAR2(31)
ATTRIBUTE
VARCHAR2(31)
VALUE
VARCHAR2(4000)
USERNAME
VARCHAR2(31)
CLIENTIDENTIFIER VARCHAR2(65)
SQL> desc
V$RESUMABLE;
Name
Null? Type
-----------------------------------------
-------- -------------------------
ADDR
RAW(4)
SID
NUMBER
ENABLED
VARCHAR2(3)
STATUS VARCHAR2(9)
TIMEOUT
NUMBER
SUSPEND_TIME
VARCHAR2(20)
RESUME_TIME
VARCHAR2(20)
NAME
VARCHAR2(4000)
ERROR_NUMBER NUMBER
ERROR_PARAMETER1 VARCHAR2(80)
ERROR_PARAMETER2 VARCHAR2(80)
ERROR_PARAMETER3 VARCHAR2(80)
ERROR_PARAMETER4 VARCHAR2(80)
ERROR_PARAMETER5 VARCHAR2(80)
ERROR_MSG
VARCHAR2(4000)
SQL> desc
V$STREAMS_APPLY_COORDINATOR;
Name
Null? Type
-----------------------------------------
-------- -------------------------
SID
NUMBER
SERIAL#
NUMBER
STATE
VARCHAR2(21)
APPLY#
NUMBER
APPLY_NAME
VARCHAR2(30)
TOTAL_APPLIED NUMBER
TOTAL_WAIT_DEPS NUMBER
TOTAL_WAIT_COMMITS NUMBER
TOTAL_ADMIN NUMBER
TOTAL_ASSIGNED NUMBER
TOTAL_RECEIVED NUMBER
TOTAL_IGNORED NUMBER
TOTAL_ROLLBACKS NUMBER
TOTAL_ERRORS NUMBER
LWM_TIME DATE
LWM_MESSAGE_NUMBER NUMBER
LWM_MESSAGE_CREATE_TIME DATE
HWM_TIME DATE
HWM_MESSAGE_NUMBER NUMBER
HWM_MESSAGE_CREATE_TIME DATE
STARTUP_TIME DATE
ELAPSED_SCHEDULE_TIME NUMBER
ELAPSED_IDLE_TIME NUMBER
SQL> desc
V$STREAMS_APPLY_SERVER;
Name
Null? Type
-----------------------------------------
-------- -------------------------
SID NUMBER
SERIAL#
NUMBER
APPLY#
NUMBER
APPLY_NAME
VARCHAR2(30)
SERVER_ID
NUMBER
STATE
VARCHAR2(20)
XIDUSN
NUMBER
XIDSLT
NUMBER
XIDSQN
NUMBER
COMMITSCN NUMBER
DEP_XIDUSN NUMBER
DEP_XIDSLT NUMBER
DEP_XIDSQN NUMBER
DEP_COMMITSCN NUMBER
MESSAGE_SEQUENCE NUMBER
TOTAL_ASSIGNED NUMBER
TOTAL_ADMIN NUMBER
TOTAL_ROLLBACKS NUMBER
TOTAL_MESSAGES_APPLIED NUMBER
APPLY_TIME DATE
APPLIED_MESSAGE_NUMBER NUMBER
APPLIED_MESSAGE_CREATE_TIME DATE
ELAPSED_DEQUEUE_TIME NUMBER
ELAPSED_APPLY_TIME NUMBER
SQL> desc
V$STREAMS_APPLY_READER;
Name
Null? Type
----------------------------------------- --------
-------------------------
SID
NUMBER
SERIAL#
NUMBER
APPLY#
NUMBER
APPLY_NAME VARCHAR2(30)
STATE
VARCHAR2(17)
TOTAL_MESSAGES_DEQUEUED NUMBER
TOTAL_MESSAGES_SPILLED NUMBER
DEQUEUE_TIME DATE
DEQUEUED_MESSAGE_NUMBER NUMBER
DEQUEUED_MESSAGE_CREATE_TIME DATE
SGA_USED
NUMBER
ELAPSED_DEQUEUE_TIME NUMBER
ELAPSED_SCHEDULE_TIME NUMBER
ELAPSED_SPILL_TIME NUMBER
LAST_BROWSE_NUM NUMBER
OLDEST_SCN_NUM NUMBER
LAST_BROWSE_SEQ NUMBER
LAST_DEQ_SEQ NUMBER
OLDEST_XIDUSN NUMBER
OLDEST_XIDSLT NUMBER
OLDEST_XIDSQN NUMBER
No comments:
Post a Comment