ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$ACCESS: Synonym for GV_$ACCESS
iSelfSchooling-SQL> desc GV$ACCESS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
OWNER
VARCHAR2(64)
OBJECT
VARCHAR2(1000)
TYPE
VARCHAR2(24)
GV$ACTIVE_INSTANCES: Synonym for GV_$ACTIVE_INSTANCES
iSelfSchooling-SQL> desc GV$ACTIVE_INSTANCES;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
INST_NUMBER
NUMBER
INST_NAME
VARCHAR2(60)
GV$ACTIVE_SERVICES: Synonym for GV_$ACTIVE_SERVICES
iSelfSchooling-SQL> desc GV$ACTIVE_SERVICES;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$ACTIVE_SESSION_HISTORY: Synonym for GV_$ACTIVE_SESSION_HISTORY
iSelfSchooling-SQL> desc GV$ACTIVE_SESSION_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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(48)
MODULE
VARCHAR2(48)
ACTION
VARCHAR2(32)
CLIENT_ID
VARCHAR2(64)
GV$ACTIVE_SESS_POOL_MTH: Synonym for GV_$ACTIVE_SESS_POOL_MTH
iSelfSchooling-SQL> desc GV$ACTIVE_SESS_POOL_MTH;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(40)
GV$ADVISOR_PROGRESS: Synonym for GV_$ADVISOR_PROGRESS
iSelfSchooling-SQL> desc GV$ADVISOR_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
SERIAL#
NUMBER
USERNAME
VARCHAR2(30)
OPNAME
VARCHAR2(64)
ADVISOR_NAME
VARCHAR2(64)
TASK_ID
NUMBER
TARGET_DESC
VARCHAR2(32)
SOFAR
NUMBER
TOTALWORK
NUMBER
UNITS
VARCHAR2(32)
BENEFIT_SOFAR
NUMBER
BENEFIT_MAX
NUMBER
FINDINGS
NUMBER
RECOMMENDATIONS
NUMBER
TIME_REMAINING
NUMBER
START_TIME
DATE
LAST_UPDATE_TIME
DATE
ELAPSED_SECONDS
NUMBER
ADVISOR_METRIC1
NUMBER
METRIC1_DESC
VARCHAR2(64)
GV$ALERT_TYPES: Synonym for GV_$ALERT_TYPES
iSelfSchooling-SQL> desc GV$ALERT_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$AQ: Synonym for GV_$AQ
iSelfSchooling-SQL> desc GV$AQ;
Name
Null? Type
----------------------------- -------- --------------------
QID
NUMBER
WAITING
NUMBER
READY
NUMBER
EXPIRED
NUMBER
TOTAL_WAIT
NUMBER
AVERAGE_WAIT
NUMBER
GV$AQ1: Synonym for GV_$AQ1
iSelfSchooling-SQL> desc GV$AQ1;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
QID
NUMBER
WAITING
NUMBER
READY
NUMBER
EXPIRED
NUMBER
TOTAL_CONSUMERS
NUMBER
TOTAL_WAIT
NUMBER
AVERAGE_WAIT
NUMBER
GV$ARCHIVE: Synonym for GV_$ARCHIVE
iSelfSchooling-SQL> desc GV$ARCHIVE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
GROUP#
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
ISCURRENT
VARCHAR2(3)
CURRENT
VARCHAR2(3)
FIRST_CHANGE#
NUMBER
GV$ARCHIVED_LOG: Synonym for GV_$ARCHIVED_LOG
iSelfSchooling-SQL> desc GV$ARCHIVED_LOG;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECID
NUMBER
STAMP
NUMBER
NAME
VARCHAR2(513)
DEST_ID
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
RESETLOGS_ID
NUMBER
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
NEXT_CHANGE#
NUMBER
NEXT_TIME
DATE
BLOCKS
NUMBER
BLOCK_SIZE
NUMBER
CREATOR
VARCHAR2(7)
REGISTRAR
VARCHAR2(7)
STANDBY_DEST
VARCHAR2(3)
ARCHIVED
VARCHAR2(3)
APPLIED
VARCHAR2(3)
DELETED
VARCHAR2(3)
STATUS
VARCHAR2(1)
COMPLETION_TIME
DATE
DICTIONARY_BEGIN
VARCHAR2(3)
DICTIONARY_END
VARCHAR2(3)
END_OF_REDO
VARCHAR2(3)
BACKUP_COUNT
NUMBER
ARCHIVAL_THREAD#
NUMBER
ACTIVATION#
NUMBER
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
COMPRESSED
VARCHAR2(3)
FAL
VARCHAR2(3)
END_OF_REDO_TYPE
VARCHAR2(10)
GV$ARCHIVE_DEST: Synonym for GV_$ARCHIVE_DEST
iSelfSchooling-SQL> desc GV$ARCHIVE_DEST;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
DEST_ID
NUMBER
DEST_NAME
VARCHAR2(256)
STATUS
VARCHAR2(9)
BINDING
VARCHAR2(9)
NAME_SPACE
VARCHAR2(7)
TARGET
VARCHAR2(7)
ARCHIVER
VARCHAR2(10)
SCHEDULE
VARCHAR2(8)
DESTINATION
VARCHAR2(256)
LOG_SEQUENCE
NUMBER
REOPEN_SECS
NUMBER
DELAY_MINS
NUMBER
MAX_CONNECTIONS
NUMBER
NET_TIMEOUT
NUMBER
PROCESS
VARCHAR2(10)
REGISTER
VARCHAR2(3)
FAIL_DATE
DATE
FAIL_SEQUENCE
NUMBER
FAIL_BLOCK
NUMBER
FAILURE_COUNT
NUMBER
MAX_FAILURE
NUMBER
ERROR
VARCHAR2(256)
ALTERNATE
VARCHAR2(256)
DEPENDENCY
VARCHAR2(256)
REMOTE_TEMPLATE
VARCHAR2(256)
QUOTA_SIZE
NUMBER
QUOTA_USED
NUMBER
MOUNTID
NUMBER
TRANSMIT_MODE
VARCHAR2(12)
ASYNC_BLOCKS
NUMBER
AFFIRM
VARCHAR2(3)
TYPE
VARCHAR2(7)
VALID_NOW
VARCHAR2(16)
VALID_TYPE
VARCHAR2(15)
VALID_ROLE
VARCHAR2(12)
DB_UNIQUE_NAME
VARCHAR2(30)
VERIFY
VARCHAR2(3)
GV$ARCHIVE_DEST_STATUS: Synonym for GV_$ARCHIVE_DEST_STATUS
iSelfSchooling-SQL> desc GV$ARCHIVE_DEST_STATUS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
DEST_ID
NUMBER
DEST_NAME
VARCHAR2(256)
STATUS
VARCHAR2(9)
TYPE
VARCHAR2(14)
DATABASE_MODE
VARCHAR2(15)
RECOVERY_MODE
VARCHAR2(23)
PROTECTION_MODE
VARCHAR2(20)
DESTINATION
VARCHAR2(256)
STANDBY_LOGFILE_COUNT
NUMBER
STANDBY_LOGFILE_ACTIVE
NUMBER
ARCHIVED_THREAD#
NUMBER
ARCHIVED_SEQ#
NUMBER
APPLIED_THREAD#
NUMBER
APPLIED_SEQ#
NUMBER
ERROR
VARCHAR2(256)
SRL
VARCHAR2(3)
DB_UNIQUE_NAME
VARCHAR2(30)
SYNCHRONIZATION_STATUS
VARCHAR2(22)
SYNCHRONIZED
VARCHAR2(3)
GV$ARCHIVE_GAP: Synonym for GV_$ARCHIVE_GAP
iSelfSchooling-SQL> desc GV$ARCHIVE_GAP;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
THREAD#
NUMBER
LOW_SEQUENCE#
NUMBER
HIGH_SEQUENCE#
NUMBER
GV$ARCHIVE_PROCESSES: Synonym for GV_$ARCHIVE_PROCESSES
iSelfSchooling-SQL> desc GV$ARCHIVE_PROCESSES;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PROCESS
NUMBER
STATUS
VARCHAR2(10)
LOG_SEQUENCE
NUMBER
STATE
VARCHAR2(4)
GV$ASM_ALIAS: Synonym for GV_$ASM_ALIAS
iSelfSchooling-SQL> desc GV$ASM_ALIAS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$ASM_CLIENT: Synonym for GV_$ASM_CLIENT
iSelfSchooling-SQL> desc GV$ASM_CLIENT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
GROUP_NUMBER
NUMBER
INSTANCE_NAME
VARCHAR2(64)
DB_NAME
VARCHAR2(8)
STATUS
VARCHAR2(12)
SOFTWARE_VERSION
VARCHAR2(60)
COMPATIBLE_VERSION
VARCHAR2(60)
GV$ASM_DISK: Synonym for GV_$ASM_DISK
iSelfSchooling-SQL> desc GV$ASM_DISK;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$ASM_DISKGROUP: Synonym for GV_$ASM_DISKGROUP
iSelfSchooling-SQL> desc GV$ASM_DISKGROUP;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$ASM_DISKGROUP_STAT: Synonym for GV_$ASM_DISKGROUP_STAT
iSelfSchooling-SQL> desc GV$ASM_DISKGROUP_STAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$ASM_DISK_STAT: Synonym for GV_$ASM_DISK_STAT
iSelfSchooling-SQL> desc GV$ASM_DISK_STAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$ASM_FILE: Synonym for GV_$ASM_FILE
iSelfSchooling-SQL> desc GV$ASM_FILE;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$ASM_OPERATION: Synonym for GV_$ASM_OPERATION
iSelfSchooling-SQL> desc GV$ASM_OPERATION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
GROUP_NUMBER
NUMBER
OPERATION
VARCHAR2(5)
STATE
VARCHAR2(4)
POWER
NUMBER
ACTUAL
NUMBER
SOFAR
NUMBER
EST_WORK
NUMBER
EST_RATE
NUMBER
EST_MINUTES
NUMBER
GV$ASM_TEMPLATE: Synonym for GV_$ASM_TEMPLATE
iSelfSchooling-SQL> desc GV$ASM_TEMPLATE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
GROUP_NUMBER
NUMBER
ENTRY_NUMBER
NUMBER
REDUNDANCY
VARCHAR2(6)
STRIPE
VARCHAR2(6)
SYSTEM
VARCHAR2(1)
NAME
VARCHAR2(30)
GV$AW_AGGREGATE_OP: Synonym for GV_$AW_AGGREGATE_OP
iSelfSchooling-SQL> desc GV$AW_AGGREGATE_OP;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(14)
LONGNAME
VARCHAR2(30)
DEFAULT_WEIGHT
NUMBER
GV$AW_ALLOCATE_OP: Synonym for GV_$AW_ALLOCATE_OP
iSelfSchooling-SQL> desc GV$AW_ALLOCATE_OP;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(14)
LONGNAME
VARCHAR2(30)
GV$AW_CALC: Synonym for GV_$AW_CALC
iSelfSchooling-SQL> desc GV$AW_CALC;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$AW_LONGOPS: Synonym for GV_$AW_LONGOPS
iSelfSchooling-SQL> desc GV$AW_LONGOPS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SESSION_ID
NUMBER
CURSOR_NAME
VARCHAR2(64)
COMMAND
VARCHAR2(7)
STATUS
VARCHAR2(9)
ROWS_PROCESSED
NUMBER
START_TIME
TIMESTAMP(3)
GV$AW_OLAP: Synonym for GV_$AW_OLAP
iSelfSchooling-SQL> desc GV$AW_OLAP;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$AW_SESSION_INFO: Synonym for GV_$AW_SESSION_INFO
iSelfSchooling-SQL> desc GV$AW_SESSION_INFO;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
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
GV$BACKUP: Synonym for GV_$BACKUP
iSelfSchooling-SQL> desc GV$BACKUP;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
STATUS
VARCHAR2(18)
CHANGE#
NUMBER
TIME
DATE
|