|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$PGASTAT: Synonym for GV_$PGASTAT
iSelfSchooling-SQL> desc GV$PGASTAT;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(64)
VALUE
NUMBER
UNIT
VARCHAR2(12)
GV$PGA_TARGET_ADVICE: Synonym for GV_$PGA_TARGET_ADVICE
iSelfSchooling-SQL> desc GV$PGA_TARGET_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PGA_TARGET_ADVICE_HISTOGRAM:
Synonym
for GV_$PGATARGET_ADVICE_HISTOGRAM
iSelfSchooling-SQL> desc GV$PGA_TARGET_ADVICE_HISTOGRAM;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PQ_SESSTAT: Synonym for GV_$PQ_SESSTAT
iSelfSchooling-SQL> desc GV$PQ_SESSTAT;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
STATISTIC
VARCHAR2(30)
LAST_QUERY
NUMBER
SESSION_TOTAL
NUMBER
GV$PQ_SLAVE: Synonym for GV_$PQ_SLAVE
iSelfSchooling-SQL> desc GV$PQ_SLAVE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SLAVE_NAME
VARCHAR2(4)
STATUS
VARCHAR2(4)
SESSIONS
NUMBER
IDLE_TIME_CUR
NUMBER
BUSY_TIME_CUR
NUMBER
CPU_SECS_CUR
NUMBER
MSGS_SENT_CUR NUMBER
MSGS_RCVD_CUR
NUMBER
IDLE_TIME_TOTAL
NUMBER
BUSY_TIME_TOTAL
NUMBER
CPU_SECS_TOTAL
NUMBER
MSGS_SENT_TOTAL
NUMBER
MSGS_RCVD_TOTAL
NUMBER
GV$PQ_SYSSTAT: Synonym for GV_$PQ_SYSSTAT
iSelfSchooling-SQL> desc GV$PQ_SYSSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATISTIC
VARCHAR2(30)
VALUE
NUMBER
GV$PQ_TQSTAT: Synonym for GV_$PQ_TQSTAT
iSelfSchooling-SQL> desc GV$PQ_TQSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
DFO_NUMBER
NUMBER
TQ_ID
NUMBER
SERVER_TYPE
VARCHAR2(10)
NUM_ROWS
NUMBER
BYTES
NUMBER
OPEN_TIME
NUMBER
AVG_LATENCY
NUMBER
WAITS
NUMBER
TIMEOUTS
NUMBER
PROCESS
VARCHAR2(10)
INSTANCE
NUMBER
GV$PROCESS: Synonym for GV_$PROCESS
iSelfSchooling-SQL> desc GV$PROCESS;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
PID
NUMBER
SPID
VARCHAR2(12)
USERNAME
VARCHAR2(15)
SERIAL#
NUMBER
TERMINAL
VARCHAR2(30)
PROGRAM
VARCHAR2(48)
TRACEID
VARCHAR2(255)
BACKGROUND
VARCHAR2(1)
LATCHWAIT
VARCHAR2(16)
LATCHSPIN
VARCHAR2(16)
PGA_USED_MEM
NUMBER
PGA_ALLOC_MEM
NUMBER
PGA_FREEABLE_MEM
NUMBER
PGA_MAX_MEM
NUMBER
GV$PROCESS_MEMORY: Synonym for GV_$PROCESS_MEMORY
iSelfSchooling-SQL> desc GV$PROCESS_MEMORY;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
PID
NUMBER
SERIAL#
NUMBER
CATEGORY
VARCHAR2(15)
ALLOCATED
NUMBER
USED
NUMBER
MAX_ALLOCATED
NUMBER
GV$PROCESS_MEMORY_DETAIL: Synonym for GV_$PROCESS_MEMORY_DETAIL
iSelfSchooling-SQL> desc GV$PROCESS_MEMORY_DETAIL;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PID
NUMBER
SERIAL#
NUMBER
CATEGORY
VARCHAR2(15)
NAME
VARCHAR2(26)
HEAP_NAME
VARCHAR2(15)
BYTES
NUMBER
ALLOCATION_COUNT
NUMBER
HEAP_DESCRIPTOR
RAW(8)
PARENT_HEAP_DESCRIPTOR
RAW(8)
GV$PROCESS_MEMORY_DETAIL_PROG:
Synonym
for GV_$PROCESS_MEMORY_DETAIL_PROG
iSelfSchooling-SQL> desc GV$PROCESS_MEMORY_DETAIL_PROG;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
PID
NUMBER
SERIAL#
NUMBER
STATUS
VARCHAR2(10)
GV$PROPAGATION_RECEIVER: Synonym for GV_$PROPAGATION_RECEIVER
iSelfSchooling-SQL> desc GV$PROPAGATION_RECEIVER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PROPAGATION_SENDER: Synonym for GV_$PROPAGATION_SENDER
iSelfSchooling-SQL> desc GV$PROPAGATION_SENDER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PROXY_ARCHIVEDLOG: Synonym for GV_$PROXY_ARCHIVEDLOG
iSelfSchooling-SQL> desc GV$PROXY_ARCHIVEDLOG;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECID
NUMBER
STAMP
NUMBER
DEVICE_TYPE
VARCHAR2(17)
HANDLE
VARCHAR2(513)
COMMENTS
VARCHAR2(81)
MEDIA & |