|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$SYSMETRIC_HISTORY: Synonym for GV_$SYSMETRIC_HISTORY
iSelfSchooling-SQL> desc GV$SYSMETRIC_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$SYSMETRIC_SUMMARY: Synonym for GV_$SYSMETRIC_SUMMARY
iSelfSchooling-SQL> desc GV$SYSMETRIC_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$SYSSTAT: Synonym for GV_$SYSSTAT
iSelfSchooling-SQL> desc GV$SYSSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATISTIC#
NUMBER
NAME
VARCHAR2(64)
CLASS
NUMBER
VALUE
NUMBER
STAT_ID
NUMBER
GV$SYSTEM_CURSOR_CACHE: Synonym for GV_$SYSTEM_CURSOR_CACHE
iSelfSchooling-SQL> desc GV$SYSTEM_CURSOR_CACHE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
OPENS
NUMBER
HITS
NUMBER
HIT_RATIO
NUMBER
GV$SYSTEM_EVENT: Synonym for GV_$SYSTEM_EVENT
iSelfSchooling-SQL> desc GV$SYSTEM_EVENT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
EVENT
VARCHAR2(64)
TOTAL_WAITS
NUMBER
TOTAL_TIMEOUTS
NUMBER
TIME_WAITED
NUMBER
AVERAGE_WAIT
NUMBER
TIME_WAITED_MICRO
NUMBER
EVENT_ID
NUMBER
WAIT_CLASS_ID
NUMBER
WAIT_CLASS#
NUMBER
WAIT_CLASS
VARCHAR2(64)
GV$SYSTEM_PARAMETER: Synonym for GV_$SYSTEM_PARAMETER
iSelfSchooling-SQL> desc GV$SYSTEM_PARAMETER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NUM
NUMBER
NAME
VARCHAR2(80)
TYPE
NUMBER
VALUE
VARCHAR2(512)
DISPLAY_VALUE
VARCHAR2(512)
ISDEFAULT
VARCHAR2(9)
ISSES_MODIFIABLE
VARCHAR2(5)
ISSYS_MODIFIABLE
VARCHAR2(9)
ISINSTANCE_MODIFIABLE
VARCHAR2(5)
ISMODIFIED
VARCHAR2(8)
ISADJUSTED
VARCHAR2(5)
ISDEPRECATED
VARCHAR2(5)
DESCRIPTION
VARCHAR2(255)
UPDATE_COMMENT
VARCHAR2(255)
HASH
NUMBER
GV$SYSTEM_PARAMETER2: Synonym for GV_$SYSTEM_PARAMETER2
iSelfSchooling-SQL> desc GV$SYSTEM_PARAMETER2;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NUM
NUMBER
NAME
VARCHAR2(80)
TYPE
NUMBER
VALUE
VARCHAR2(512)
DISPLAY_VALUE
VARCHAR2(512)
ISDEFAULT
VARCHAR2(6)
ISSES_MODIFIABLE
VARCHAR2(5)
ISSYS_MODIFIABLE
VARCHAR2(9)
ISINSTANCE_MODIFIABLE
VARCHAR2(5)
ISMODIFIED
VARCHAR2(8)
ISADJUSTED
VARCHAR2(5)
ISDEPRECATED
VARCHAR2(5)
DESCRIPTION
VARCHAR2(255)
ORDINAL
NUMBER
UPDATE_COMMENT
VARCHAR2(255)
GV$SYSTEM_WAIT_CLASS: Synonym for GV_$SYSTEM_WAIT_CLASS
iSelfSchooling-SQL> desc GV$SYSTEM_WAIT_CLASS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID NUMBER
WAIT_CLASS_ID
NUMBER
WAIT_CLASS#
NUMBER
WAIT_CLASS
VARCHAR2(64)
TOTAL_WAITS
NUMBER
TIME_WAITED
NUMBER
GV$SYS_OPTIMIZER_ENV: Synonym for GV_$SYS_OPTIMIZER_ENV
iSelfSchooling-SQL> desc GV$SYS_OPTIMIZER_ENV;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ID
NUMBER
NAME
VARCHAR2(40)
ISDEFAULT
VARCHAR2(3)
VALUE
VARCHAR2(25)
DEFAULT_VALUE
VARCHAR2(25)
GV$SYS_TIME_MODEL: Synonym for GV_$SYS_TIME_MODEL
iSelfSchooling-SQL> desc GV$SYS_TIME_MODEL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
GV$TABLESPACE: Synonym for GV_$TABLESPACE
iSelfSchooling-SQL> desc GV$TABLESPACE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
TS#
NUMBER
NAME
VARCHAR2(30)
INCLUDED_IN_DATABASE_BACKUP
VARCHAR2(3)
BIGFILE
VARCHAR2(3)
FLASHBACK_ON
VARCHAR2(3)
ENCRYPT_IN_BACKUP
VARCHAR2(3)
GV$TEMPFILE: Synonym for GV_$TEMPFILE
iSelfSchooling-SQL> desc GV$TEMPFILE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
TS#
NUMBER
RFILE#
NUMBER
STATUS
VARCHAR2(7)
ENABLED
VARCHAR2(10)
BYTES
NUMBER
BLOCKS
NUMBER
CREATE_BYTES
NUMBER
BLOCK_SIZE
NUMBER
NAME
VARCHAR2(513)
GV$TEMPORARY_LOBS: Synonym for GV_$TEMPORARY_LOBS
iSelfSchooling-SQL> desc GV$TEMPORARY_LOBS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
CACHE_LOBS
NUMBER
NOCACHE_LOBS
NUMBER
ABSTRACT_LOBS
NUMBER
GV$TEMPSEG_USAGE: Synonym for GV_$SORT_USAGE
iSelfSchooling-SQL> desc GV$TEMPSEG_USAGE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
USERNAME
VARCHAR2(30)
USER
VARCHAR2(30)
SESSION_ADDR
RAW(8)
SESSION_NUM
NUMBER
SQLADDR
RAW(8)
SQLHASH
NUMBER
SQL_ID
VARCHAR2(13)
TABLESPACE
VARCHAR2(31)
CONTENTS
VARCHAR2(9)
SEGTYPE
VARCHAR2(9)
SEGFILE#
NUMBER
|