SQL> desc V$BACKUP_SPFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
MODIFICATION_TIME DATE
BYTES NUMBER
COMPLETION_TIME DATE
SQL> desc V$BACKUP_SYNC_IO;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL NUMBER
USE_COUNT NUMBER
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
DEVICE_TYPE VARCHAR2(17)
TYPE VARCHAR2(9)
STATUS VARCHAR2(11)
FILENAME VARCHAR2(513)
SET_COUNT NUMBER
SET_STAMP NUMBER
BUFFER_SIZE NUMBER
BUFFER_COUNT NUMBER
TOTAL_BYTES NUMBER
OPEN_TIME DATE
CLOSE_TIME DATE
ELAPSED_TIME NUMBER
MAXOPENFILES NUMBER
BYTES NUMBER
EFFECTIVE_BYTES_PER_SECOND NUMBER
IO_COUNT NUMBER
IO_TIME_TOTAL NUMBER
IO_TIME_MAX NUMBER
DISCRETE_BYTES_PER_SECOND NUMBER
SQL> desc V$BACKUP_ASYNC_IO ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL NUMBER
USE_COUNT NUMBER
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
DEVICE_TYPE VARCHAR2(17)
TYPE VARCHAR2(9)
STATUS VARCHAR2(11)
FILENAME VARCHAR2(513)
SET_COUNT NUMBER
SET_STAMP NUMBER
BUFFER_SIZE NUMBER
BUFFER_COUNT NUMBER
TOTAL_BYTES NUMBER
OPEN_TIME DATE
CLOSE_TIME DATE
ELAPSED_TIME NUMBER
MAXOPENFILES NUMBER
BYTES NUMBER
EFFECTIVE_BYTES_PER_SECOND NUMBER
IO_COUNT NUMBER
READY NUMBER
SHORT_WAITS NUMBER
SHORT_WAIT_TIME_TOTAL NUMBER
SHORT_WAIT_TIME_MAX NUMBER
LONG_WAITS NUMBER
LONG_WAIT_TIME_TOTAL NUMBER
LONG_WAIT_TIME_MAX NUMBER
SQL> desc V$RESERVED_WORDS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
KEYWORD VARCHAR2(30)
LENGTH NUMBER
RESERVED VARCHAR2(1)
RES_TYPE VARCHAR2(1)
RES_ATTR VARCHAR2(1)
RES_SEMI VARCHAR2(1)
DUPLICATE VARCHAR2(1)
SQL> desc V$DLM_TRAFFIC_CONTROLLER;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOCAL_NID NUMBER
REMOTE_NID NUMBER
REMOTE_RID NUMBER
REMOTE_INC NUMBER
TCKT_AVAIL NUMBER
TCKT_LIMIT NUMBER
TCKT_RCVD NUMBER
TCKT_WAIT VARCHAR2(10)
SND_SEQ_NO NUMBER
RCV_SEQ_NO NUMBER
SND_Q_LEN NUMBER
SND_Q_MAX NUMBER
SND_Q_TOT NUMBER
SND_Q_TM_BASE NUMBER
SND_Q_TM_WRAP NUMBER
STATUS NUMBER
SND_PROXY NUMBER
SQL> desc V$HS_PARAMETER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
HS_SESSION_ID NUMBER
PARAMETER VARCHAR2(30)
VALUE VARCHAR2(64)
SOURCE VARCHAR2(1)
ENV VARCHAR2(1)
SQL> desc V$UNDOSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
UNDOTSN NUMBER
UNDOBLKS NUMBER
TXNCOUNT NUMBER
MAXQUERYLEN NUMBER
MAXQUERYID VARCHAR2(13)
MAXCONCURRENCY NUMBER
UNXPSTEALCNT NUMBER
UNXPBLKRELCNT NUMBER
UNXPBLKREUCNT NUMBER
EXPSTEALCNT NUMBER
EXPBLKRELCNT NUMBER
EXPBLKREUCNT NUMBER
SSOLDERRCNT NUMBER
NOSPACEERRCNT NUMBER
ACTIVEBLKS NUMBER
UNEXPIREDBLKS NUMBER
EXPIREDBLKS NUMBER
TUNED_UNDORETENTION NUMBER
SQL> desc V$SGA_TARGET_ADVICE;
Name Null? Type
----------------------------------------- -------- ----------------------------
SGA_SIZE NUMBER
SGA_SIZE_FACTOR NUMBER
ESTD_DB_TIME NUMBER
ESTD_DB_TIME_FACTOR NUMBER
ESTD_PHYSICAL_READS NUMBER
SQL> desc V$DB_CACHE_ADVICE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
ADVICE_STATUS VARCHAR2(3)
SIZE_FOR_ESTIMATE NUMBER
SIZE_FACTOR NUMBER
BUFFERS_FOR_ESTIMATE NUMBER
ESTD_PHYSICAL_READ_FACTOR NUMBER
ESTD_PHYSICAL_READS NUMBER
ESTD_PHYSICAL_READ_TIME NUMBER
ESTD_PCT_OF_DB_TIME_FOR_READS NUMBER
ESTD_CLUSTER_READS NUMBER
ESTD_CLUSTER_READ_TIME NUMBER
SQL> desc V$MTTR_TARGET_ADVICE;
Name Null? Type
----------------------------------------- -------- ----------------------------
MTTR_TARGET_FOR_ESTIMATE NUMBER
ADVICE_STATUS VARCHAR2(5)
DIRTY_LIMIT NUMBER
ESTD_CACHE_WRITES NUMBER
ESTD_CACHE_WRITE_FACTOR NUMBER
ESTD_TOTAL_WRITES NUMBER
ESTD_TOTAL_WRITE_FACTOR NUMBER
ESTD_TOTAL_IOS NUMBER
ESTD_TOTAL_IO_FACTOR NUMBER
SQL> desc V$LOGMNR_LOGFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOG_ID NUMBER
FILENAME VARCHAR2(513)
LOW_TIME NUMBER
NEXT_TIME NUMBER
DB_ID NUMBER
DB_NAME VARCHAR2(8)
RESET_SCNWRP NUMBER
RESET_SCNBAS NUMBER
RESET_SCN_TIME NUMBER
THREAD_ID NUMBER
THREAD_SQN NUMBER
LOW_SCNWRP NUMBER
LOW_SCNBAS NUMBER
NEXT_SCNWRP NUMBER
NEXT_SCNBAS NUMBER
FILE_STATE VARCHAR2(13)
SQL> desc V$LOGMNR_PROCESS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
PID NUMBER
SPID VARCHAR2(12)
ROLE VARCHAR2(32)
USERNAME VARCHAR2(15)
SID NUMBER
SERIAL# NUMBER
LATCHWAIT VARCHAR2(8)
LATCHSPIN VARCHAR2(8)
WORK_MICROSEC VARCHAR2(21)
OVERHEAD_MICROSEC VARCHAR2(21)
SQL> desc V$LOGMNR_TRANSACTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
XID RAW(8)
XIDUSN NUMBER
XIDSLT NUMBER
XIDSQN NUMBER
PARENT_XID RAW(8)
PARENT_XIDUSN NUMBER
PARENT_XIDSLT NUMBER
PARENT_XIDSQN NUMBER
START_TIME DATE
START_SCN NUMBER
CHUNK# NUMBER
TOTAL_CHUNKS NUMBER
REDO_THREAD NUMBER
LOW_TIME DATE
LOW_SCN NUMBER
HIGH_TIME DATE
HIGH_SCN NUMBER
LCR_COUNT NUMBER
SPILLED_LCR_COUNT NUMBER
DFLAG NUMBER
MFLAG NUMBER
MFLAG2 NUMBER
STATE VARCHAR2(32)
TYPE VARCHAR2(32)
MINING_STATUS VARCHAR2(32)
QUEUE VARCHAR2(32)
SQL> desc V$LOGMNR_REGION;
Name Null? Type
----------------------------------------- -------- ----------------------------
MEMSTATE NUMBER
STATE VARCHAR2(9)
OWNING_PROCESS NUMBER
SQL> desc V$LOGMNR_CALLBACK;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
FUNCTION_ID NUMBER
DESCRIPTION VARCHAR2(64)
TYPE VARCHAR2(15)
SQL> desc V$LOGMNR_SESSION;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
SESSION_NAME VARCHAR2(32)
SESSION_STATE VARCHAR2(9)
DB_NAME VARCHAR2(128)
DB_ID NUMBER
RESET_SCN NUMBER
RESET_TIMESTAMP NUMBER
NUM_PROCESS NUMBER
CHUNK_SIZE NUMBER
START_SCN NUMBER
END_SCN NUMBER
SPILL_SCN NUMBER
PROCESSED_SCN NUMBER
PREPARED_SCN NUMBER
READ_SCN NUMBER
LOW_MARK_SCN NUMBER
CONSUMED_SCN NUMBER
MAX_MEMORY_SIZE NUMBER
USED_MEMORY_SIZE NUMBER
PREPARED_WORK_SIZE NUMBER
AVAILABLE_WORK_SIZE NUMBER
AVAILABLE_TXN NUMBER
AVAILABLE_COMMITTED_TXN NUMBER
DELIVERED_TXN NUMBER
DELIVERED_COMMITTED_TXN NUMBER
PINNED_TXN NUMBER
PINNED_COMMITTED_TXN NUMBER
CHECKPOINT_INTERVAL NUMBER
SQL> desc V$LOGMNR_LATCH;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
NAME VARCHAR2(32)
CHILD_ADDR RAW(4)
STATE VARCHAR2(6)
SQL> desc V$LOGMNR_DICTIONARY_LOAD;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
LOGMNR_UID NUMBER
ACTION# NUMBER
OPCODE NUMBER
COMMAND VARCHAR2(161)
CURRENT_STATE VARCHAR2(32)
COMPLETED_ACTIONS NUMBER
TOTAL_ACTIONS NUMBER
LOADED VARCHAR2(7)
PERCENT_DONE NUMBER
SQL> desc V$SQL_WORKAREA;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS RAW(4)
HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
CHILD_NUMBER NUMBER
WORKAREA_ADDRESS RAW(4)
OPERATION_TYPE VARCHAR2(20)
OPERATION_ID 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$SQL_WORKAREA_ACTIVE;
Name Null? Type
----------------------------------------- -------- ----------------------------
SQL_HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
WORKAREA_ADDRESS RAW(4)
OPERATION_TYPE VARCHAR2(20)
OPERATION_ID NUMBER
POLICY VARCHAR2(6)
SID NUMBER
QCINST_ID NUMBER
QCSID NUMBER
ACTIVE_TIME NUMBER
WORK_AREA_SIZE NUMBER
EXPECTED_SIZE NUMBER
ACTUAL_MEM_USED NUMBER
MAX_MEM_USED NUMBER
NUMBER_PASSES NUMBER
TEMPSEG_SIZE NUMBER
TABLESPACE VARCHAR2(30)
SEGRFNO# NUMBER
SEGBLK# NUMBER
SQL> desc V$PGASTAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(64)
VALUE NUMBER
UNIT VARCHAR2(12)
SQL> desc V$SQL_WORKAREA_HISTOGRAM;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOW_OPTIMAL_SIZE NUMBER
HIGH_OPTIMAL_SIZE NUMBER
OPTIMAL_EXECUTIONS NUMBER
ONEPASS_EXECUTIONS NUMBER
MULTIPASSES_EXECUTIONS NUMBER
TOTAL_EXECUTIONS NUMBER
SQL> desc V$PGA_TARGET_ADVICE_HISTOGRAM;
Name Null? Type
----------------------------------------- -------- ----------------------------
PGA_TARGET_FOR_ESTIMATE NUMBER
PGA_TARGET_FACTOR NUMBER
ADVICE_STATUS VARCHAR2(3)
LOW_OPTIMAL_SIZE NUMBER
HIGH_OPTIMAL_SIZE NUMBER
ESTD_OPTIMAL_EXECUTIONS NUMBER
ESTD_ONEPASS_EXECUTIONS NUMBER
ESTD_MULTIPASSES_EXECUTIONS NUMBER
ESTD_TOTAL_EXECUTIONS NUMBER
IGNORED_WORKAREAS_COUNT 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
SQL> desc V$STREAMS_CAPTURE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
CAPTURE# NUMBER
CAPTURE_NAME VARCHAR2(30)
LOGMINER_ID NUMBER
STARTUP_TIME DATE
STATE VARCHAR2(73)
TOTAL_PREFILTER_DISCARDED NUMBER
TOTAL_PREFILTER_KEPT NUMBER
TOTAL_PREFILTER_EVALUATIONS NUMBER
TOTAL_MESSAGES_CAPTURED NUMBER
CAPTURE_TIME DATE
CAPTURE_MESSAGE_NUMBER NUMBER
CAPTURE_MESSAGE_CREATE_TIME DATE
TOTAL_MESSAGES_CREATED NUMBER
TOTAL_FULL_EVALUATIONS NUMBER
TOTAL_MESSAGES_ENQUEUED NUMBER
ENQUEUE_TIME DATE
ENQUEUE_MESSAGE_NUMBER NUMBER
ENQUEUE_MESSAGE_CREATE_TIME DATE
AVAILABLE_MESSAGE_NUMBER NUMBER
AVAILABLE_MESSAGE_CREATE_TIME DATE
ELAPSED_CAPTURE_TIME NUMBER
ELAPSED_RULE_TIME NUMBER
ELAPSED_ENQUEUE_TIME NUMBER
ELAPSED_LCR_TIME NUMBER
ELAPSED_REDO_WAIT_TIME NUMBER
ELAPSED_PAUSE_TIME NUMBER
STATE_CHANGED_TIME DATE
SQL> desc V$STREAMS_TRANSACTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
STREAMS_NAME VARCHAR2(30)
STREAMS_TYPE VARCHAR2(10)
XIDUSN NUMBER
XIDSLT NUMBER
XIDSQN NUMBER
CUMULATIVE_MESSAGE_COUNT NUMBER
TOTAL_MESSAGE_COUNT NUMBER
FIRST_MESSAGE_TIME DATE
FIRST_MESSAGE_NUMBER DATE
LAST_MESSAGE_TIME DATE
LAST_MESSAGE_NUMBER DATE
SQL> desc V$TIMEZONE_NAMES ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TZNAME VARCHAR2(64)
TZABBREV VARCHAR2(64)
SQL> desc V$TIMEZONE_FILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILENAME VARCHAR2(12)
VERSION NUMBER
SQL> desc V$ENQUEUE_STAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
INST_ID NUMBER
EQ_TYPE VARCHAR2(2)
TOTAL_REQ# NUMBER
TOTAL_WAIT# NUMBER
SUCC_REQ# NUMBER
FAILED_REQ# NUMBER
CUM_WAIT_TIME NUMBER
SQL> desc V$ENQUEUE_STATISTICS;
Name Null? Type
----------------------------------------- -------- ----------------------------
EQ_NAME VARCHAR2(64)
EQ_TYPE VARCHAR2(2)
REQ_REASON VARCHAR2(64)
TOTAL_REQ# NUMBER
TOTAL_WAIT# NUMBER
SUCC_REQ# NUMBER
FAILED_REQ# NUMBER
CUM_WAIT_TIME NUMBER
REQ_DESCRIPTION VARCHAR2(4000)
EVENT# NUMBER
SQL> desc V$LOCK_TYPE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TYPE VARCHAR2(64)
NAME VARCHAR2(64)
ID1_TAG VARCHAR2(64)
ID2_TAG VARCHAR2(64)
IS_USER VARCHAR2(3)
DESCRIPTION VARCHAR2(4000)
SQL> desc V$REPLQUEUE;
Name Null? Type
----------------------------------------- -------- ----------------------------
TXNS_ENQUEUED NUMBER
CALLS_ENQUEUED NUMBER
TXNS_PURGED NUMBER
LAST_ENQUEUE_TIME DATE
LAST_PURGE_TIME DATE
SQL> desc V$REPLPROP;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
NAME VARCHAR2(71)
DBLINK VARCHAR2(128)
STATE VARCHAR2(12)
XID VARCHAR2(22)
SEQUENCE NUMBER
SQL> desc V$MVREFRESH ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
CURRMVOWNER VARCHAR2(31)
CURRMVNAME VARCHAR2(31)
SQL> desc V$LOGSTDBY;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERIAL# NUMBER
LOGSTDBY_ID NUMBER
PID VARCHAR2(12)
TYPE VARCHAR2(30)
STATUS_CODE NUMBER
STATUS VARCHAR2(256)
HIGH_SCN NUMBER
SQL> desc V$LOGSTDBY_STATS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(64)
VALUE VARCHAR2(64)
SQL> desc V$LOGSTDBY_TRANSACTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
PRIMARY_XID RAW(8)
PRIMARY_START_SCN NUMBER
PRIMARY_START_TIME DATE
PRIMARY_PARENT_XID RAW(8)
MINING_STATUS VARCHAR2(32)
APPLY_STATUS VARCHAR2(6)
SID NUMBER
SERIAL# NUMBER
SQL> desc V$LOGSTDBY_PROCESS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
LOGSTDBY_ID NUMBER
SPID VARCHAR2(12)
TYPE VARCHAR2(30)
STATUS_CODE NUMBER
STATUS VARCHAR2(256)
HIGH_SCN NUMBER
SQL> desc V$LOGSTDBY_PROGRESS;
Name Null? Type
----------------------------------------- -------- ----------------------------
APPLIED_SCN NUMBER
APPLIED_TIME DATE
RESTART_SCN NUMBER
RESTART_TIME DATE
LATEST_SCN NUMBER
LATEST_TIME DATE
MINING_SCN NUMBER
MINING_TIME DATE
SQL> desc V$LOGSTDBY_STATE;
Name Null? Type
----------------------------------------- -------- ----------------------------
PRIMARY_DBID NUMBER
SESSION_ID NUMBER
REALTIME_APPLY VARCHAR2(64)
STATE VARCHAR2(64)
SQL> desc V$VPD_POLICY;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS RAW(4)
PARADDR RAW(4)
SQL_HASH NUMBER
SQL_ID VARCHAR2(13)
CHILD_NUMBER NUMBER
OBJECT_OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
POLICY_GROUP VARCHAR2(30)
POLICY VARCHAR2(30)
POLICY_FUNCTION_OWNER VARCHAR2(30)
PREDICATE VARCHAR2(4000)
SQL> desc V$SQL_REDIRECTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS RAW(4)
PARENT_HANDLE RAW(4)
HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
CHILD_NUMBER NUMBER
PARSING_USER_ID NUMBER
PARSING_SCHEMA_ID NUMBER
COMMAND_TYPE NUMBER
REASON VARCHAR2(14)
ERROR_CODE NUMBER
POSITION NUMBER
SQL_TEXT_PIECE VARCHAR2(1000)
ERROR_MESSAGE VARCHAR2(1000)
SQL> desc V$HVMASTER_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
HV_ID NUMBER
CURRENT_MASTER NUMBER
PREVIOUS_MASTER NUMBER
REMASTER_CNT NUMBER
SQL> desc V$GCSHVMASTER_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
HV_ID NUMBER
CURRENT_MASTER NUMBER
PREVIOUS_MASTER NUMBER
REMASTER_CNT NUMBER
SQL> desc V$GCSPFMASTER_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_ID NUMBER
OBJECT_ID NUMBER
CURRENT_MASTER NUMBER
PREVIOUS_MASTER NUMBER
REMASTER_CNT NUMBER
SQL> desc V$DATABASE_BLOCK_CORRUPTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
CORRUPTION_CHANGE# NUMBER
CORRUPTION_TYPE VARCHAR2(9)
SQL> desc V$LOGMNR_STATS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
NAME VARCHAR2(32)
VALUE VARCHAR2(21)
SQL> desc V$ASM_TEMPLATE;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
ENTRY_NUMBER NUMBER
REDUNDANCY VARCHAR2(6)
STRIPE VARCHAR2(6)
SYSTEM VARCHAR2(1)
NAME VARCHAR2(30)
SQL> desc V$ASM_ALIAS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(48)
GROUP_NUMBER NUMBER
FILE_NUMBER NUMBER
FILE_INCARNATION NUMBER
ALIAS_INDEX NUMBER
ALIAS_INCARNATION NUMBER
PARENT_INDEX NUMBER
REFERENCE_INDEX NUMBER
ALIAS_DIRECTORY VARCHAR2(1)
SYSTEM_CREATED VARCHAR2(1)
SQL> desc V$ASM_FILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
FILE_NUMBER NUMBER
COMPOUND_INDEX NUMBER
INCARNATION NUMBER
BLOCK_SIZE NUMBER
BLOCKS NUMBER
BYTES NUMBER
SPACE NUMBER
TYPE VARCHAR2(64)
REDUNDANCY VARCHAR2(6)
STRIPED VARCHAR2(6)
CREATION_DATE DATE
MODIFICATION_DATE DATE
REDUNDANCY_LOWERED VARCHAR2(1)
SQL> desc V$ASM_CLIENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
INSTANCE_NAME VARCHAR2(64)
DB_NAME VARCHAR2(8)
STATUS VARCHAR2(12)
SOFTWARE_VERSION VARCHAR2(60)
COMPATIBLE_VERSION VARCHAR2(60)
SQL> desc V$ASM_DISKGROUP;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
NAME VARCHAR2(30)
SECTOR_SIZE NUMBER
BLOCK_SIZE NUMBER
ALLOCATION_UNIT_SIZE NUMBER
STATE VARCHAR2(11)
TYPE VARCHAR2(6)
TOTAL_MB NUMBER
FREE_MB NUMBER
REQUIRED_MIRROR_FREE_MB NUMBER
USABLE_FILE_MB NUMBER
OFFLINE_DISKS NUMBER
UNBALANCED VARCHAR2(1)
COMPATIBILITY VARCHAR2(60)
DATABASE_COMPATIBILITY VARCHAR2(60)
SQL> desc V$ASM_DISKGROUP_STAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
NAME VARCHAR2(30)
SECTOR_SIZE NUMBER
BLOCK_SIZE NUMBER
ALLOCATION_UNIT_SIZE NUMBER
STATE VARCHAR2(11)
TYPE VARCHAR2(6)
TOTAL_MB NUMBER
FREE_MB NUMBER
REQUIRED_MIRROR_FREE_MB NUMBER
USABLE_FILE_MB NUMBER
OFFLINE_DISKS NUMBER
UNBALANCED VARCHAR2(1)
COMPATIBILITY VARCHAR2(60)
DATABASE_COMPATIBILITY VARCHAR2(60)
SQL> desc V$ASM_DISK;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
DISK_NUMBER NUMBER
COMPOUND_INDEX NUMBER
INCARNATION NUMBER
MOUNT_STATUS VARCHAR2(7)
HEADER_STATUS VARCHAR2(12)
MODE_STATUS VARCHAR2(7)
STATE VARCHAR2(8)
REDUNDANCY VARCHAR2(7)
LIBRARY VARCHAR2(64)
TOTAL_MB NUMBER
FREE_MB NUMBER
NAME VARCHAR2(30)
FAILGROUP VARCHAR2(30)
LABEL VARCHAR2(31)
PATH VARCHAR2(256)
UDID VARCHAR2(64)
PRODUCT VARCHAR2(32)
CREATE_DATE DATE
MOUNT_DATE DATE
REPAIR_TIMER NUMBER
READS NUMBER
WRITES NUMBER
READ_ERRS NUMBER
WRITE_ERRS NUMBER
READ_TIME NUMBER
WRITE_TIME NUMBER
BYTES_READ NUMBER
BYTES_WRITTEN NUMBER
SQL> desc V$ASM_DISK_STAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
DISK_NUMBER NUMBER
COMPOUND_INDEX NUMBER
INCARNATION NUMBER
MOUNT_STATUS VARCHAR2(7)
HEADER_STATUS VARCHAR2(12)
MODE_STATUS VARCHAR2(7)
STATE VARCHAR2(8)
REDUNDANCY VARCHAR2(7)
LIBRARY VARCHAR2(64)
TOTAL_MB NUMBER
FREE_MB NUMBER
NAME VARCHAR2(30)
FAILGROUP VARCHAR2(30)
LABEL VARCHAR2(31)
PATH VARCHAR2(256)
UDID VARCHAR2(64)
PRODUCT VARCHAR2(32)
CREATE_DATE DATE
MOUNT_DATE DATE
REPAIR_TIMER NUMBER
READS NUMBER
WRITES NUMBER
READ_ERRS NUMBER
WRITE_ERRS NUMBER
READ_TIME NUMBER
WRITE_TIME NUMBER
BYTES_READ NUMBER
BYTES_WRITTEN NUMBER
SQL> desc V$ASM_OPERATION ;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
OPERATION VARCHAR2(5)
STATE VARCHAR2(4)
POWER NUMBER
ACTUAL NUMBER
SOFAR NUMBER
EST_WORK NUMBER
EST_RATE NUMBER
EST_MINUTES NUMBER
SQL> desc V$STATISTICS_LEVEL;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTICS_NAME VARCHAR2(64)
DESCRIPTION VARCHAR2(4000)
SESSION_STATUS VARCHAR2(8)
SYSTEM_STATUS VARCHAR2(8)
ACTIVATION_LEVEL VARCHAR2(7)
STATISTICS_VIEW_NAME VARCHAR2(64)
SESSION_SETTABLE VARCHAR2(3)
SQL> desc V$DATABASE_INCARNATION;
Name Null? Type
----------------------------------------- -------- ----------------------------
INCARNATION# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
PRIOR_RESETLOGS_CHANGE# NUMBER
PRIOR_RESETLOGS_TIME DATE
STATUS VARCHAR2(7)
RESETLOGS_ID NUMBER
PRIOR_INCARNATION# NUMBER
FLASHBACK_DATABASE_ALLOWED VARCHAR2(26)
SQL> desc V$AW_OLAP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
AW_NUMBER NUMBER
ATTACH_MODE VARCHAR2(10)
GENERATION NUMBER
TEMP_SPACE_PAGES NUMBER
TEMP_SPACE_READS NUMBER
LOB_READS NUMBER
POOL_CHANGED_PAGES NUMBER
POOL_UNCHANGED_PAGES NUMBER
SQL> desc V$AW_CALC ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
AGGREGATE_CACHE_HITS NUMBER
AGGREGATE_CACHE_MISSES NUMBER
SESSION_CACHE_HITS NUMBER
SESSION_CACHE_MISSES NUMBER
POOL_HITS NUMBER
POOL_MISSES NUMBER
POOL_NEW_PAGES NUMBER
POOL_RECLAIMED_PAGES NUMBER
CACHE_WRITES NUMBER
POOL_SIZE NUMBER
CURR_DML_COMMAND VARCHAR2(64)
PREV_DML_COMMAND VARCHAR2(64)
AGGR_FUNC_LOGICAL_NA NUMBER
AGGR_FUNC_PRECOMPUTE NUMBER
AGGR_FUNC_CALCS NUMBER
SQL> desc V$AW_SESSION_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
CLIENT_TYPE VARCHAR2(64)
SESSION_STATE VARCHAR2(64)
SESSION_HANDLE NUMBER
USERID VARCHAR2(64)
TOTAL_TRANSACTION NUMBER
TRANSACTION_TIME NUMBER
TOTAL_TRANSACTION_TIME NUMBER
AVERAGE_TRANSACTION_TIME NUMBER
TRANSACTION_CPU_TIME NUMBER
TOTAL_TRANSACTION_CPU_TIME NUMBER
AVERAGE_TRANSACTION_CPU_TIME NUMBER
SQL> desc V$MAP_FILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_MAP_IDX NUMBER
FILE_CFGID VARCHAR2(256)
FILE_STATUS VARCHAR2(7)
FILE_NAME VARCHAR2(256)
FILE_TYPE VARCHAR2(11)
FILE_STRUCTURE VARCHAR2(9)
FILE_SIZE NUMBER
FILE_NEXTS NUMBER
LIB_IDX NUMBER
SQL> desc V$MAP_FILE_EXTENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_MAP_IDX NUMBER
EXT_NUM NUMBER
EXT_ELEM_OFF NUMBER
EXT_SIZE NUMBER
EXT_FILE_OFF NUMBER
EXT_TYPE VARCHAR2(6)
ELEM_IDX NUMBER
SQL> desc V$MAP_ELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
ELEM_NAME VARCHAR2(256)
ELEM_IDX NUMBER
ELEM_CFGID VARCHAR2(256)
ELEM_TYPE VARCHAR2(12)
ELEM_SIZE NUMBER
ELEM_NSUBELEM NUMBER
ELEM_DESCR VARCHAR2(256)
STRIPE_SIZE NUMBER
LIB_IDX NUMBER
SQL> desc V$MAP_EXT_ELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
ELEM_IDX NUMBER
NUM_ATTRB NUMBER
ATTRB1_NAME VARCHAR2(256)
ATTRB1_VAL VARCHAR2(256)
ATTRB2_NAME VARCHAR2(256)
ATTRB2_VAL VARCHAR2(256)
ATTRB3_NAME VARCHAR2(256)
ATTRB3_VAL VARCHAR2(256)
ATTRB4_NAME VARCHAR2(256)
ATTRB4_VAL VARCHAR2(256)
ATTRB5_NAME VARCHAR2(256)
ATTRB5_VAL VARCHAR2(256)
SQL> desc V$MAP_COMP_LIST ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ELEM_IDX NUMBER
NUM_COMP NUMBER
COMP1_NAME VARCHAR2(256)
COMP1_VAL VARCHAR2(256)
COMP2_NAME VARCHAR2(256)
COMP2_VAL VARCHAR2(256)
COMP3_NAME VARCHAR2(256)
COMP3_VAL VARCHAR2(256)
COMP4_NAME VARCHAR2(256)
COMP4_VAL VARCHAR2(256)
COMP5_NAME VARCHAR2(256)
COMP5_VAL VARCHAR2(256)
SQL> desc V$MAP_SUBELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
CHILD_IDX NUMBER
PARENT_IDX NUMBER
SUB_NUM NUMBER
SUB_SIZE NUMBER
ELEM_OFFSET NUMBER
SUB_FLAGS NUMBER
SQL> desc V$MAP_FILE_IO_STACK ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_MAP_IDX NUMBER
DEPTH NUMBER
ELEM_IDX NUMBER
CU_SIZE NUMBER
STRIDE NUMBER
NUM_CU NUMBER
ELEM_OFFSET NUMBER
FILE_OFFSET NUMBER
DATA_TYPE VARCHAR2(15)
PARITY_POS NUMBER
PARITY_PERIOD NUMBER
ID NUMBER
PARENT_ID NUMBER
SQL> desc V$MAP_LIBRARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
LIB_IDX NUMBER
LIB_NAME VARCHAR2(256)
VENDOR_NAME VARCHAR2(64)
PROTOCOL_NUM NUMBER
VERSION_NUM VARCHAR2(32)
PATH_NAME VARCHAR2(1024)
MAP_FILE VARCHAR2(1)
FILE_CFGID VARCHAR2(13)
MAP_ELEM VARCHAR2(1)
ELEM_CFGID VARCHAR2(13)
MAP_SYNC VARCHAR2(1)
SQL> desc V$DATAPUMP_JOB ;
Name Null? Type
----------------------------------------- -------- ----------------------------
JOB_ID RAW(16)
JOB_NAME VARCHAR2(30)
OWNER_NAME VARCHAR2(30)
MSG_CTRL_QUEUE VARCHAR2(30)
STATUS_QUEUE VARCHAR2(30)
OPERATION VARCHAR2(30)
JOB_MODE VARCHAR2(30)
MASTER_ID NUMBER
STATE VARCHAR2(30)
WORKERS NUMBER
FLAGS NUMBER
SQL> desc V$DATAPUMP_SESSION;
Name Null? Type
----------------------------------------- -------- ----------------------------
ATTACH_ID NUMBER
JOB_ID RAW(16)
SADDR RAW(4)
TYPE VARCHAR2(14)
SQL> desc V$RULE_SET ;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(30)
NAME VARCHAR2(30)
CPU_TIME NUMBER
ELAPSED_TIME NUMBER
FIRST_LOAD_TIME DATE
LAST_LOAD_TIME DATE
LAST_LOADING_TIME NUMBER
SHARABLE_MEM NUMBER
RELOADS NUMBER
INVALIDATIONS NUMBER
EVALUATIONS NUMBER
FIRST_HIT_EVALUATIONS NUMBER
SIMPLE_RULES_ONLY_EVALUATIONS NUMBER
SQL_FREE_EVALUATIONS NUMBER
SQL_EXECUTIONS NUMBER
CONDITIONS_PROCESSED NUMBER
TRUE_RULES NUMBER
MAYBE_RULES NUMBER
VARIABLE_VALUE_FUNCTION_CALLS NUMBER
VARIABLE_METHOD_FUNCTION_CALLS NUMBER
EVALUATION_FUNCTION_CALLS NUMBER
SQL> desc V$RULE_SET_AGGREGATE_STATS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(80)
VALUE NUMBER
SQL> desc V$JAVAPOOL;
Name Null? Type
----------------------------------------- -------- ----------------------------
CATEGORY VARCHAR2(16)
MEMUSED NUMBER
SQL> desc V$SYSAUX_OCCUPANTS;
Name Null? Type
----------------------------------------- -------- ----------------------------
OCCUPANT_NAME VARCHAR2(64)
OCCUPANT_DESC VARCHAR2(64)
SCHEMA_NAME VARCHAR2(64)
MOVE_PROCEDURE VARCHAR2(64)
MOVE_PROCEDURE_DESC VARCHAR2(64)
SPACE_USAGE_KBYTES NUMBER
SQL> desc V$RECOVERY_FILE_DEST;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(513)
SPACE_LIMIT NUMBER
SPACE_USED NUMBER
SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES NUMBER
SQL> desc V$FLASH_RECOVERY_AREA_USAGE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_TYPE VARCHAR2(12)
PERCENT_SPACE_USED NUMBER
PERCENT_SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES NUMBER
SQL> desc V$AW_AGGREGATE_OP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(14)
LONGNAME VARCHAR2(30)
DEFAULT_WEIGHT NUMBER
SQL> desc V$AW_ALLOCATE_OP;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(14)
LONGNAME VARCHAR2(30)
SQL> desc V$TRANSPORTABLE_PLATFORM ;
Name Null? Type
----------------------------------------- -------- ----------------------------
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2(101)
ENDIAN_FORMAT VARCHAR2(14)
SQL> desc V$BLOCK_CHANGE_TRACKING;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATUS VARCHAR2(10)
FILENAME VARCHAR2(513)
BYTES NUMBER
SQL> desc V$RULE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
RULE_SET_OBJECT_ID NUMBER
EVALUATION_CONTEXT_OBJECT_ID NUMBER
RULE_OWNER VARCHAR2(30)
RULE_NAME VARCHAR2(30)
RULE_CONDITION VARCHAR2(200)
TRUE_HITS NUMBER
MAYBE_HITS NUMBER
SQL_EVALUATIONS NUMBER
SQL> desc V$FLASHBACK_DATABASE_LOGFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(513)
LOG# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
SQL> desc V$FLASHBACK_DATABASE_LOG;
Name Null? Type
----------------------------------------- -------- ----------------------------
OLDEST_FLASHBACK_SCN NUMBER
OLDEST_FLASHBACK_TIME DATE
RETENTION_TARGET NUMBER
FLASHBACK_SIZE NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
SQL> desc V$FLASHBACK_DATABASE_STAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
SQL> desc V$ACTIVE_SESSION_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
SAMPLE_ID NUMBER
SAMPLE_TIME TIMESTAMP(3)
SESSION_ID NUMBER
SESSION_SERIAL# NUMBER
USER_ID NUMBER
SQL_ID VARCHAR2(13)
SQL_CHILD_NUMBER NUMBER
SQL_PLAN_HASH_VALUE NUMBER
FORCE_MATCHING_SIGNATURE NUMBER
SQL_OPCODE NUMBER
SERVICE_HASH NUMBER
SESSION_TYPE VARCHAR2(10)
SESSION_STATE VARCHAR2(7)
QC_SESSION_ID NUMBER
QC_INSTANCE_ID NUMBER
BLOCKING_SESSION NUMBER
BLOCKING_SESSION_STATUS VARCHAR2(11)
BLOCKING_SESSION_SERIAL# NUMBER
EVENT VARCHAR2(64)
EVENT_ID NUMBER
EVENT# NUMBER
SEQ# NUMBER
P1TEXT VARCHAR2(64)
P1 NUMBER
P2TEXT VARCHAR2(64)
P2 NUMBER
P3TEXT VARCHAR2(64)
P3 NUMBER
WAIT_CLASS VARCHAR2(64)
WAIT_CLASS_ID NUMBER
WAIT_TIME NUMBER
TIME_WAITED NUMBER
XID RAW(8)
CURRENT_OBJ# NUMBER
CURRENT_FILE# NUMBER
CURRENT_BLOCK# NUMBER
PROGRAM VARCHAR2(64)
MODULE VARCHAR2(48)
ACTION VARCHAR2(32)
CLIENT_ID VARCHAR2(64)
SQL> desc V$RMAN_STATUS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
RECID NUMBER
STAMP NUMBER
PARENT_RECID NUMBER
PARENT_STAMP NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
ROW_LEVEL NUMBER
ROW_TYPE VARCHAR2(19)
COMMAND_ID VARCHAR2(33)
OPERATION VARCHAR2(33)
STATUS VARCHAR2(23)
MBYTES_PROCESSED NUMBER
START_TIME DATE
END_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
OPTIMIZED VARCHAR2(3)
OBJECT_TYPE VARCHAR2(13)
OUTPUT_DEVICE_TYPE VARCHAR2(17)
SQL> desc V$RMAN_OUTPUT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
RECID NUMBER
STAMP NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
OUTPUT VARCHAR2(130)
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
SESSION_KEY NUMBER
SQL> desc V$ACTIVE_SERVICES;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
BLOCKED VARCHAR2(3)
AQ_HA_NOTIFICATION VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
SQL> desc V$SERVICE_WAIT_CLASS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_NAME VARCHAR2(64)
SERVICE_NAME_HASH NUMBER
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
TOTAL_WAITS NUMBER
TIME_WAITED NUMBER
SQL> desc V$SERVICE_EVENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_NAME VARCHAR2(64)
SERVICE_NAME_HASH NUMBER
EVENT VARCHAR2(64)
EVENT_ID NUMBER
TOTAL_WAITS NUMBER
TOTAL_TIMEOUTS NUMBER
TIME_WAITED NUMBER
AVERAGE_WAIT NUMBER
MAX_WAIT NUMBER
TIME_WAITED_MICRO NUMBER
SQL> desc V$SERVICES;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
AQ_HA_NOTIFICATION VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
SQL> desc V$AW_LONGOPS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
CURSOR_NAME VARCHAR2(64)
COMMAND VARCHAR2(7)
STATUS VARCHAR2(9)
ROWS_PROCESSED NUMBER
START_TIME TIMESTAMP(3)
SQL> desc V$METRICGROUP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_ID NUMBER
NAME VARCHAR2(64)
INTERVAL_SIZE NUMBER
MAX_INTERVAL NUMBER
SQL> desc V$METRICNAME;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_ID NUMBER
GROUP_NAME VARCHAR2(64)
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
METRIC_UNIT VARCHAR2(64)
SQL> desc V$METRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
ENTITY_ID NUMBER
ENTITY_SEQUENCE NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
VALUE NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$METRIC_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
ENTITY_ID NUMBER
ENTITY_SEQUENCE NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
VALUE NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$SYSMETRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
VALUE NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$SYSMETRIC_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
VALUE NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$FILESPACE_USAGE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_ID NUMBER
RFNO NUMBER
ALLOCATED_SPACE NUMBER
FILE_SIZE NUMBER
FILE_MAXSIZE NUMBER
CHANGESCN_BASE NUMBER
CHANGESCN_WRAP NUMBER
FLAG NUMBER
SQL> desc V$SCHEDULER_RUNNING_JOBS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
SESSION_SERIAL_NUM NUMBER
JOB_ID NUMBER
PADDR RAW(4)
OS_PROCESS_ID VARCHAR2(12)
SESSION_STAT_CPU INTERVAL DAY(2) TO SECOND(3)
SQL> desc V$BUFFERED_QUEUES;
Name Null? Type
----------------------------------------- -------- ----------------------------
QUEUE_ID NUMBER
QUEUE_SCHEMA VARCHAR2(30)
QUEUE_NAME VARCHAR2(30)
STARTUP_TIME DATE
NUM_MSGS NUMBER
SPILL_MSGS NUMBER
CNUM_MSGS NUMBER
CSPILL_MSGS NUMBER
EXPIRED_MSGS NUMBER
SQL> desc V$BUFFERED_SUBSCRIBERS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
QUEUE_ID NUMBER
QUEUE_SCHEMA VARCHAR2(30)
QUEUE_NAME VARCHAR2(30)
SUBSCRIBER_ID NUMBER
SUBSCRIBER_NAME VARCHAR2(30)
SUBSCRIBER_ADDRESS VARCHAR2(1024)
PROTOCOL NUMBER
SUBSCRIBER_TYPE VARCHAR2(30)
STARTUP_TIME DATE
LAST_BROWSED_SEQ NUMBER
LAST_BROWSED_NUM NUMBER
LAST_DEQUEUED_SEQ NUMBER
LAST_DEQUEUED_NUM NUMBER
CURRENT_ENQ_SEQ NUMBER
NUM_MSGS NUMBER
CNUM_MSGS NUMBER
TOTAL_DEQUEUED_MSG NUMBER
TOTAL_SPILLED_MSG NUMBER
EXPIRED_MSGS NUMBER
SQL> desc V$BUFFERED_PUBLISHERS;
Name Null? Type
----------------------------------------- -------- ----------------------------
QUEUE_ID NUMBER
QUEUE_SCHEMA VARCHAR2(30)
QUEUE_NAME VARCHAR2(30)
SENDER_NAME VARCHAR2(30)
SENDER_ADDRESS VARCHAR2(1024)
SENDER_PROTOCOL NUMBER
NUM_MSGS NUMBER
CNUM_MSGS NUMBER
LAST_ENQUEUED_MSG NUMBER
UNBROWSED_MSGS NUMBER
OVERSPILLED_MSGS NUMBER
MEMORY_USAGE NUMBER
PUBLISHER_STATE VARCHAR2(59)
SQL> desc V$TSM_SESSIONS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
STATE VARCHAR2(24)
MIGRATABLE VARCHAR2(3)
MIGRATION_ALLOWED VARCHAR2(3)
TRANSFERABLE VARCHAR2(3)
MIGRATION_BOUNDARY VARCHAR2(3)
NONMIGRATABILITY_REASON VARCHAR2(4000)
NONMIGRATABILITY_INFO VARCHAR2(4000)
NONTRANSFERABILITY_REASON VARCHAR2(4000)
NONTRANSFERABILITY_INFO VARCHAR2(4000)
STATELESS VARCHAR2(11)
PRESERVE_STATE VARCHAR2(3)
COST NUMBER
DESTINATION VARCHAR2(4000)
ROUNDTRIPS NUMBER
BLOCKING_COMPONENT VARCHAR2(4000)
START_TIME DATE
SEQUENCE_NUMBER NUMBER
SQL> desc V$PROPAGATION_SENDER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
QUEUE_ID NUMBER
QUEUE_SCHEMA VARCHAR2(30)
QUEUE_NAME VARCHAR2(30)
DST_QUEUE_SCHEMA VARCHAR2(30)
DST_QUEUE_NAME VARCHAR2(30)
STARTUP_TIME DATE
DBLINK VARCHAR2(128)
HIGH_WATER_MARK NUMBER
ACKNOWLEDGEMENT NUMBER
SCHEDULE_STATUS VARCHAR2(30)
TOTAL_MSGS NUMBER
TOTAL_BYTES NUMBER
ELAPSED_DEQUEUE_TIME NUMBER
ELAPSED_PICKLE_TIME NUMBER
ELAPSED_PROPAGATION_TIME NUMBER
MAX_NUM_PER_WIN NUMBER
MAX_SIZE NUMBER
SQL> desc V$PROPAGATION_RECEIVER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SRC_QUEUE_SCHEMA VARCHAR2(30)
SRC_QUEUE_NAME VARCHAR2(30)
SRC_DBNAME VARCHAR2(128)
DST_QUEUE_SCHEMA VARCHAR2(30)
DST_QUEUE_NAME VARCHAR2(30)
STARTUP_TIME DATE
HIGH_WATER_MARK NUMBER
ACKNOWLEDGEMENT NUMBER
TOTAL_MSGS NUMBER
ELAPSED_UNPICKLE_TIME NUMBER
ELAPSED_RULE_TIME NUMBER
ELAPSED_ENQUEUE_TIME NUMBER
SQL> desc V$CLIENT_STATS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CLIENT_IDENTIFIER VARCHAR2(64)
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SERV_MOD_ACT_STATS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
AGGREGATION_TYPE VARCHAR2(21)
SERVICE_NAME VARCHAR2(64)
MODULE VARCHAR2(49)
ACTION VARCHAR2(33)
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SERVICE_STATS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_NAME_HASH NUMBER
SERVICE_NAME VARCHAR2(64)
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SYS_TIME_MODEL;
Name Null? Type
----------------------------------------- -------- ----------------------------
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SESS_TIME_MODEL;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SYSMETRIC_SUMMARY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
NUM_INTERVAL NUMBER
MAXVAL NUMBER
MINVAL NUMBER
AVERAGE NUMBER
STANDARD_DEVIATION NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$SESSMETRIC ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
SESSION_ID NUMBER
SESSION_SERIAL_NUM NUMBER
CPU NUMBER
PHYSICAL_READS NUMBER
LOGICAL_READS NUMBER
PGA_MEMORY NUMBER
HARD_PARSES NUMBER
SOFT_PARSES NUMBER
PHYSICAL_READ_PCT NUMBER
LOGICAL_READ_PCT NUMBER
SQL> desc V$FILEMETRIC ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
FILE_ID NUMBER
CREATION_TIME NUMBER
AVERAGE_READ_TIME NUMBER
AVERAGE_WRITE_TIME NUMBER
PHYSICAL_READS NUMBER
PHYSICAL_WRITES NUMBER
PHYSICAL_BLOCK_READS NUMBER
PHYSICAL_BLOCK_WRITES NUMBER
SQL> desc V$FILEMETRIC_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
FILE_ID NUMBER
CREATION_TIME NUMBER
AVERAGE_READ_TIME NUMBER
AVERAGE_WRITE_TIME NUMBER
PHYSICAL_READS NUMBER
PHYSICAL_WRITES NUMBER
PHYSICAL_BLOCK_READS NUMBER
PHYSICAL_BLOCK_WRITES NUMBER
SQL> desc V$EVENTMETRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
EVENT# NUMBER
EVENT_ID NUMBER
NUM_SESS_WAITING NUMBER
TIME_WAITED NUMBER
WAIT_COUNT NUMBER
SQL> desc V$WAITCLASSMETRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS_ID NUMBER
AVERAGE_WAITER_COUNT NUMBER
DBTIME_IN_WAIT NUMBER
TIME_WAITED NUMBER
WAIT_COUNT NUMBER
SQL> desc V$WAITCLASSMETRIC_HISTORY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS_ID NUMBER
AVERAGE_WAITER_COUNT NUMBER
DBTIME_IN_WAIT NUMBER
TIME_WAITED NUMBER
WAIT_COUNT NUMBER
SQL> desc V$SERVICEMETRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
SERVICE_NAME_HASH NUMBER
SERVICE_NAME VARCHAR2(64)
CTMHASH NUMBER
ELAPSEDPERCALL NUMBER
CPUPERCALL NUMBER
DBTIMEPERCALL NUMBER
CALLSPERSEC NUMBER
DBTIMEPERSEC NUMBER
GOODNESS NUMBER
DELTA NUMBER
FLAGS NUMBER
SQL> desc V$SERVICEMETRIC_HISTORY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
SERVICE_NAME_HASH NUMBER
SERVICE_NAME VARCHAR2(64)
CTMHASH NUMBER
ELAPSEDPERCALL NUMBER
CPUPERCALL NUMBER
DBTIMEPERCALL NUMBER
CALLSPERSEC NUMBER
DBTIMEPERSEC NUMBER
SQL> desc V$XML_AUDIT_TRAIL;
Name Null? Type
----------------------------------------- -------- ----------------------------
AUDIT_TYPE NUMBER
SESSION_ID NUMBER
PROXY_SESSIONID NUMBER
STATEMENTID NUMBER
ENTRYID NUMBER
EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE
GLOBAL_UID VARCHAR2(32)
DB_USER VARCHAR2(30)
CLIENTIDENTIFIER VARCHAR2(64)
EXT_NAME VARCHAR2(1024)
OS_USER VARCHAR2(30)
OS_HOST VARCHAR2(128)
OS_PROCESS VARCHAR2(16)
TERMINAL VARCHAR2(16)
INSTANCE_NUMBER NUMBER
OBJECT_SCHEMA VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
POLICY_NAME VARCHAR2(30)
NEW_OWNER VARCHAR2(30)
NEW_NAME VARCHAR2(30)
ACTION NUMBER
STATEMENT_TYPE NUMBER
TRANSACTIONID RAW(8)
RETURNCODE NUMBER
SCN NUMBER
COMMENT_TEXT VARCHAR2(4000)
AUTH_PRIVILEGES VARCHAR2(16)
GRANTEE VARCHAR2(30)
PRIV_USED NUMBER
SES_ACTIONS VARCHAR2(16)
OS_PRIVILEGE VARCHAR2(7)
ECONTEXT_ID VARCHAR2(64)
SQL_BIND VARCHAR2(4000)
SQL_TEXT VARCHAR2(4000)
SQL> desc V$ALERT_TYPES ;
Name Null? Type
----------------------------------------- -------- ----------------------------
REASON_ID NUMBER
OBJECT_TYPE VARCHAR2(64)
TYPE VARCHAR2(9)
GROUP_NAME VARCHAR2(64)
SCOPE VARCHAR2(8)
INTERNAL_METRIC_CATEGORY VARCHAR2(64)
INTERNAL_METRIC_NAME VARCHAR2(64)
SQL> desc V$THRESHOLD_TYPES;
Name Null? Type
----------------------------------------- -------- ----------------------------
METRICS_ID NUMBER
METRICS_GROUP_ID NUMBER
OPERATOR_MASK NUMBER
OBJECT_TYPE VARCHAR2(64)
ALERT_REASON_ID NUMBER
METRIC_VALUE_TYPE NUMBER
SQL> desc V$RESTORE_POINT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SCN NUMBER
DATABASE_INCARNATION# NUMBER
GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
STORAGE_SIZE NUMBER
TIME TIMESTAMP(9)
NAME VARCHAR2(128)
SQL> desc V$DB_TRANSPORTABLE_PLATFORM;
Name Null? Type
----------------------------------------- -------- ----------------------------
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2(101)
ENDIAN_FORMAT VARCHAR2(14)
SQL> desc V$SQL_JOIN_FILTER;
Name Null? Type
----------------------------------------- -------- ----------------------------
QC_SESSION_ID NUMBER
QC_INSTANCE_ID NUMBER
SQL_PLAN_HASH_VALUE NUMBER
LENGTH NUMBER
BITS_SET NUMBER
FILTERED NUMBER
PROBED NUMBER
ACTIVE NUMBER
SQL> desc V$RMAN_BACKUP_SUBJOB_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
OPERATION VARCHAR2(33)
COMMAND_ID VARCHAR2(33)
START_TIME DATE
END_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
STATUS_WEIGHT NUMBER
OBJECT_TYPE_WEIGHT NUMBER
OPTIMIZED_WEIGHT NUMBER
OUTPUT_DEVICE_TYPE VARCHAR2(17)
AUTOBACKUP_DONE VARCHAR2(3)
STATUS VARCHAR2(23)
INPUT_TYPE VARCHAR2(13)
OPTIMIZED VARCHAR2(3)
AUTOBACKUP_COUNT NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$RMAN_BACKUP_JOB_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
COMMAND_ID VARCHAR2(33)
START_TIME DATE
END_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
STATUS_WEIGHT NUMBER
OPTIMIZED_WEIGHT NUMBER
OBJECT_TYPE_WEIGHT NUMBER
OUTPUT_DEVICE_TYPE VARCHAR2(17)
AUTOBACKUP_COUNT NUMBER
AUTOBACKUP_DONE VARCHAR2(3)
STATUS VARCHAR2(23)
INPUT_TYPE VARCHAR2(13)
OPTIMIZED VARCHAR2(3)
ELAPSED_SECONDS NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_PER_SEC NUMBER
OUTPUT_BYTES_PER_SEC NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
INPUT_BYTES_PER_SEC_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_PER_SEC_DISPLAY VARCHAR2(4000)
TIME_TAKEN_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_SET_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
BS_KEY NUMBER
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
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
DEVICE_TYPE VARCHAR2(17)
COMPRESSED VARCHAR2(3)
NUM_COPIES NUMBER
OUTPUT_BYTES NUMBER
ORIGINAL_INPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
STATUS CHAR(1)
ORIGINAL_INPRATE_BYTES NUMBER
OUTPUT_RATE_BYTES NUMBER
ORIGINAL_INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
ORIGINAL_INPRATE_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_RATE_BYTES_DISPLAY VARCHAR2(4000)
TIME_TAKEN_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_PIECE_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
BS_KEY NUMBER
BP_KEY NUMBER
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)
PIECES_PER_SET NUMBER
SIZE_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_COPY_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
COPY_KEY NUMBER
FILE# NUMBER
NAME VARCHAR2(513)
TAG VARCHAR2(32)
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
MARKED_CORRUPT NUMBER
OUTPUT_BYTES NUMBER
COMPLETION_TIME DATE
CONTROLFILE_TYPE VARCHAR2(1)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$PROXY_COPY_DETAILS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
COPY_KEY NUMBER
FILE# NUMBER
HANDLE VARCHAR2(513)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
TAG VARCHAR2(32)
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
OUTPUT_BYTES NUMBER
COMPLETION_TIME DATE
CONTROLFILE_TYPE VARCHAR2(1)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$PROXY_ARCHIVELOG_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
COPY_KEY NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
HANDLE VARCHAR2(513)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
TAG VARCHAR2(32)
FIRST_CHANGE# NUMBER
NEXT_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_TIME DATE
OUTPUT_BYTES NUMBER
COMPLETION_TIME DATE
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_DATAFILE_DETAILS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BTYPE CHAR(9)
BTYPE_KEY NUMBER
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
ID1 NUMBER
ID2 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
MARKED_CORRUPT NUMBER
FILESIZE NUMBER
COMPRESSION_RATIO NUMBER
TS# NUMBER
TSNAME VARCHAR2(30)
FILESIZE_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_CONTROLFILE_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
BTYPE CHAR(9)
BTYPE_KEY NUMBER
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
ID1 NUMBER
ID2 NUMBER
CREATION_TIME DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
FILESIZE NUMBER
COMPRESSION_RATIO NUMBER
FILESIZE_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_ARCHIVELOG_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
BTYPE CHAR(9)
BTYPE_KEY NUMBER
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
ID1 NUMBER
ID2 NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
NEXT_TIME DATE
FILESIZE NUMBER
COMPRESSION_RATIO NUMBER
FILESIZE_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_SPFILE_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
BS_KEY NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
MODIFICATION_TIME DATE
FILESIZE NUMBER
FILESIZE_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_DATAFILE_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
NUM_DISTINCT_TS_BACKED NUMBER
MIN_CHECKPOINT_CHANGE# NUMBER
MAX_CHECKPOINT_CHANGE# NUMBER
MIN_CHECKPOINT_TIME DATE
MAX_CHECKPOINT_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_CONTROLFILE_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_CHECKPOINT_CHANGE# NUMBER
MAX_CHECKPOINT_CHANGE# NUMBER
MIN_CHECKPOINT_TIME DATE
MAX_CHECKPOINT_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_ARCHIVELOG_SUMMARY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_FIRST_CHANGE# NUMBER
MAX_NEXT_CHANGE# NUMBER
MIN_FIRST_TIME DATE
MAX_NEXT_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_SPFILE_SUMMARY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_MODIFICATION_TIME DATE
MAX_MODIFICATION_TIME DATE
INPUT_BYTES NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_SET_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_BACKUPSETS NUMBER
OLDEST_BACKUP_TIME DATE
NEWEST_BACKUP_TIME DATE
OUTPUT_BYTES NUMBER
ORIGINAL_INPUT_BYTES NUMBER
ORIGINAL_INPRATE_BYTES NUMBER
OUTPUT_RATE_BYTES NUMBER
COMPRESSION_RATIO NUMBER
ORIGINAL_INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
ORIGINAL_INPRATE_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_RATE_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_COPY_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_COPIES NUMBER
NUM_DISTINCT_COPIES NUMBER
MIN_CHECKPOINT_CHANGE# NUMBER
MAX_CHECKPOINT_CHANGE# NUMBER
MIN_CHECKPOINT_TIME DATE
MAX_CHECKPOINT_TIME DATE
OUTPUT_BYTES NUMBER
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$PROXY_COPY_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_COPIES NUMBER
NUM_DISTINCT_COPIES NUMBER
MIN_CHECKPOINT_CHANGE# NUMBER
MAX_CHECKPOINT_CHANGE# NUMBER
MIN_CHECKPOINT_TIME DATE
MAX_CHECKPOINT_TIME DATE
OUTPUT_BYTES NUMBER
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$PROXY_ARCHIVELOG_SUMMARY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_FIRST_CHANGE# NUMBER
MAX_NEXT_CHANGE# NUMBER
MIN_FIRST_TIME DATE
MAX_NEXT_TIME DATE
OUTPUT_BYTES NUMBER
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$UNUSABLE_BACKUPFILE_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
BTYPE CHAR(9)
BTYPE_KEY NUMBER
ID1 NUMBER
ID2 NUMBER
FILETYPE VARCHAR2(15)
FILETYPE_KEY NUMBER
STATUS VARCHAR2(1)
FILESIZE NUMBER
DEVICE_TYPE VARCHAR2(17)
FILENAME VARCHAR2(513)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
SQL> desc V$SQLSTATS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SQL_TEXT VARCHAR2(1000)
SQL_FULLTEXT CLOB
SQL_ID VARCHAR2(13)
LAST_ACTIVE_TIME DATE
LAST_ACTIVE_CHILD_ADDRESS RAW(4)
PLAN_HASH_VALUE NUMBER
PARSE_CALLS NUMBER
DISK_READS NUMBER
DIRECT_WRITES NUMBER
BUFFER_GETS NUMBER
ROWS_PROCESSED NUMBER
SERIALIZABLE_ABORTS NUMBER
FETCHES NUMBER
EXECUTIONS NUMBER
END_OF_FETCH_COUNT NUMBER
LOADS NUMBER
VERSION_COUNT NUMBER
INVALIDATIONS NUMBER
PX_SERVERS_EXECUTIONS 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
SORTS NUMBER
SHARABLE_MEM NUMBER
TOTAL_SHARABLE_MEM NUMBER
SQL> desc V$WALLET ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CERT_ID VARCHAR2(52)
DN VARCHAR2(255)
SERIAL_NUM VARCHAR2(40)
ISSUER VARCHAR2(255)
KEYSIZE NUMBER
STATUS VARCHAR2(16)
SQL> desc V$RFS_THREAD;
Name Null? Type
----------------------------------------- -------- ----------------------------
THREAD# NUMBER
RESETLOGS_CHANGE# NUMBER
RESET_TIMESTAMP NUMBER
LAST_REDO_SEQ# NUMBER
LAST_REDO_BLK# NUMBER
LAST_REDO_TIME DATE
LOW_GAP_SCN NUMBER
LOW_GAP_TIME DATE
LAST_PING_TIME DATE
SQL> desc V$DATAGUARD_STATS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(32)
VALUE VARCHAR2(64)
UNIT VARCHAR2(30)
TIME_COMPUTED VARCHAR2(30)
SQL> desc V$STANDBY_APPLY_SNAPSHOT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SNAPSHOT_TIME DATE
SESSION_ID NUMBER
THREAD# NUMBER
RESET_TIMESTAMP NUMBER
SEQUENCE# NUMBER
BLOCK# NUMBER
APPLIED_SCN NUMBER
APPLIED_TIME DATE
NEWEST_RESET_TIMESTAMP NUMBER
NEWEST_ARCHIVED_SEQ# NUMBER
NEWEST_TIME DATE
NEWEST_USED NUMBER
NEWEST_SRL_SEQ# NUMBER
BLOCKSIZE NUMBER
APPLY_RATE NUMBER
SQL> desc V$RMAN_BACKUP_TYPE;
Name Null? Type
----------------------------------------- -------- ----------------------------
WEIGHT NUMBER
INPUT_TYPE VARCHAR2(13)
SQL> desc V$MUTEX_SLEEP_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
SLEEP_TIMESTAMP TIMESTAMP(6)
MUTEX_TYPE VARCHAR2(32)
GETS NUMBER
SLEEPS NUMBER
REQUESTING_SESSION NUMBER
BLOCKING_SESSION NUMBER
LOCATION VARCHAR2(40)
MUTEX_VALUE RAW(4)
P1 NUMBER
P1RAW RAW(4)
P2 NUMBER
P3 NUMBER
P4 NUMBER
P5 VARCHAR2(64)
SQL> desc V$MUTEX_SLEEP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
MUTEX_TYPE VARCHAR2(32)
LOCATION VARCHAR2(40)
SLEEPS NUMBER
WAIT_TIME NUMBER
SQL> desc V$RMAN_ENCRYPTION_ALGORITHMS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ALGORITHM_ID NUMBER
ALGORITHM_NAME VARCHAR2(64)
ALGORITHM_DESCRIPTION VARCHAR2(64)
IS_DEFAULT VARCHAR2(3)
RESTORE_ONLY VARCHAR2(3)
SQL> desc V$WAITSTAT
Name Null? Type
----------------------------------------- -------- ----------------------------
CLASS VARCHAR2(18)
COUNT NUMBER
TIME NUMBER
SQL> desc V$BH ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
BLOCK# NUMBER
CLASS# NUMBER
STATUS VARCHAR2(7)
XNC NUMBER
FORCED_READS NUMBER
FORCED_WRITES NUMBER
LOCK_ELEMENT_ADDR RAW(4)
LOCK_ELEMENT_NAME NUMBER
LOCK_ELEMENT_CLASS NUMBER
DIRTY VARCHAR2(1)
TEMP VARCHAR2(1)
PING VARCHAR2(1)
STALE VARCHAR2(1)
DIRECT VARCHAR2(1)
NEW CHAR(1)
OBJD NUMBER
TS# NUMBER
SQL> desc V$GC_ELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
GC_ELEMENT_ADDR RAW(4)
INDX NUMBER
CLASS NUMBER
GC_ELEMENT_NAME NUMBER
MODE_HELD NUMBER
BLOCK_COUNT NUMBER
RELEASING NUMBER
ACQUIRING NUMBER
WRITING NUMBER
RECOVERING NUMBER
LOCAL NUMBER
FLAGS NUMBER
SQL> desc V$CR_BLOCK_SERVER;
Name Null? Type
----------------------------------------- -------- ----------------------------
CR_REQUESTS NUMBER
CURRENT_REQUESTS NUMBER
DATA_REQUESTS NUMBER
UNDO_REQUESTS NUMBER
TX_REQUESTS NUMBER
CURRENT_RESULTS NUMBER
PRIVATE_RESULTS NUMBER
ZERO_RESULTS NUMBER
DISK_READ_RESULTS NUMBER
FAIL_RESULTS NUMBER
FAIRNESS_DOWN_CONVERTS NUMBER
FAIRNESS_CLEARS NUMBER
FREE_GC_ELEMENTS NUMBER
FLUSHES NUMBER
FLUSHES_QUEUED NUMBER
FLUSH_QUEUE_FULL NUMBER
FLUSH_MAX_TIME NUMBER
LIGHT_WORKS NUMBER
ERRORS NUMBER
SQL> desc V$CURRENT_BLOCK_SERVER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
PIN1 NUMBER
PIN10 NUMBER
PIN100 NUMBER
PIN1000 NUMBER
PIN10000 NUMBER
FLUSH1 NUMBER
FLUSH10 NUMBER
FLUSH100 NUMBER
FLUSH1000 NUMBER
FLUSH10000 NUMBER
WRITE1 NUMBER
WRITE10 NUMBER
WRITE100 NUMBER
WRITE1000 NUMBER
WRITE10000 NUMBER
SQL> desc V$GC_ELEMENTS_WITH_COLLISIONS;
Name Null? Type
----------------------------------------- -------- ----------------------------
GC_ELEMENT_ADDR RAW(4)
SQL> desc V$FILE_CACHE_TRANSFER;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NUMBER NUMBER
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
RBR NUMBER
RBR_FORCED_WRITE NUMBER
RBR_FORCED_STALE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
NULL_2_S NUMBER
CR_TRANSFERS NUMBER
CUR_TRANSFERS NUMBER
SQL> desc V$TEMP_CACHE_TRANSFER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NUMBER NUMBER
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
RBR NUMBER
RBR_FORCED_WRITE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
NULL_2_S NUMBER
SQL> desc V$CLASS_CACHE_TRANSFER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CLASS CHAR(10)
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
NULL_2_S NUMBER
CR_TRANSFER NUMBER
CURRENT_TRANSFER NUMBER
SQL> desc V$INSTANCE_CACHE_TRANSFER;
Name Null? Type
----------------------------------------- -------- ----------------------------
INSTANCE NUMBER
CLASS VARCHAR2(18)
CR_BLOCK NUMBER
CR_BUSY NUMBER
CR_CONGESTED NUMBER
CURRENT_BLOCK NUMBER
CURRENT_BUSY NUMBER
CURRENT_CONGESTED NUMBER
SQL> desc V$LOCK_ELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOCK_ELEMENT_ADDR RAW(4)
INDX NUMBER
CLASS NUMBER
LOCK_ELEMENT_NAME NUMBER
MODE_HELD NUMBER
BLOCK_COUNT NUMBER
RELEASING NUMBER
ACQUIRING NUMBER
INVALID NUMBER
FLAGS NUMBER
SQL> desc V$BSP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CR_REQUESTS NUMBER
CURRENT_REQUESTS NUMBER
DATA_REQUESTS NUMBER
UNDO_REQUESTS NUMBER
TX_REQUESTS NUMBER
CURRENT_RESULTS NUMBER
PRIVATE_RESULTS NUMBER
ZERO_RESULTS NUMBER
DISK_READ_RESULTS NUMBER
FAIL_RESULTS NUMBER
FAIRNESS_DOWN_CONVERTS NUMBER
FAIRNESS_CLEARS NUMBER
FREE_LOCK_ELEMENTS NUMBER
FLUSHES NUMBER
FLUSHES_QUEUED NUMBER
FLUSH_QUEUE_FULL NUMBER
FLUSH_MAX_TIME NUMBER
LIGHT_WORKS NUMBER
ERRORS NUMBER
SQL> desc V$LOCKS_WITH_COLLISIONS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOCK_ELEMENT_ADDR RAW(4)
SQL> desc V$FILE_PING ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NUMBER NUMBER
FREQUENCY NUMBER
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
X_2_SSX NUMBER
X_2_SSX_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
SS_2_NULL NUMBER
SS_2_RLS NUMBER
WRB NUMBER
WRB_FORCED_WRITE NUMBER
RBR NUMBER
RBR_FORCED_WRITE NUMBER
RBR_FORCED_STALE NUMBER
CBR NUMBER
CBR_FORCED_WRITE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
SSX_2_X NUMBER
NULL_2_S NUMBER
NULL_2_SS NUMBER
OP_2_SS NUMBER
SQL> desc V$TEMP_PING;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NUMBER NUMBER
FREQUENCY NUMBER
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
X_2_SSX NUMBER
X_2_SSX_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
SS_2_NULL NUMBER
SS_2_RLS NUMBER
WRB NUMBER
WRB_FORCED_WRITE NUMBER
RBR NUMBER
RBR_FORCED_WRITE NUMBER
RBR_FORCED_STALE NUMBER
CBR NUMBER
CBR_FORCED_WRITE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
SSX_2_X NUMBER
NULL_2_S NUMBER
NULL_2_SS NUMBER
OP_2_SS NUMBER
SQL> desc V$CLASS_PING;
Name Null? Type
----------------------------------------- -------- ----------------------------
CLASS CHAR(10)
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
X_2_SSX NUMBER
X_2_SSX_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
SS_2_NULL NUMBER
SS_2_RLS NUMBER
OP_2_SS NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
SSX_2_X NUMBER
NULL_2_S NUMBER
NULL_2_SS NUMBER
SQL> desc V$LOCK_ACTIVITY;
Name Null? Type
----------------------------------------- -------- ----------------------------
FROM_VAL CHAR(4)
TO_VAL CHAR(1)
ACTION_VAL CHAR(21)
COUNTER NUMBER
SQL> desc V$ROWCACHE;
Name Null? Type
----------------------------------------- -------- ----------------------------
CACHE# NUMBER
TYPE VARCHAR2(11)
SUBORDINATE# NUMBER
PARAMETER VARCHAR2(32)
COUNT NUMBER
USAGE NUMBER
FIXED NUMBER
GETS NUMBER
GETMISSES NUMBER
SCANS NUMBER
SCANMISSES NUMBER
SCANCOMPLETES NUMBER
MODIFICATIONS NUMBER
FLUSHES NUMBER
DLM_REQUESTS NUMBER
DLM_CONFLICTS NUMBER
DLM_RELEASES NUMBER
SQL> desc V$ROWCACHE_PARENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
INDX NUMBER
HASH NUMBER
ADDRESS RAW(4)
CACHE# NUMBER
CACHE_NAME VARCHAR2(64)
EXISTENT VARCHAR2(1)
LOCK_MODE NUMBER
LOCK_REQUEST NUMBER
TXN RAW(4)
SADDR RAW(4)
INST_LOCK_REQUEST NUMBER
INST_LOCK_RELEASE NUMBER
INST_LOCK_TYPE VARCHAR2(2)
INST_LOCK_ID1 RAW(4)
INST_LOCK_ID2 RAW(4)
KEY RAW(100)
SQL> desc V$ROWCACHE_SUBORDINATE;
Name Null? Type
----------------------------------------- -------- ----------------------------
INDX NUMBER
HASH NUMBER
ADDRESS RAW(4)
CACHE# NUMBER
SUBCACHE# NUMBER
SUBCACHE_NAME VARCHAR2(64)
EXISTENT VARCHAR2(1)
PARENT RAW(4)
KEY RAW(100)
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
MODIFICATION_TIME DATE
BYTES NUMBER
COMPLETION_TIME DATE
SQL> desc V$BACKUP_SYNC_IO;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL NUMBER
USE_COUNT NUMBER
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
DEVICE_TYPE VARCHAR2(17)
TYPE VARCHAR2(9)
STATUS VARCHAR2(11)
FILENAME VARCHAR2(513)
SET_COUNT NUMBER
SET_STAMP NUMBER
BUFFER_SIZE NUMBER
BUFFER_COUNT NUMBER
TOTAL_BYTES NUMBER
OPEN_TIME DATE
CLOSE_TIME DATE
ELAPSED_TIME NUMBER
MAXOPENFILES NUMBER
BYTES NUMBER
EFFECTIVE_BYTES_PER_SECOND NUMBER
IO_COUNT NUMBER
IO_TIME_TOTAL NUMBER
IO_TIME_MAX NUMBER
DISCRETE_BYTES_PER_SECOND NUMBER
SQL> desc V$BACKUP_ASYNC_IO ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL NUMBER
USE_COUNT NUMBER
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
DEVICE_TYPE VARCHAR2(17)
TYPE VARCHAR2(9)
STATUS VARCHAR2(11)
FILENAME VARCHAR2(513)
SET_COUNT NUMBER
SET_STAMP NUMBER
BUFFER_SIZE NUMBER
BUFFER_COUNT NUMBER
TOTAL_BYTES NUMBER
OPEN_TIME DATE
CLOSE_TIME DATE
ELAPSED_TIME NUMBER
MAXOPENFILES NUMBER
BYTES NUMBER
EFFECTIVE_BYTES_PER_SECOND NUMBER
IO_COUNT NUMBER
READY NUMBER
SHORT_WAITS NUMBER
SHORT_WAIT_TIME_TOTAL NUMBER
SHORT_WAIT_TIME_MAX NUMBER
LONG_WAITS NUMBER
LONG_WAIT_TIME_TOTAL NUMBER
LONG_WAIT_TIME_MAX NUMBER
SQL> desc V$RESERVED_WORDS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
KEYWORD VARCHAR2(30)
LENGTH NUMBER
RESERVED VARCHAR2(1)
RES_TYPE VARCHAR2(1)
RES_ATTR VARCHAR2(1)
RES_SEMI VARCHAR2(1)
DUPLICATE VARCHAR2(1)
SQL> desc V$DLM_TRAFFIC_CONTROLLER;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOCAL_NID NUMBER
REMOTE_NID NUMBER
REMOTE_RID NUMBER
REMOTE_INC NUMBER
TCKT_AVAIL NUMBER
TCKT_LIMIT NUMBER
TCKT_RCVD NUMBER
TCKT_WAIT VARCHAR2(10)
SND_SEQ_NO NUMBER
RCV_SEQ_NO NUMBER
SND_Q_LEN NUMBER
SND_Q_MAX NUMBER
SND_Q_TOT NUMBER
SND_Q_TM_BASE NUMBER
SND_Q_TM_WRAP NUMBER
STATUS NUMBER
SND_PROXY NUMBER
SQL> desc V$HS_PARAMETER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
HS_SESSION_ID NUMBER
PARAMETER VARCHAR2(30)
VALUE VARCHAR2(64)
SOURCE VARCHAR2(1)
ENV VARCHAR2(1)
SQL> desc V$UNDOSTAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
UNDOTSN NUMBER
UNDOBLKS NUMBER
TXNCOUNT NUMBER
MAXQUERYLEN NUMBER
MAXQUERYID VARCHAR2(13)
MAXCONCURRENCY NUMBER
UNXPSTEALCNT NUMBER
UNXPBLKRELCNT NUMBER
UNXPBLKREUCNT NUMBER
EXPSTEALCNT NUMBER
EXPBLKRELCNT NUMBER
EXPBLKREUCNT NUMBER
SSOLDERRCNT NUMBER
NOSPACEERRCNT NUMBER
ACTIVEBLKS NUMBER
UNEXPIREDBLKS NUMBER
EXPIREDBLKS NUMBER
TUNED_UNDORETENTION NUMBER
SQL> desc V$SGA_TARGET_ADVICE;
Name Null? Type
----------------------------------------- -------- ----------------------------
SGA_SIZE NUMBER
SGA_SIZE_FACTOR NUMBER
ESTD_DB_TIME NUMBER
ESTD_DB_TIME_FACTOR NUMBER
ESTD_PHYSICAL_READS NUMBER
SQL> desc V$DB_CACHE_ADVICE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
ADVICE_STATUS VARCHAR2(3)
SIZE_FOR_ESTIMATE NUMBER
SIZE_FACTOR NUMBER
BUFFERS_FOR_ESTIMATE NUMBER
ESTD_PHYSICAL_READ_FACTOR NUMBER
ESTD_PHYSICAL_READS NUMBER
ESTD_PHYSICAL_READ_TIME NUMBER
ESTD_PCT_OF_DB_TIME_FOR_READS NUMBER
ESTD_CLUSTER_READS NUMBER
ESTD_CLUSTER_READ_TIME NUMBER
SQL> desc V$MTTR_TARGET_ADVICE;
Name Null? Type
----------------------------------------- -------- ----------------------------
MTTR_TARGET_FOR_ESTIMATE NUMBER
ADVICE_STATUS VARCHAR2(5)
DIRTY_LIMIT NUMBER
ESTD_CACHE_WRITES NUMBER
ESTD_CACHE_WRITE_FACTOR NUMBER
ESTD_TOTAL_WRITES NUMBER
ESTD_TOTAL_WRITE_FACTOR NUMBER
ESTD_TOTAL_IOS NUMBER
ESTD_TOTAL_IO_FACTOR NUMBER
SQL> desc V$LOGMNR_LOGFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOG_ID NUMBER
FILENAME VARCHAR2(513)
LOW_TIME NUMBER
NEXT_TIME NUMBER
DB_ID NUMBER
DB_NAME VARCHAR2(8)
RESET_SCNWRP NUMBER
RESET_SCNBAS NUMBER
RESET_SCN_TIME NUMBER
THREAD_ID NUMBER
THREAD_SQN NUMBER
LOW_SCNWRP NUMBER
LOW_SCNBAS NUMBER
NEXT_SCNWRP NUMBER
NEXT_SCNBAS NUMBER
FILE_STATE VARCHAR2(13)
SQL> desc V$LOGMNR_PROCESS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
PID NUMBER
SPID VARCHAR2(12)
ROLE VARCHAR2(32)
USERNAME VARCHAR2(15)
SID NUMBER
SERIAL# NUMBER
LATCHWAIT VARCHAR2(8)
LATCHSPIN VARCHAR2(8)
WORK_MICROSEC VARCHAR2(21)
OVERHEAD_MICROSEC VARCHAR2(21)
SQL> desc V$LOGMNR_TRANSACTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
XID RAW(8)
XIDUSN NUMBER
XIDSLT NUMBER
XIDSQN NUMBER
PARENT_XID RAW(8)
PARENT_XIDUSN NUMBER
PARENT_XIDSLT NUMBER
PARENT_XIDSQN NUMBER
START_TIME DATE
START_SCN NUMBER
CHUNK# NUMBER
TOTAL_CHUNKS NUMBER
REDO_THREAD NUMBER
LOW_TIME DATE
LOW_SCN NUMBER
HIGH_TIME DATE
HIGH_SCN NUMBER
LCR_COUNT NUMBER
SPILLED_LCR_COUNT NUMBER
DFLAG NUMBER
MFLAG NUMBER
MFLAG2 NUMBER
STATE VARCHAR2(32)
TYPE VARCHAR2(32)
MINING_STATUS VARCHAR2(32)
QUEUE VARCHAR2(32)
SQL> desc V$LOGMNR_REGION;
Name Null? Type
----------------------------------------- -------- ----------------------------
MEMSTATE NUMBER
STATE VARCHAR2(9)
OWNING_PROCESS NUMBER
SQL> desc V$LOGMNR_CALLBACK;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
FUNCTION_ID NUMBER
DESCRIPTION VARCHAR2(64)
TYPE VARCHAR2(15)
SQL> desc V$LOGMNR_SESSION;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
SESSION_NAME VARCHAR2(32)
SESSION_STATE VARCHAR2(9)
DB_NAME VARCHAR2(128)
DB_ID NUMBER
RESET_SCN NUMBER
RESET_TIMESTAMP NUMBER
NUM_PROCESS NUMBER
CHUNK_SIZE NUMBER
START_SCN NUMBER
END_SCN NUMBER
SPILL_SCN NUMBER
PROCESSED_SCN NUMBER
PREPARED_SCN NUMBER
READ_SCN NUMBER
LOW_MARK_SCN NUMBER
CONSUMED_SCN NUMBER
MAX_MEMORY_SIZE NUMBER
USED_MEMORY_SIZE NUMBER
PREPARED_WORK_SIZE NUMBER
AVAILABLE_WORK_SIZE NUMBER
AVAILABLE_TXN NUMBER
AVAILABLE_COMMITTED_TXN NUMBER
DELIVERED_TXN NUMBER
DELIVERED_COMMITTED_TXN NUMBER
PINNED_TXN NUMBER
PINNED_COMMITTED_TXN NUMBER
CHECKPOINT_INTERVAL NUMBER
SQL> desc V$LOGMNR_LATCH;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
NAME VARCHAR2(32)
CHILD_ADDR RAW(4)
STATE VARCHAR2(6)
SQL> desc V$LOGMNR_DICTIONARY_LOAD;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
LOGMNR_UID NUMBER
ACTION# NUMBER
OPCODE NUMBER
COMMAND VARCHAR2(161)
CURRENT_STATE VARCHAR2(32)
COMPLETED_ACTIONS NUMBER
TOTAL_ACTIONS NUMBER
LOADED VARCHAR2(7)
PERCENT_DONE NUMBER
SQL> desc V$SQL_WORKAREA;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS RAW(4)
HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
CHILD_NUMBER NUMBER
WORKAREA_ADDRESS RAW(4)
OPERATION_TYPE VARCHAR2(20)
OPERATION_ID 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$SQL_WORKAREA_ACTIVE;
Name Null? Type
----------------------------------------- -------- ----------------------------
SQL_HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
WORKAREA_ADDRESS RAW(4)
OPERATION_TYPE VARCHAR2(20)
OPERATION_ID NUMBER
POLICY VARCHAR2(6)
SID NUMBER
QCINST_ID NUMBER
QCSID NUMBER
ACTIVE_TIME NUMBER
WORK_AREA_SIZE NUMBER
EXPECTED_SIZE NUMBER
ACTUAL_MEM_USED NUMBER
MAX_MEM_USED NUMBER
NUMBER_PASSES NUMBER
TEMPSEG_SIZE NUMBER
TABLESPACE VARCHAR2(30)
SEGRFNO# NUMBER
SEGBLK# NUMBER
SQL> desc V$PGASTAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(64)
VALUE NUMBER
UNIT VARCHAR2(12)
SQL> desc V$SQL_WORKAREA_HISTOGRAM;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOW_OPTIMAL_SIZE NUMBER
HIGH_OPTIMAL_SIZE NUMBER
OPTIMAL_EXECUTIONS NUMBER
ONEPASS_EXECUTIONS NUMBER
MULTIPASSES_EXECUTIONS NUMBER
TOTAL_EXECUTIONS NUMBER
SQL> desc V$PGA_TARGET_ADVICE_HISTOGRAM;
Name Null? Type
----------------------------------------- -------- ----------------------------
PGA_TARGET_FOR_ESTIMATE NUMBER
PGA_TARGET_FACTOR NUMBER
ADVICE_STATUS VARCHAR2(3)
LOW_OPTIMAL_SIZE NUMBER
HIGH_OPTIMAL_SIZE NUMBER
ESTD_OPTIMAL_EXECUTIONS NUMBER
ESTD_ONEPASS_EXECUTIONS NUMBER
ESTD_MULTIPASSES_EXECUTIONS NUMBER
ESTD_TOTAL_EXECUTIONS NUMBER
IGNORED_WORKAREAS_COUNT 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
SQL> desc V$STREAMS_CAPTURE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
CAPTURE# NUMBER
CAPTURE_NAME VARCHAR2(30)
LOGMINER_ID NUMBER
STARTUP_TIME DATE
STATE VARCHAR2(73)
TOTAL_PREFILTER_DISCARDED NUMBER
TOTAL_PREFILTER_KEPT NUMBER
TOTAL_PREFILTER_EVALUATIONS NUMBER
TOTAL_MESSAGES_CAPTURED NUMBER
CAPTURE_TIME DATE
CAPTURE_MESSAGE_NUMBER NUMBER
CAPTURE_MESSAGE_CREATE_TIME DATE
TOTAL_MESSAGES_CREATED NUMBER
TOTAL_FULL_EVALUATIONS NUMBER
TOTAL_MESSAGES_ENQUEUED NUMBER
ENQUEUE_TIME DATE
ENQUEUE_MESSAGE_NUMBER NUMBER
ENQUEUE_MESSAGE_CREATE_TIME DATE
AVAILABLE_MESSAGE_NUMBER NUMBER
AVAILABLE_MESSAGE_CREATE_TIME DATE
ELAPSED_CAPTURE_TIME NUMBER
ELAPSED_RULE_TIME NUMBER
ELAPSED_ENQUEUE_TIME NUMBER
ELAPSED_LCR_TIME NUMBER
ELAPSED_REDO_WAIT_TIME NUMBER
ELAPSED_PAUSE_TIME NUMBER
STATE_CHANGED_TIME DATE
SQL> desc V$STREAMS_TRANSACTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
STREAMS_NAME VARCHAR2(30)
STREAMS_TYPE VARCHAR2(10)
XIDUSN NUMBER
XIDSLT NUMBER
XIDSQN NUMBER
CUMULATIVE_MESSAGE_COUNT NUMBER
TOTAL_MESSAGE_COUNT NUMBER
FIRST_MESSAGE_TIME DATE
FIRST_MESSAGE_NUMBER DATE
LAST_MESSAGE_TIME DATE
LAST_MESSAGE_NUMBER DATE
SQL> desc V$TIMEZONE_NAMES ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TZNAME VARCHAR2(64)
TZABBREV VARCHAR2(64)
SQL> desc V$TIMEZONE_FILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILENAME VARCHAR2(12)
VERSION NUMBER
SQL> desc V$ENQUEUE_STAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
INST_ID NUMBER
EQ_TYPE VARCHAR2(2)
TOTAL_REQ# NUMBER
TOTAL_WAIT# NUMBER
SUCC_REQ# NUMBER
FAILED_REQ# NUMBER
CUM_WAIT_TIME NUMBER
SQL> desc V$ENQUEUE_STATISTICS;
Name Null? Type
----------------------------------------- -------- ----------------------------
EQ_NAME VARCHAR2(64)
EQ_TYPE VARCHAR2(2)
REQ_REASON VARCHAR2(64)
TOTAL_REQ# NUMBER
TOTAL_WAIT# NUMBER
SUCC_REQ# NUMBER
FAILED_REQ# NUMBER
CUM_WAIT_TIME NUMBER
REQ_DESCRIPTION VARCHAR2(4000)
EVENT# NUMBER
SQL> desc V$LOCK_TYPE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TYPE VARCHAR2(64)
NAME VARCHAR2(64)
ID1_TAG VARCHAR2(64)
ID2_TAG VARCHAR2(64)
IS_USER VARCHAR2(3)
DESCRIPTION VARCHAR2(4000)
SQL> desc V$REPLQUEUE;
Name Null? Type
----------------------------------------- -------- ----------------------------
TXNS_ENQUEUED NUMBER
CALLS_ENQUEUED NUMBER
TXNS_PURGED NUMBER
LAST_ENQUEUE_TIME DATE
LAST_PURGE_TIME DATE
SQL> desc V$REPLPROP;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
NAME VARCHAR2(71)
DBLINK VARCHAR2(128)
STATE VARCHAR2(12)
XID VARCHAR2(22)
SEQUENCE NUMBER
SQL> desc V$MVREFRESH ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
CURRMVOWNER VARCHAR2(31)
CURRMVNAME VARCHAR2(31)
SQL> desc V$LOGSTDBY;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERIAL# NUMBER
LOGSTDBY_ID NUMBER
PID VARCHAR2(12)
TYPE VARCHAR2(30)
STATUS_CODE NUMBER
STATUS VARCHAR2(256)
HIGH_SCN NUMBER
SQL> desc V$LOGSTDBY_STATS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(64)
VALUE VARCHAR2(64)
SQL> desc V$LOGSTDBY_TRANSACTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
PRIMARY_XID RAW(8)
PRIMARY_START_SCN NUMBER
PRIMARY_START_TIME DATE
PRIMARY_PARENT_XID RAW(8)
MINING_STATUS VARCHAR2(32)
APPLY_STATUS VARCHAR2(6)
SID NUMBER
SERIAL# NUMBER
SQL> desc V$LOGSTDBY_PROCESS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
LOGSTDBY_ID NUMBER
SPID VARCHAR2(12)
TYPE VARCHAR2(30)
STATUS_CODE NUMBER
STATUS VARCHAR2(256)
HIGH_SCN NUMBER
SQL> desc V$LOGSTDBY_PROGRESS;
Name Null? Type
----------------------------------------- -------- ----------------------------
APPLIED_SCN NUMBER
APPLIED_TIME DATE
RESTART_SCN NUMBER
RESTART_TIME DATE
LATEST_SCN NUMBER
LATEST_TIME DATE
MINING_SCN NUMBER
MINING_TIME DATE
SQL> desc V$LOGSTDBY_STATE;
Name Null? Type
----------------------------------------- -------- ----------------------------
PRIMARY_DBID NUMBER
SESSION_ID NUMBER
REALTIME_APPLY VARCHAR2(64)
STATE VARCHAR2(64)
SQL> desc V$VPD_POLICY;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS RAW(4)
PARADDR RAW(4)
SQL_HASH NUMBER
SQL_ID VARCHAR2(13)
CHILD_NUMBER NUMBER
OBJECT_OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
POLICY_GROUP VARCHAR2(30)
POLICY VARCHAR2(30)
POLICY_FUNCTION_OWNER VARCHAR2(30)
PREDICATE VARCHAR2(4000)
SQL> desc V$SQL_REDIRECTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS RAW(4)
PARENT_HANDLE RAW(4)
HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
CHILD_NUMBER NUMBER
PARSING_USER_ID NUMBER
PARSING_SCHEMA_ID NUMBER
COMMAND_TYPE NUMBER
REASON VARCHAR2(14)
ERROR_CODE NUMBER
POSITION NUMBER
SQL_TEXT_PIECE VARCHAR2(1000)
ERROR_MESSAGE VARCHAR2(1000)
SQL> desc V$HVMASTER_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
HV_ID NUMBER
CURRENT_MASTER NUMBER
PREVIOUS_MASTER NUMBER
REMASTER_CNT NUMBER
SQL> desc V$GCSHVMASTER_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
HV_ID NUMBER
CURRENT_MASTER NUMBER
PREVIOUS_MASTER NUMBER
REMASTER_CNT NUMBER
SQL> desc V$GCSPFMASTER_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_ID NUMBER
OBJECT_ID NUMBER
CURRENT_MASTER NUMBER
PREVIOUS_MASTER NUMBER
REMASTER_CNT NUMBER
SQL> desc V$DATABASE_BLOCK_CORRUPTION;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
CORRUPTION_CHANGE# NUMBER
CORRUPTION_TYPE VARCHAR2(9)
SQL> desc V$LOGMNR_STATS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
NAME VARCHAR2(32)
VALUE VARCHAR2(21)
SQL> desc V$ASM_TEMPLATE;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
ENTRY_NUMBER NUMBER
REDUNDANCY VARCHAR2(6)
STRIPE VARCHAR2(6)
SYSTEM VARCHAR2(1)
NAME VARCHAR2(30)
SQL> desc V$ASM_ALIAS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(48)
GROUP_NUMBER NUMBER
FILE_NUMBER NUMBER
FILE_INCARNATION NUMBER
ALIAS_INDEX NUMBER
ALIAS_INCARNATION NUMBER
PARENT_INDEX NUMBER
REFERENCE_INDEX NUMBER
ALIAS_DIRECTORY VARCHAR2(1)
SYSTEM_CREATED VARCHAR2(1)
SQL> desc V$ASM_FILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
FILE_NUMBER NUMBER
COMPOUND_INDEX NUMBER
INCARNATION NUMBER
BLOCK_SIZE NUMBER
BLOCKS NUMBER
BYTES NUMBER
SPACE NUMBER
TYPE VARCHAR2(64)
REDUNDANCY VARCHAR2(6)
STRIPED VARCHAR2(6)
CREATION_DATE DATE
MODIFICATION_DATE DATE
REDUNDANCY_LOWERED VARCHAR2(1)
SQL> desc V$ASM_CLIENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
INSTANCE_NAME VARCHAR2(64)
DB_NAME VARCHAR2(8)
STATUS VARCHAR2(12)
SOFTWARE_VERSION VARCHAR2(60)
COMPATIBLE_VERSION VARCHAR2(60)
SQL> desc V$ASM_DISKGROUP;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
NAME VARCHAR2(30)
SECTOR_SIZE NUMBER
BLOCK_SIZE NUMBER
ALLOCATION_UNIT_SIZE NUMBER
STATE VARCHAR2(11)
TYPE VARCHAR2(6)
TOTAL_MB NUMBER
FREE_MB NUMBER
REQUIRED_MIRROR_FREE_MB NUMBER
USABLE_FILE_MB NUMBER
OFFLINE_DISKS NUMBER
UNBALANCED VARCHAR2(1)
COMPATIBILITY VARCHAR2(60)
DATABASE_COMPATIBILITY VARCHAR2(60)
SQL> desc V$ASM_DISKGROUP_STAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
NAME VARCHAR2(30)
SECTOR_SIZE NUMBER
BLOCK_SIZE NUMBER
ALLOCATION_UNIT_SIZE NUMBER
STATE VARCHAR2(11)
TYPE VARCHAR2(6)
TOTAL_MB NUMBER
FREE_MB NUMBER
REQUIRED_MIRROR_FREE_MB NUMBER
USABLE_FILE_MB NUMBER
OFFLINE_DISKS NUMBER
UNBALANCED VARCHAR2(1)
COMPATIBILITY VARCHAR2(60)
DATABASE_COMPATIBILITY VARCHAR2(60)
SQL> desc V$ASM_DISK;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
DISK_NUMBER NUMBER
COMPOUND_INDEX NUMBER
INCARNATION NUMBER
MOUNT_STATUS VARCHAR2(7)
HEADER_STATUS VARCHAR2(12)
MODE_STATUS VARCHAR2(7)
STATE VARCHAR2(8)
REDUNDANCY VARCHAR2(7)
LIBRARY VARCHAR2(64)
TOTAL_MB NUMBER
FREE_MB NUMBER
NAME VARCHAR2(30)
FAILGROUP VARCHAR2(30)
LABEL VARCHAR2(31)
PATH VARCHAR2(256)
UDID VARCHAR2(64)
PRODUCT VARCHAR2(32)
CREATE_DATE DATE
MOUNT_DATE DATE
REPAIR_TIMER NUMBER
READS NUMBER
WRITES NUMBER
READ_ERRS NUMBER
WRITE_ERRS NUMBER
READ_TIME NUMBER
WRITE_TIME NUMBER
BYTES_READ NUMBER
BYTES_WRITTEN NUMBER
SQL> desc V$ASM_DISK_STAT;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
DISK_NUMBER NUMBER
COMPOUND_INDEX NUMBER
INCARNATION NUMBER
MOUNT_STATUS VARCHAR2(7)
HEADER_STATUS VARCHAR2(12)
MODE_STATUS VARCHAR2(7)
STATE VARCHAR2(8)
REDUNDANCY VARCHAR2(7)
LIBRARY VARCHAR2(64)
TOTAL_MB NUMBER
FREE_MB NUMBER
NAME VARCHAR2(30)
FAILGROUP VARCHAR2(30)
LABEL VARCHAR2(31)
PATH VARCHAR2(256)
UDID VARCHAR2(64)
PRODUCT VARCHAR2(32)
CREATE_DATE DATE
MOUNT_DATE DATE
REPAIR_TIMER NUMBER
READS NUMBER
WRITES NUMBER
READ_ERRS NUMBER
WRITE_ERRS NUMBER
READ_TIME NUMBER
WRITE_TIME NUMBER
BYTES_READ NUMBER
BYTES_WRITTEN NUMBER
SQL> desc V$ASM_OPERATION ;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
OPERATION VARCHAR2(5)
STATE VARCHAR2(4)
POWER NUMBER
ACTUAL NUMBER
SOFAR NUMBER
EST_WORK NUMBER
EST_RATE NUMBER
EST_MINUTES NUMBER
SQL> desc V$STATISTICS_LEVEL;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATISTICS_NAME VARCHAR2(64)
DESCRIPTION VARCHAR2(4000)
SESSION_STATUS VARCHAR2(8)
SYSTEM_STATUS VARCHAR2(8)
ACTIVATION_LEVEL VARCHAR2(7)
STATISTICS_VIEW_NAME VARCHAR2(64)
SESSION_SETTABLE VARCHAR2(3)
SQL> desc V$DATABASE_INCARNATION;
Name Null? Type
----------------------------------------- -------- ----------------------------
INCARNATION# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
PRIOR_RESETLOGS_CHANGE# NUMBER
PRIOR_RESETLOGS_TIME DATE
STATUS VARCHAR2(7)
RESETLOGS_ID NUMBER
PRIOR_INCARNATION# NUMBER
FLASHBACK_DATABASE_ALLOWED VARCHAR2(26)
SQL> desc V$AW_OLAP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
AW_NUMBER NUMBER
ATTACH_MODE VARCHAR2(10)
GENERATION NUMBER
TEMP_SPACE_PAGES NUMBER
TEMP_SPACE_READS NUMBER
LOB_READS NUMBER
POOL_CHANGED_PAGES NUMBER
POOL_UNCHANGED_PAGES NUMBER
SQL> desc V$AW_CALC ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
AGGREGATE_CACHE_HITS NUMBER
AGGREGATE_CACHE_MISSES NUMBER
SESSION_CACHE_HITS NUMBER
SESSION_CACHE_MISSES NUMBER
POOL_HITS NUMBER
POOL_MISSES NUMBER
POOL_NEW_PAGES NUMBER
POOL_RECLAIMED_PAGES NUMBER
CACHE_WRITES NUMBER
POOL_SIZE NUMBER
CURR_DML_COMMAND VARCHAR2(64)
PREV_DML_COMMAND VARCHAR2(64)
AGGR_FUNC_LOGICAL_NA NUMBER
AGGR_FUNC_PRECOMPUTE NUMBER
AGGR_FUNC_CALCS NUMBER
SQL> desc V$AW_SESSION_INFO;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
CLIENT_TYPE VARCHAR2(64)
SESSION_STATE VARCHAR2(64)
SESSION_HANDLE NUMBER
USERID VARCHAR2(64)
TOTAL_TRANSACTION NUMBER
TRANSACTION_TIME NUMBER
TOTAL_TRANSACTION_TIME NUMBER
AVERAGE_TRANSACTION_TIME NUMBER
TRANSACTION_CPU_TIME NUMBER
TOTAL_TRANSACTION_CPU_TIME NUMBER
AVERAGE_TRANSACTION_CPU_TIME NUMBER
SQL> desc V$MAP_FILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_MAP_IDX NUMBER
FILE_CFGID VARCHAR2(256)
FILE_STATUS VARCHAR2(7)
FILE_NAME VARCHAR2(256)
FILE_TYPE VARCHAR2(11)
FILE_STRUCTURE VARCHAR2(9)
FILE_SIZE NUMBER
FILE_NEXTS NUMBER
LIB_IDX NUMBER
SQL> desc V$MAP_FILE_EXTENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_MAP_IDX NUMBER
EXT_NUM NUMBER
EXT_ELEM_OFF NUMBER
EXT_SIZE NUMBER
EXT_FILE_OFF NUMBER
EXT_TYPE VARCHAR2(6)
ELEM_IDX NUMBER
SQL> desc V$MAP_ELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
ELEM_NAME VARCHAR2(256)
ELEM_IDX NUMBER
ELEM_CFGID VARCHAR2(256)
ELEM_TYPE VARCHAR2(12)
ELEM_SIZE NUMBER
ELEM_NSUBELEM NUMBER
ELEM_DESCR VARCHAR2(256)
STRIPE_SIZE NUMBER
LIB_IDX NUMBER
SQL> desc V$MAP_EXT_ELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
ELEM_IDX NUMBER
NUM_ATTRB NUMBER
ATTRB1_NAME VARCHAR2(256)
ATTRB1_VAL VARCHAR2(256)
ATTRB2_NAME VARCHAR2(256)
ATTRB2_VAL VARCHAR2(256)
ATTRB3_NAME VARCHAR2(256)
ATTRB3_VAL VARCHAR2(256)
ATTRB4_NAME VARCHAR2(256)
ATTRB4_VAL VARCHAR2(256)
ATTRB5_NAME VARCHAR2(256)
ATTRB5_VAL VARCHAR2(256)
SQL> desc V$MAP_COMP_LIST ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ELEM_IDX NUMBER
NUM_COMP NUMBER
COMP1_NAME VARCHAR2(256)
COMP1_VAL VARCHAR2(256)
COMP2_NAME VARCHAR2(256)
COMP2_VAL VARCHAR2(256)
COMP3_NAME VARCHAR2(256)
COMP3_VAL VARCHAR2(256)
COMP4_NAME VARCHAR2(256)
COMP4_VAL VARCHAR2(256)
COMP5_NAME VARCHAR2(256)
COMP5_VAL VARCHAR2(256)
SQL> desc V$MAP_SUBELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
CHILD_IDX NUMBER
PARENT_IDX NUMBER
SUB_NUM NUMBER
SUB_SIZE NUMBER
ELEM_OFFSET NUMBER
SUB_FLAGS NUMBER
SQL> desc V$MAP_FILE_IO_STACK ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_MAP_IDX NUMBER
DEPTH NUMBER
ELEM_IDX NUMBER
CU_SIZE NUMBER
STRIDE NUMBER
NUM_CU NUMBER
ELEM_OFFSET NUMBER
FILE_OFFSET NUMBER
DATA_TYPE VARCHAR2(15)
PARITY_POS NUMBER
PARITY_PERIOD NUMBER
ID NUMBER
PARENT_ID NUMBER
SQL> desc V$MAP_LIBRARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
LIB_IDX NUMBER
LIB_NAME VARCHAR2(256)
VENDOR_NAME VARCHAR2(64)
PROTOCOL_NUM NUMBER
VERSION_NUM VARCHAR2(32)
PATH_NAME VARCHAR2(1024)
MAP_FILE VARCHAR2(1)
FILE_CFGID VARCHAR2(13)
MAP_ELEM VARCHAR2(1)
ELEM_CFGID VARCHAR2(13)
MAP_SYNC VARCHAR2(1)
SQL> desc V$DATAPUMP_JOB ;
Name Null? Type
----------------------------------------- -------- ----------------------------
JOB_ID RAW(16)
JOB_NAME VARCHAR2(30)
OWNER_NAME VARCHAR2(30)
MSG_CTRL_QUEUE VARCHAR2(30)
STATUS_QUEUE VARCHAR2(30)
OPERATION VARCHAR2(30)
JOB_MODE VARCHAR2(30)
MASTER_ID NUMBER
STATE VARCHAR2(30)
WORKERS NUMBER
FLAGS NUMBER
SQL> desc V$DATAPUMP_SESSION;
Name Null? Type
----------------------------------------- -------- ----------------------------
ATTACH_ID NUMBER
JOB_ID RAW(16)
SADDR RAW(4)
TYPE VARCHAR2(14)
SQL> desc V$RULE_SET ;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(30)
NAME VARCHAR2(30)
CPU_TIME NUMBER
ELAPSED_TIME NUMBER
FIRST_LOAD_TIME DATE
LAST_LOAD_TIME DATE
LAST_LOADING_TIME NUMBER
SHARABLE_MEM NUMBER
RELOADS NUMBER
INVALIDATIONS NUMBER
EVALUATIONS NUMBER
FIRST_HIT_EVALUATIONS NUMBER
SIMPLE_RULES_ONLY_EVALUATIONS NUMBER
SQL_FREE_EVALUATIONS NUMBER
SQL_EXECUTIONS NUMBER
CONDITIONS_PROCESSED NUMBER
TRUE_RULES NUMBER
MAYBE_RULES NUMBER
VARIABLE_VALUE_FUNCTION_CALLS NUMBER
VARIABLE_METHOD_FUNCTION_CALLS NUMBER
EVALUATION_FUNCTION_CALLS NUMBER
SQL> desc V$RULE_SET_AGGREGATE_STATS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(80)
VALUE NUMBER
SQL> desc V$JAVAPOOL;
Name Null? Type
----------------------------------------- -------- ----------------------------
CATEGORY VARCHAR2(16)
MEMUSED NUMBER
SQL> desc V$SYSAUX_OCCUPANTS;
Name Null? Type
----------------------------------------- -------- ----------------------------
OCCUPANT_NAME VARCHAR2(64)
OCCUPANT_DESC VARCHAR2(64)
SCHEMA_NAME VARCHAR2(64)
MOVE_PROCEDURE VARCHAR2(64)
MOVE_PROCEDURE_DESC VARCHAR2(64)
SPACE_USAGE_KBYTES NUMBER
SQL> desc V$RECOVERY_FILE_DEST;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(513)
SPACE_LIMIT NUMBER
SPACE_USED NUMBER
SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES NUMBER
SQL> desc V$FLASH_RECOVERY_AREA_USAGE;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_TYPE VARCHAR2(12)
PERCENT_SPACE_USED NUMBER
PERCENT_SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES NUMBER
SQL> desc V$AW_AGGREGATE_OP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(14)
LONGNAME VARCHAR2(30)
DEFAULT_WEIGHT NUMBER
SQL> desc V$AW_ALLOCATE_OP;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(14)
LONGNAME VARCHAR2(30)
SQL> desc V$TRANSPORTABLE_PLATFORM ;
Name Null? Type
----------------------------------------- -------- ----------------------------
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2(101)
ENDIAN_FORMAT VARCHAR2(14)
SQL> desc V$BLOCK_CHANGE_TRACKING;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATUS VARCHAR2(10)
FILENAME VARCHAR2(513)
BYTES NUMBER
SQL> desc V$RULE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
RULE_SET_OBJECT_ID NUMBER
EVALUATION_CONTEXT_OBJECT_ID NUMBER
RULE_OWNER VARCHAR2(30)
RULE_NAME VARCHAR2(30)
RULE_CONDITION VARCHAR2(200)
TRUE_HITS NUMBER
MAYBE_HITS NUMBER
SQL_EVALUATIONS NUMBER
SQL> desc V$FLASHBACK_DATABASE_LOGFILE;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(513)
LOG# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
SQL> desc V$FLASHBACK_DATABASE_LOG;
Name Null? Type
----------------------------------------- -------- ----------------------------
OLDEST_FLASHBACK_SCN NUMBER
OLDEST_FLASHBACK_TIME DATE
RETENTION_TARGET NUMBER
FLASHBACK_SIZE NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
SQL> desc V$FLASHBACK_DATABASE_STAT ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
SQL> desc V$ACTIVE_SESSION_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
SAMPLE_ID NUMBER
SAMPLE_TIME TIMESTAMP(3)
SESSION_ID NUMBER
SESSION_SERIAL# NUMBER
USER_ID NUMBER
SQL_ID VARCHAR2(13)
SQL_CHILD_NUMBER NUMBER
SQL_PLAN_HASH_VALUE NUMBER
FORCE_MATCHING_SIGNATURE NUMBER
SQL_OPCODE NUMBER
SERVICE_HASH NUMBER
SESSION_TYPE VARCHAR2(10)
SESSION_STATE VARCHAR2(7)
QC_SESSION_ID NUMBER
QC_INSTANCE_ID NUMBER
BLOCKING_SESSION NUMBER
BLOCKING_SESSION_STATUS VARCHAR2(11)
BLOCKING_SESSION_SERIAL# NUMBER
EVENT VARCHAR2(64)
EVENT_ID NUMBER
EVENT# NUMBER
SEQ# NUMBER
P1TEXT VARCHAR2(64)
P1 NUMBER
P2TEXT VARCHAR2(64)
P2 NUMBER
P3TEXT VARCHAR2(64)
P3 NUMBER
WAIT_CLASS VARCHAR2(64)
WAIT_CLASS_ID NUMBER
WAIT_TIME NUMBER
TIME_WAITED NUMBER
XID RAW(8)
CURRENT_OBJ# NUMBER
CURRENT_FILE# NUMBER
CURRENT_BLOCK# NUMBER
PROGRAM VARCHAR2(64)
MODULE VARCHAR2(48)
ACTION VARCHAR2(32)
CLIENT_ID VARCHAR2(64)
SQL> desc V$RMAN_STATUS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
RECID NUMBER
STAMP NUMBER
PARENT_RECID NUMBER
PARENT_STAMP NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
ROW_LEVEL NUMBER
ROW_TYPE VARCHAR2(19)
COMMAND_ID VARCHAR2(33)
OPERATION VARCHAR2(33)
STATUS VARCHAR2(23)
MBYTES_PROCESSED NUMBER
START_TIME DATE
END_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
OPTIMIZED VARCHAR2(3)
OBJECT_TYPE VARCHAR2(13)
OUTPUT_DEVICE_TYPE VARCHAR2(17)
SQL> desc V$RMAN_OUTPUT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
RECID NUMBER
STAMP NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
OUTPUT VARCHAR2(130)
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
SESSION_KEY NUMBER
SQL> desc V$ACTIVE_SERVICES;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
BLOCKED VARCHAR2(3)
AQ_HA_NOTIFICATION VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
SQL> desc V$SERVICE_WAIT_CLASS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_NAME VARCHAR2(64)
SERVICE_NAME_HASH NUMBER
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
TOTAL_WAITS NUMBER
TIME_WAITED NUMBER
SQL> desc V$SERVICE_EVENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_NAME VARCHAR2(64)
SERVICE_NAME_HASH NUMBER
EVENT VARCHAR2(64)
EVENT_ID NUMBER
TOTAL_WAITS NUMBER
TOTAL_TIMEOUTS NUMBER
TIME_WAITED NUMBER
AVERAGE_WAIT NUMBER
MAX_WAIT NUMBER
TIME_WAITED_MICRO NUMBER
SQL> desc V$SERVICES;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
AQ_HA_NOTIFICATION VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
SQL> desc V$AW_LONGOPS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
CURSOR_NAME VARCHAR2(64)
COMMAND VARCHAR2(7)
STATUS VARCHAR2(9)
ROWS_PROCESSED NUMBER
START_TIME TIMESTAMP(3)
SQL> desc V$METRICGROUP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_ID NUMBER
NAME VARCHAR2(64)
INTERVAL_SIZE NUMBER
MAX_INTERVAL NUMBER
SQL> desc V$METRICNAME;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_ID NUMBER
GROUP_NAME VARCHAR2(64)
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
METRIC_UNIT VARCHAR2(64)
SQL> desc V$METRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
ENTITY_ID NUMBER
ENTITY_SEQUENCE NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
VALUE NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$METRIC_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
ENTITY_ID NUMBER
ENTITY_SEQUENCE NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
VALUE NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$SYSMETRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
VALUE NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$SYSMETRIC_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
VALUE NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$FILESPACE_USAGE ;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_ID NUMBER
RFNO NUMBER
ALLOCATED_SPACE NUMBER
FILE_SIZE NUMBER
FILE_MAXSIZE NUMBER
CHANGESCN_BASE NUMBER
CHANGESCN_WRAP NUMBER
FLAG NUMBER
SQL> desc V$SCHEDULER_RUNNING_JOBS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NUMBER
SESSION_SERIAL_NUM NUMBER
JOB_ID NUMBER
PADDR RAW(4)
OS_PROCESS_ID VARCHAR2(12)
SESSION_STAT_CPU INTERVAL DAY(2) TO SECOND(3)
SQL> desc V$BUFFERED_QUEUES;
Name Null? Type
----------------------------------------- -------- ----------------------------
QUEUE_ID NUMBER
QUEUE_SCHEMA VARCHAR2(30)
QUEUE_NAME VARCHAR2(30)
STARTUP_TIME DATE
NUM_MSGS NUMBER
SPILL_MSGS NUMBER
CNUM_MSGS NUMBER
CSPILL_MSGS NUMBER
EXPIRED_MSGS NUMBER
SQL> desc V$BUFFERED_SUBSCRIBERS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
QUEUE_ID NUMBER
QUEUE_SCHEMA VARCHAR2(30)
QUEUE_NAME VARCHAR2(30)
SUBSCRIBER_ID NUMBER
SUBSCRIBER_NAME VARCHAR2(30)
SUBSCRIBER_ADDRESS VARCHAR2(1024)
PROTOCOL NUMBER
SUBSCRIBER_TYPE VARCHAR2(30)
STARTUP_TIME DATE
LAST_BROWSED_SEQ NUMBER
LAST_BROWSED_NUM NUMBER
LAST_DEQUEUED_SEQ NUMBER
LAST_DEQUEUED_NUM NUMBER
CURRENT_ENQ_SEQ NUMBER
NUM_MSGS NUMBER
CNUM_MSGS NUMBER
TOTAL_DEQUEUED_MSG NUMBER
TOTAL_SPILLED_MSG NUMBER
EXPIRED_MSGS NUMBER
SQL> desc V$BUFFERED_PUBLISHERS;
Name Null? Type
----------------------------------------- -------- ----------------------------
QUEUE_ID NUMBER
QUEUE_SCHEMA VARCHAR2(30)
QUEUE_NAME VARCHAR2(30)
SENDER_NAME VARCHAR2(30)
SENDER_ADDRESS VARCHAR2(1024)
SENDER_PROTOCOL NUMBER
NUM_MSGS NUMBER
CNUM_MSGS NUMBER
LAST_ENQUEUED_MSG NUMBER
UNBROWSED_MSGS NUMBER
OVERSPILLED_MSGS NUMBER
MEMORY_USAGE NUMBER
PUBLISHER_STATE VARCHAR2(59)
SQL> desc V$TSM_SESSIONS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
SERIAL# NUMBER
STATE VARCHAR2(24)
MIGRATABLE VARCHAR2(3)
MIGRATION_ALLOWED VARCHAR2(3)
TRANSFERABLE VARCHAR2(3)
MIGRATION_BOUNDARY VARCHAR2(3)
NONMIGRATABILITY_REASON VARCHAR2(4000)
NONMIGRATABILITY_INFO VARCHAR2(4000)
NONTRANSFERABILITY_REASON VARCHAR2(4000)
NONTRANSFERABILITY_INFO VARCHAR2(4000)
STATELESS VARCHAR2(11)
PRESERVE_STATE VARCHAR2(3)
COST NUMBER
DESTINATION VARCHAR2(4000)
ROUNDTRIPS NUMBER
BLOCKING_COMPONENT VARCHAR2(4000)
START_TIME DATE
SEQUENCE_NUMBER NUMBER
SQL> desc V$PROPAGATION_SENDER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
QUEUE_ID NUMBER
QUEUE_SCHEMA VARCHAR2(30)
QUEUE_NAME VARCHAR2(30)
DST_QUEUE_SCHEMA VARCHAR2(30)
DST_QUEUE_NAME VARCHAR2(30)
STARTUP_TIME DATE
DBLINK VARCHAR2(128)
HIGH_WATER_MARK NUMBER
ACKNOWLEDGEMENT NUMBER
SCHEDULE_STATUS VARCHAR2(30)
TOTAL_MSGS NUMBER
TOTAL_BYTES NUMBER
ELAPSED_DEQUEUE_TIME NUMBER
ELAPSED_PICKLE_TIME NUMBER
ELAPSED_PROPAGATION_TIME NUMBER
MAX_NUM_PER_WIN NUMBER
MAX_SIZE NUMBER
SQL> desc V$PROPAGATION_RECEIVER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SRC_QUEUE_SCHEMA VARCHAR2(30)
SRC_QUEUE_NAME VARCHAR2(30)
SRC_DBNAME VARCHAR2(128)
DST_QUEUE_SCHEMA VARCHAR2(30)
DST_QUEUE_NAME VARCHAR2(30)
STARTUP_TIME DATE
HIGH_WATER_MARK NUMBER
ACKNOWLEDGEMENT NUMBER
TOTAL_MSGS NUMBER
ELAPSED_UNPICKLE_TIME NUMBER
ELAPSED_RULE_TIME NUMBER
ELAPSED_ENQUEUE_TIME NUMBER
SQL> desc V$CLIENT_STATS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CLIENT_IDENTIFIER VARCHAR2(64)
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SERV_MOD_ACT_STATS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
AGGREGATION_TYPE VARCHAR2(21)
SERVICE_NAME VARCHAR2(64)
MODULE VARCHAR2(49)
ACTION VARCHAR2(33)
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SERVICE_STATS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_NAME_HASH NUMBER
SERVICE_NAME VARCHAR2(64)
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SYS_TIME_MODEL;
Name Null? Type
----------------------------------------- -------- ----------------------------
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SESS_TIME_MODEL;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
SQL> desc V$SYSMETRIC_SUMMARY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
METRIC_ID NUMBER
METRIC_NAME VARCHAR2(64)
NUM_INTERVAL NUMBER
MAXVAL NUMBER
MINVAL NUMBER
AVERAGE NUMBER
STANDARD_DEVIATION NUMBER
METRIC_UNIT VARCHAR2(64)
SQL> desc V$SESSMETRIC ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
SESSION_ID NUMBER
SESSION_SERIAL_NUM NUMBER
CPU NUMBER
PHYSICAL_READS NUMBER
LOGICAL_READS NUMBER
PGA_MEMORY NUMBER
HARD_PARSES NUMBER
SOFT_PARSES NUMBER
PHYSICAL_READ_PCT NUMBER
LOGICAL_READ_PCT NUMBER
SQL> desc V$FILEMETRIC ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
FILE_ID NUMBER
CREATION_TIME NUMBER
AVERAGE_READ_TIME NUMBER
AVERAGE_WRITE_TIME NUMBER
PHYSICAL_READS NUMBER
PHYSICAL_WRITES NUMBER
PHYSICAL_BLOCK_READS NUMBER
PHYSICAL_BLOCK_WRITES NUMBER
SQL> desc V$FILEMETRIC_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
FILE_ID NUMBER
CREATION_TIME NUMBER
AVERAGE_READ_TIME NUMBER
AVERAGE_WRITE_TIME NUMBER
PHYSICAL_READS NUMBER
PHYSICAL_WRITES NUMBER
PHYSICAL_BLOCK_READS NUMBER
PHYSICAL_BLOCK_WRITES NUMBER
SQL> desc V$EVENTMETRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
EVENT# NUMBER
EVENT_ID NUMBER
NUM_SESS_WAITING NUMBER
TIME_WAITED NUMBER
WAIT_COUNT NUMBER
SQL> desc V$WAITCLASSMETRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS_ID NUMBER
AVERAGE_WAITER_COUNT NUMBER
DBTIME_IN_WAIT NUMBER
TIME_WAITED NUMBER
WAIT_COUNT NUMBER
SQL> desc V$WAITCLASSMETRIC_HISTORY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS_ID NUMBER
AVERAGE_WAITER_COUNT NUMBER
DBTIME_IN_WAIT NUMBER
TIME_WAITED NUMBER
WAIT_COUNT NUMBER
SQL> desc V$SERVICEMETRIC;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
SERVICE_NAME_HASH NUMBER
SERVICE_NAME VARCHAR2(64)
CTMHASH NUMBER
ELAPSEDPERCALL NUMBER
CPUPERCALL NUMBER
DBTIMEPERCALL NUMBER
CALLSPERSEC NUMBER
DBTIMEPERSEC NUMBER
GOODNESS NUMBER
DELTA NUMBER
FLAGS NUMBER
SQL> desc V$SERVICEMETRIC_HISTORY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BEGIN_TIME DATE
END_TIME DATE
INTSIZE_CSEC NUMBER
GROUP_ID NUMBER
SERVICE_NAME_HASH NUMBER
SERVICE_NAME VARCHAR2(64)
CTMHASH NUMBER
ELAPSEDPERCALL NUMBER
CPUPERCALL NUMBER
DBTIMEPERCALL NUMBER
CALLSPERSEC NUMBER
DBTIMEPERSEC NUMBER
SQL> desc V$XML_AUDIT_TRAIL;
Name Null? Type
----------------------------------------- -------- ----------------------------
AUDIT_TYPE NUMBER
SESSION_ID NUMBER
PROXY_SESSIONID NUMBER
STATEMENTID NUMBER
ENTRYID NUMBER
EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE
GLOBAL_UID VARCHAR2(32)
DB_USER VARCHAR2(30)
CLIENTIDENTIFIER VARCHAR2(64)
EXT_NAME VARCHAR2(1024)
OS_USER VARCHAR2(30)
OS_HOST VARCHAR2(128)
OS_PROCESS VARCHAR2(16)
TERMINAL VARCHAR2(16)
INSTANCE_NUMBER NUMBER
OBJECT_SCHEMA VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
POLICY_NAME VARCHAR2(30)
NEW_OWNER VARCHAR2(30)
NEW_NAME VARCHAR2(30)
ACTION NUMBER
STATEMENT_TYPE NUMBER
TRANSACTIONID RAW(8)
RETURNCODE NUMBER
SCN NUMBER
COMMENT_TEXT VARCHAR2(4000)
AUTH_PRIVILEGES VARCHAR2(16)
GRANTEE VARCHAR2(30)
PRIV_USED NUMBER
SES_ACTIONS VARCHAR2(16)
OS_PRIVILEGE VARCHAR2(7)
ECONTEXT_ID VARCHAR2(64)
SQL_BIND VARCHAR2(4000)
SQL_TEXT VARCHAR2(4000)
SQL> desc V$ALERT_TYPES ;
Name Null? Type
----------------------------------------- -------- ----------------------------
REASON_ID NUMBER
OBJECT_TYPE VARCHAR2(64)
TYPE VARCHAR2(9)
GROUP_NAME VARCHAR2(64)
SCOPE VARCHAR2(8)
INTERNAL_METRIC_CATEGORY VARCHAR2(64)
INTERNAL_METRIC_NAME VARCHAR2(64)
SQL> desc V$THRESHOLD_TYPES;
Name Null? Type
----------------------------------------- -------- ----------------------------
METRICS_ID NUMBER
METRICS_GROUP_ID NUMBER
OPERATOR_MASK NUMBER
OBJECT_TYPE VARCHAR2(64)
ALERT_REASON_ID NUMBER
METRIC_VALUE_TYPE NUMBER
SQL> desc V$RESTORE_POINT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SCN NUMBER
DATABASE_INCARNATION# NUMBER
GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
STORAGE_SIZE NUMBER
TIME TIMESTAMP(9)
NAME VARCHAR2(128)
SQL> desc V$DB_TRANSPORTABLE_PLATFORM;
Name Null? Type
----------------------------------------- -------- ----------------------------
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2(101)
ENDIAN_FORMAT VARCHAR2(14)
SQL> desc V$SQL_JOIN_FILTER;
Name Null? Type
----------------------------------------- -------- ----------------------------
QC_SESSION_ID NUMBER
QC_INSTANCE_ID NUMBER
SQL_PLAN_HASH_VALUE NUMBER
LENGTH NUMBER
BITS_SET NUMBER
FILTERED NUMBER
PROBED NUMBER
ACTIVE NUMBER
SQL> desc V$RMAN_BACKUP_SUBJOB_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
OPERATION VARCHAR2(33)
COMMAND_ID VARCHAR2(33)
START_TIME DATE
END_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
STATUS_WEIGHT NUMBER
OBJECT_TYPE_WEIGHT NUMBER
OPTIMIZED_WEIGHT NUMBER
OUTPUT_DEVICE_TYPE VARCHAR2(17)
AUTOBACKUP_DONE VARCHAR2(3)
STATUS VARCHAR2(23)
INPUT_TYPE VARCHAR2(13)
OPTIMIZED VARCHAR2(3)
AUTOBACKUP_COUNT NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$RMAN_BACKUP_JOB_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
COMMAND_ID VARCHAR2(33)
START_TIME DATE
END_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
STATUS_WEIGHT NUMBER
OPTIMIZED_WEIGHT NUMBER
OBJECT_TYPE_WEIGHT NUMBER
OUTPUT_DEVICE_TYPE VARCHAR2(17)
AUTOBACKUP_COUNT NUMBER
AUTOBACKUP_DONE VARCHAR2(3)
STATUS VARCHAR2(23)
INPUT_TYPE VARCHAR2(13)
OPTIMIZED VARCHAR2(3)
ELAPSED_SECONDS NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_PER_SEC NUMBER
OUTPUT_BYTES_PER_SEC NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
INPUT_BYTES_PER_SEC_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_PER_SEC_DISPLAY VARCHAR2(4000)
TIME_TAKEN_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_SET_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
BS_KEY NUMBER
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
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
DEVICE_TYPE VARCHAR2(17)
COMPRESSED VARCHAR2(3)
NUM_COPIES NUMBER
OUTPUT_BYTES NUMBER
ORIGINAL_INPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
STATUS CHAR(1)
ORIGINAL_INPRATE_BYTES NUMBER
OUTPUT_RATE_BYTES NUMBER
ORIGINAL_INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
ORIGINAL_INPRATE_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_RATE_BYTES_DISPLAY VARCHAR2(4000)
TIME_TAKEN_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_PIECE_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
BS_KEY NUMBER
BP_KEY NUMBER
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)
PIECES_PER_SET NUMBER
SIZE_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_COPY_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
COPY_KEY NUMBER
FILE# NUMBER
NAME VARCHAR2(513)
TAG VARCHAR2(32)
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
MARKED_CORRUPT NUMBER
OUTPUT_BYTES NUMBER
COMPLETION_TIME DATE
CONTROLFILE_TYPE VARCHAR2(1)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$PROXY_COPY_DETAILS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
COPY_KEY NUMBER
FILE# NUMBER
HANDLE VARCHAR2(513)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
TAG VARCHAR2(32)
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
OUTPUT_BYTES NUMBER
COMPLETION_TIME DATE
CONTROLFILE_TYPE VARCHAR2(1)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$PROXY_ARCHIVELOG_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
COPY_KEY NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
HANDLE VARCHAR2(513)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
TAG VARCHAR2(32)
FIRST_CHANGE# NUMBER
NEXT_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_TIME DATE
OUTPUT_BYTES NUMBER
COMPLETION_TIME DATE
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_DATAFILE_DETAILS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
BTYPE CHAR(9)
BTYPE_KEY NUMBER
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
ID1 NUMBER
ID2 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
MARKED_CORRUPT NUMBER
FILESIZE NUMBER
COMPRESSION_RATIO NUMBER
TS# NUMBER
TSNAME VARCHAR2(30)
FILESIZE_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_CONTROLFILE_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
BTYPE CHAR(9)
BTYPE_KEY NUMBER
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
ID1 NUMBER
ID2 NUMBER
CREATION_TIME DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
FILESIZE NUMBER
COMPRESSION_RATIO NUMBER
FILESIZE_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_ARCHIVELOG_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
BTYPE CHAR(9)
BTYPE_KEY NUMBER
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
ID1 NUMBER
ID2 NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
NEXT_TIME DATE
FILESIZE NUMBER
COMPRESSION_RATIO NUMBER
FILESIZE_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_SPFILE_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
BS_KEY NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
MODIFICATION_TIME DATE
FILESIZE NUMBER
FILESIZE_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_DATAFILE_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
NUM_DISTINCT_TS_BACKED NUMBER
MIN_CHECKPOINT_CHANGE# NUMBER
MAX_CHECKPOINT_CHANGE# NUMBER
MIN_CHECKPOINT_TIME DATE
MAX_CHECKPOINT_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_CONTROLFILE_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_CHECKPOINT_CHANGE# NUMBER
MAX_CHECKPOINT_CHANGE# NUMBER
MIN_CHECKPOINT_TIME DATE
MAX_CHECKPOINT_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_ARCHIVELOG_SUMMARY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_FIRST_CHANGE# NUMBER
MAX_NEXT_CHANGE# NUMBER
MIN_FIRST_TIME DATE
MAX_NEXT_TIME DATE
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_SPFILE_SUMMARY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_MODIFICATION_TIME DATE
MAX_MODIFICATION_TIME DATE
INPUT_BYTES NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_SET_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_BACKUPSETS NUMBER
OLDEST_BACKUP_TIME DATE
NEWEST_BACKUP_TIME DATE
OUTPUT_BYTES NUMBER
ORIGINAL_INPUT_BYTES NUMBER
ORIGINAL_INPRATE_BYTES NUMBER
OUTPUT_RATE_BYTES NUMBER
COMPRESSION_RATIO NUMBER
ORIGINAL_INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
ORIGINAL_INPRATE_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_RATE_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$BACKUP_COPY_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_COPIES NUMBER
NUM_DISTINCT_COPIES NUMBER
MIN_CHECKPOINT_CHANGE# NUMBER
MAX_CHECKPOINT_CHANGE# NUMBER
MIN_CHECKPOINT_TIME DATE
MAX_CHECKPOINT_TIME DATE
OUTPUT_BYTES NUMBER
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$PROXY_COPY_SUMMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_COPIES NUMBER
NUM_DISTINCT_COPIES NUMBER
MIN_CHECKPOINT_CHANGE# NUMBER
MAX_CHECKPOINT_CHANGE# NUMBER
MIN_CHECKPOINT_TIME DATE
MAX_CHECKPOINT_TIME DATE
OUTPUT_BYTES NUMBER
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$PROXY_ARCHIVELOG_SUMMARY ;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM_FILES_BACKED NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_FIRST_CHANGE# NUMBER
MAX_NEXT_CHANGE# NUMBER
MIN_FIRST_TIME DATE
MAX_NEXT_TIME DATE
OUTPUT_BYTES NUMBER
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
SQL> desc V$UNUSABLE_BACKUPFILE_DETAILS;
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
BTYPE CHAR(9)
BTYPE_KEY NUMBER
ID1 NUMBER
ID2 NUMBER
FILETYPE VARCHAR2(15)
FILETYPE_KEY NUMBER
STATUS VARCHAR2(1)
FILESIZE NUMBER
DEVICE_TYPE VARCHAR2(17)
FILENAME VARCHAR2(513)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
SQL> desc V$SQLSTATS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
SQL_TEXT VARCHAR2(1000)
SQL_FULLTEXT CLOB
SQL_ID VARCHAR2(13)
LAST_ACTIVE_TIME DATE
LAST_ACTIVE_CHILD_ADDRESS RAW(4)
PLAN_HASH_VALUE NUMBER
PARSE_CALLS NUMBER
DISK_READS NUMBER
DIRECT_WRITES NUMBER
BUFFER_GETS NUMBER
ROWS_PROCESSED NUMBER
SERIALIZABLE_ABORTS NUMBER
FETCHES NUMBER
EXECUTIONS NUMBER
END_OF_FETCH_COUNT NUMBER
LOADS NUMBER
VERSION_COUNT NUMBER
INVALIDATIONS NUMBER
PX_SERVERS_EXECUTIONS 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
SORTS NUMBER
SHARABLE_MEM NUMBER
TOTAL_SHARABLE_MEM NUMBER
SQL> desc V$WALLET ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CERT_ID VARCHAR2(52)
DN VARCHAR2(255)
SERIAL_NUM VARCHAR2(40)
ISSUER VARCHAR2(255)
KEYSIZE NUMBER
STATUS VARCHAR2(16)
SQL> desc V$RFS_THREAD;
Name Null? Type
----------------------------------------- -------- ----------------------------
THREAD# NUMBER
RESETLOGS_CHANGE# NUMBER
RESET_TIMESTAMP NUMBER
LAST_REDO_SEQ# NUMBER
LAST_REDO_BLK# NUMBER
LAST_REDO_TIME DATE
LOW_GAP_SCN NUMBER
LOW_GAP_TIME DATE
LAST_PING_TIME DATE
SQL> desc V$DATAGUARD_STATS;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(32)
VALUE VARCHAR2(64)
UNIT VARCHAR2(30)
TIME_COMPUTED VARCHAR2(30)
SQL> desc V$STANDBY_APPLY_SNAPSHOT;
Name Null? Type
----------------------------------------- -------- ----------------------------
SNAPSHOT_TIME DATE
SESSION_ID NUMBER
THREAD# NUMBER
RESET_TIMESTAMP NUMBER
SEQUENCE# NUMBER
BLOCK# NUMBER
APPLIED_SCN NUMBER
APPLIED_TIME DATE
NEWEST_RESET_TIMESTAMP NUMBER
NEWEST_ARCHIVED_SEQ# NUMBER
NEWEST_TIME DATE
NEWEST_USED NUMBER
NEWEST_SRL_SEQ# NUMBER
BLOCKSIZE NUMBER
APPLY_RATE NUMBER
SQL> desc V$RMAN_BACKUP_TYPE;
Name Null? Type
----------------------------------------- -------- ----------------------------
WEIGHT NUMBER
INPUT_TYPE VARCHAR2(13)
SQL> desc V$MUTEX_SLEEP_HISTORY;
Name Null? Type
----------------------------------------- -------- ----------------------------
SLEEP_TIMESTAMP TIMESTAMP(6)
MUTEX_TYPE VARCHAR2(32)
GETS NUMBER
SLEEPS NUMBER
REQUESTING_SESSION NUMBER
BLOCKING_SESSION NUMBER
LOCATION VARCHAR2(40)
MUTEX_VALUE RAW(4)
P1 NUMBER
P1RAW RAW(4)
P2 NUMBER
P3 NUMBER
P4 NUMBER
P5 VARCHAR2(64)
SQL> desc V$MUTEX_SLEEP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
MUTEX_TYPE VARCHAR2(32)
LOCATION VARCHAR2(40)
SLEEPS NUMBER
WAIT_TIME NUMBER
SQL> desc V$RMAN_ENCRYPTION_ALGORITHMS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ALGORITHM_ID NUMBER
ALGORITHM_NAME VARCHAR2(64)
ALGORITHM_DESCRIPTION VARCHAR2(64)
IS_DEFAULT VARCHAR2(3)
RESTORE_ONLY VARCHAR2(3)
SQL> desc V$WAITSTAT
Name Null? Type
----------------------------------------- -------- ----------------------------
CLASS VARCHAR2(18)
COUNT NUMBER
TIME NUMBER
SQL> desc V$BH ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
BLOCK# NUMBER
CLASS# NUMBER
STATUS VARCHAR2(7)
XNC NUMBER
FORCED_READS NUMBER
FORCED_WRITES NUMBER
LOCK_ELEMENT_ADDR RAW(4)
LOCK_ELEMENT_NAME NUMBER
LOCK_ELEMENT_CLASS NUMBER
DIRTY VARCHAR2(1)
TEMP VARCHAR2(1)
PING VARCHAR2(1)
STALE VARCHAR2(1)
DIRECT VARCHAR2(1)
NEW CHAR(1)
OBJD NUMBER
TS# NUMBER
SQL> desc V$GC_ELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
GC_ELEMENT_ADDR RAW(4)
INDX NUMBER
CLASS NUMBER
GC_ELEMENT_NAME NUMBER
MODE_HELD NUMBER
BLOCK_COUNT NUMBER
RELEASING NUMBER
ACQUIRING NUMBER
WRITING NUMBER
RECOVERING NUMBER
LOCAL NUMBER
FLAGS NUMBER
SQL> desc V$CR_BLOCK_SERVER;
Name Null? Type
----------------------------------------- -------- ----------------------------
CR_REQUESTS NUMBER
CURRENT_REQUESTS NUMBER
DATA_REQUESTS NUMBER
UNDO_REQUESTS NUMBER
TX_REQUESTS NUMBER
CURRENT_RESULTS NUMBER
PRIVATE_RESULTS NUMBER
ZERO_RESULTS NUMBER
DISK_READ_RESULTS NUMBER
FAIL_RESULTS NUMBER
FAIRNESS_DOWN_CONVERTS NUMBER
FAIRNESS_CLEARS NUMBER
FREE_GC_ELEMENTS NUMBER
FLUSHES NUMBER
FLUSHES_QUEUED NUMBER
FLUSH_QUEUE_FULL NUMBER
FLUSH_MAX_TIME NUMBER
LIGHT_WORKS NUMBER
ERRORS NUMBER
SQL> desc V$CURRENT_BLOCK_SERVER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
PIN1 NUMBER
PIN10 NUMBER
PIN100 NUMBER
PIN1000 NUMBER
PIN10000 NUMBER
FLUSH1 NUMBER
FLUSH10 NUMBER
FLUSH100 NUMBER
FLUSH1000 NUMBER
FLUSH10000 NUMBER
WRITE1 NUMBER
WRITE10 NUMBER
WRITE100 NUMBER
WRITE1000 NUMBER
WRITE10000 NUMBER
SQL> desc V$GC_ELEMENTS_WITH_COLLISIONS;
Name Null? Type
----------------------------------------- -------- ----------------------------
GC_ELEMENT_ADDR RAW(4)
SQL> desc V$FILE_CACHE_TRANSFER;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NUMBER NUMBER
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
RBR NUMBER
RBR_FORCED_WRITE NUMBER
RBR_FORCED_STALE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
NULL_2_S NUMBER
CR_TRANSFERS NUMBER
CUR_TRANSFERS NUMBER
SQL> desc V$TEMP_CACHE_TRANSFER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NUMBER NUMBER
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
RBR NUMBER
RBR_FORCED_WRITE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
NULL_2_S NUMBER
SQL> desc V$CLASS_CACHE_TRANSFER ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CLASS CHAR(10)
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
NULL_2_S NUMBER
CR_TRANSFER NUMBER
CURRENT_TRANSFER NUMBER
SQL> desc V$INSTANCE_CACHE_TRANSFER;
Name Null? Type
----------------------------------------- -------- ----------------------------
INSTANCE NUMBER
CLASS VARCHAR2(18)
CR_BLOCK NUMBER
CR_BUSY NUMBER
CR_CONGESTED NUMBER
CURRENT_BLOCK NUMBER
CURRENT_BUSY NUMBER
CURRENT_CONGESTED NUMBER
SQL> desc V$LOCK_ELEMENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOCK_ELEMENT_ADDR RAW(4)
INDX NUMBER
CLASS NUMBER
LOCK_ELEMENT_NAME NUMBER
MODE_HELD NUMBER
BLOCK_COUNT NUMBER
RELEASING NUMBER
ACQUIRING NUMBER
INVALID NUMBER
FLAGS NUMBER
SQL> desc V$BSP ;
Name Null? Type
----------------------------------------- -------- ----------------------------
CR_REQUESTS NUMBER
CURRENT_REQUESTS NUMBER
DATA_REQUESTS NUMBER
UNDO_REQUESTS NUMBER
TX_REQUESTS NUMBER
CURRENT_RESULTS NUMBER
PRIVATE_RESULTS NUMBER
ZERO_RESULTS NUMBER
DISK_READ_RESULTS NUMBER
FAIL_RESULTS NUMBER
FAIRNESS_DOWN_CONVERTS NUMBER
FAIRNESS_CLEARS NUMBER
FREE_LOCK_ELEMENTS NUMBER
FLUSHES NUMBER
FLUSHES_QUEUED NUMBER
FLUSH_QUEUE_FULL NUMBER
FLUSH_MAX_TIME NUMBER
LIGHT_WORKS NUMBER
ERRORS NUMBER
SQL> desc V$LOCKS_WITH_COLLISIONS ;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOCK_ELEMENT_ADDR RAW(4)
SQL> desc V$FILE_PING ;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NUMBER NUMBER
FREQUENCY NUMBER
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
X_2_SSX NUMBER
X_2_SSX_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
SS_2_NULL NUMBER
SS_2_RLS NUMBER
WRB NUMBER
WRB_FORCED_WRITE NUMBER
RBR NUMBER
RBR_FORCED_WRITE NUMBER
RBR_FORCED_STALE NUMBER
CBR NUMBER
CBR_FORCED_WRITE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
SSX_2_X NUMBER
NULL_2_S NUMBER
NULL_2_SS NUMBER
OP_2_SS NUMBER
SQL> desc V$TEMP_PING;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NUMBER NUMBER
FREQUENCY NUMBER
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
X_2_SSX NUMBER
X_2_SSX_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
SS_2_NULL NUMBER
SS_2_RLS NUMBER
WRB NUMBER
WRB_FORCED_WRITE NUMBER
RBR NUMBER
RBR_FORCED_WRITE NUMBER
RBR_FORCED_STALE NUMBER
CBR NUMBER
CBR_FORCED_WRITE NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
SSX_2_X NUMBER
NULL_2_S NUMBER
NULL_2_SS NUMBER
OP_2_SS NUMBER
SQL> desc V$CLASS_PING;
Name Null? Type
----------------------------------------- -------- ----------------------------
CLASS CHAR(10)
X_2_NULL NUMBER
X_2_NULL_FORCED_WRITE NUMBER
X_2_NULL_FORCED_STALE NUMBER
X_2_S NUMBER
X_2_S_FORCED_WRITE NUMBER
X_2_SSX NUMBER
X_2_SSX_FORCED_WRITE NUMBER
S_2_NULL NUMBER
S_2_NULL_FORCED_STALE NUMBER
SS_2_NULL NUMBER
SS_2_RLS NUMBER
OP_2_SS NUMBER
NULL_2_X NUMBER
S_2_X NUMBER
SSX_2_X NUMBER
NULL_2_S NUMBER
NULL_2_SS NUMBER
SQL> desc V$LOCK_ACTIVITY;
Name Null? Type
----------------------------------------- -------- ----------------------------
FROM_VAL CHAR(4)
TO_VAL CHAR(1)
ACTION_VAL CHAR(21)
COUNTER NUMBER
SQL> desc V$ROWCACHE;
Name Null? Type
----------------------------------------- -------- ----------------------------
CACHE# NUMBER
TYPE VARCHAR2(11)
SUBORDINATE# NUMBER
PARAMETER VARCHAR2(32)
COUNT NUMBER
USAGE NUMBER
FIXED NUMBER
GETS NUMBER
GETMISSES NUMBER
SCANS NUMBER
SCANMISSES NUMBER
SCANCOMPLETES NUMBER
MODIFICATIONS NUMBER
FLUSHES NUMBER
DLM_REQUESTS NUMBER
DLM_CONFLICTS NUMBER
DLM_RELEASES NUMBER
SQL> desc V$ROWCACHE_PARENT;
Name Null? Type
----------------------------------------- -------- ----------------------------
INDX NUMBER
HASH NUMBER
ADDRESS RAW(4)
CACHE# NUMBER
CACHE_NAME VARCHAR2(64)
EXISTENT VARCHAR2(1)
LOCK_MODE NUMBER
LOCK_REQUEST NUMBER
TXN RAW(4)
SADDR RAW(4)
INST_LOCK_REQUEST NUMBER
INST_LOCK_RELEASE NUMBER
INST_LOCK_TYPE VARCHAR2(2)
INST_LOCK_ID1 RAW(4)
INST_LOCK_ID2 RAW(4)
KEY RAW(100)
SQL> desc V$ROWCACHE_SUBORDINATE;
Name Null? Type
----------------------------------------- -------- ----------------------------
INDX NUMBER
HASH NUMBER
ADDRESS RAW(4)
CACHE# NUMBER
SUBCACHE# NUMBER
SUBCACHE_NAME VARCHAR2(64)
EXISTENT VARCHAR2(1)
PARENT RAW(4)
KEY RAW(100)
No comments:
Post a Comment