Description of Oracle 10G V$views (part 2)


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