ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$SEGMENT_STATISTICS: Synonym for V_$SEGMENT_STATISTICS
iSelfSchooling-SQL> desc V$SEGMENT_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
SUBOBJECT_NAME
VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
TS#
NUMBER
OBJ#
NUMBER
DATAOBJ#
NUMBER
OBJECT_TYPE
VARCHAR2(18)
STATISTIC_NAME
VARCHAR2(64)
STATISTIC#
NUMBER
VALUE
NUMBER
V$SEGSTAT: Synonym for V_$SEGSTAT
iSelfSchooling-SQL> desc V$SEGSTAT;
Name
Null? Type
----------------------------- -------- --------------------
TS#
NUMBER
OBJ#
NUMBER
DATAOBJ#
NUMBER
STATISTIC_NAME
VARCHAR2(64)
STATISTIC#
NUMBER
VALUE
NUMBER
V$SEGSTAT_NAME: Synonym for V_$SEGSTAT_NAME
iSelfSchooling-SQL> desc V$SEGSTAT_NAME;
Name
Null? Type
----------------------------- -------- --------------------
STATISTIC#
NUMBER
NAME
VARCHAR2(64)
SAMPLED
VARCHAR2(3)
V$SERVICEMETRIC: Synonym for V_$SERVICEMETRIC
iSelfSchooling-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
V$SERVICEMETRIC_HISTORY: Synonym for V_$SERVICEMETRIC_HISTORY
iSelfSchooling-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
V$SERVICES: Synonym for V_$SERVICES
iSelfSchooling-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)
V$SERVICE_EVENT: Synonym for V_$SERVICE_EVENT
iSelfSchooling-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
V$SERVICE_STATS: Synonym for V_$SERVICE_STATS
iSelfSchooling-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
V$SERVICE_WAIT_CLASS: Synonym for V_$SERVICE_WAIT_CLASS
iSelfSchooling-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
V$SERV_MOD_ACT_STATS: Synonym for V_$SERV_MOD_ACT_STATS
iSelfSchooling-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
V$SESSION: Synonym for V_$SESSION
iSelfSchooling-SQL> desc V$SESSION;
Name
Null? Type
----------------------------- -------- --------------------
SADDR
RAW(8)
SID
NUMBER
SERIAL#
NUMBER
AUDSID
NUMBER
PADDR
RAW(8)
USER#
NUMBER
USERNAME
VARCHAR2(30)
COMMAND
NUMBER
OWNERID
NUMBER
TADDR
VARCHAR2(16)
LOCKWAIT
VARCHAR2(16)
STATUS
VARCHAR2(8)
SERVER
VARCHAR2(9)
SCHEMA#
NUMBER
SCHEMANAME
VARCHAR2(30)
OSUSER
VARCHAR2(30)
PROCESS
VARCHAR2(12)
MACHINE
VARCHAR2(64)
TERMINAL
VARCHAR2(30)
PROGRAM
VARCHAR2(48)
TYPE
VARCHAR2(10)
SQL_ADDRESS
RAW(8)
SQL_HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
SQL_CHILD_NUMBER
NUMBER
PREV_SQL_ADDR
RAW(8)
PREV_HASH_VALUE
NUMBER
PREV_SQL_ID
VARCHAR2(13)
PREV_CHILD_NUMBER
NUMBER
MODULE
VARCHAR2(48)
MODULE_HASH
NUMBER
ACTION
VARCHAR2(32)
ACTION_HASH
NUMBER
CLIENT_INFO
VARCHAR2(64)
FIXED_TABLE_SEQUENCE
NUMBER
ROW_WAIT_OBJ#
NUMBER
ROW_WAIT_FILE#
NUMBER
ROW_WAIT_BLOCK#
NUMBER
ROW_WAIT_ROW#
NUMBER
LOGON_TIME
DATE
LAST_CALL_ET
NUMBER
PDML_ENABLED
VARCHAR2(3)
FAILOVER_TYPE
VARCHAR2(13)
FAILOVER_METHOD
VARCHAR2(10)
FAILED_OVER
VARCHAR2(3)
RESOURCE_CONSUMER_GROUP
VARCHAR2(32)
PDML_STATUS
VARCHAR2(8)
PDDL_STATUS
VARCHAR2(8)
PQ_STATUS
VARCHAR2(8)
CURRENT_QUEUE_DURATION
NUMBER
CLIENT_IDENTIFIER
VARCHAR2(64)
BLOCKING_SESSION_STATUS
VARCHAR2(11)
BLOCKING_INSTANCE
NUMBER
BLOCKING_SESSION
NUMBER
SEQ#
NUMBER
EVENT#
NUMBER
EVENT
VARCHAR2(64)
P1TEXT
VARCHAR2(64)
P1
NUMBER
P1RAW
RAW(8)
P2TEXT
VARCHAR2(64)
P2
NUMBER
P2RAW
RAW(8)
P3TEXT
VARCHAR2(64)
P3
NUMBER
P3RAW
RAW(8)
WAIT_CLASS_ID
NUMBER
WAIT_CLASS#
NUMBER
WAIT_CLASS
VARCHAR2(64)
WAIT_TIME
NUMBER
SECONDS_IN_WAIT
NUMBER
STATE
VARCHAR2(19)
SERVICE_NAME
VARCHAR2(64)
SQL_TRACE
VARCHAR2(8)
SQL_TRACE_WAITS
VARCHAR2(5)
SQL_TRACE_BINDS
VARCHAR2(5)
V$SESSION_CONNECT_INFO: Synonym for V_$SESSION_CONNECT_INFO
iSelfSchooling-SQL> desc V$SESSION_CONNECT_INFO;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
AUTHENTICATION_TYPE
VARCHAR2(26)
OSUSER
VARCHAR2(30)
NETWORK_SERVICE_BANNER
VARCHAR2(4000)
V$SESSION_CURSOR_CACHE: Synonym for V_$SESSION_CURSOR_CACHE
iSelfSchooling-SQL> desc V$SESSION_CURSOR_CACHE;
Name
Null? Type
----------------------------- -------- --------------------
MAXIMUM
NUMBER
COUNT
NUMBER
OPENED_ONCE
NUMBER
OPEN
NUMBER
OPENS
NUMBER
HITS
NUMBER
HIT_RATIO
NUMBER
V$SESSION_EVENT: Synonym for V_$SESSION_EVENT
iSelfSchooling-SQL> desc V$SESSION_EVENT;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
EVENT
VARCHAR2(64)
TOTAL_WAITS
NUMBER
TOTAL_TIMEOUTS
NUMBER
TIME_WAITED
NUMBER
AVERAGE_WAIT
NUMBER
MAX_WAIT
NUMBER
TIME_WAITED_MICRO
NUMBER
EVENT_ID
NUMBER
WAIT_CLASS_ID
NUMBER
WAIT_CLASS#
NUMBER
WAIT_CLASS
VARCHAR2(64)
V$SESSION_LONGOPS: Synonym for V_$SESSION_LONGOPS
iSelfSchooling-SQL> desc V$SESSION_LONGOPS;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SERIAL#
NUMBER
OPNAME
VARCHAR2(64)
TARGET
VARCHAR2(64)
TARGET_DESC
VARCHAR2(32)
SOFAR
NUMBER
TOTALWORK
NUMBER
UNITS
VARCHAR2(32)
START_TIME
DATE
LAST_UPDATE_TIME
DATE
TIMESTAMP
DATE
TIME_REMAINING
NUMBER
ELAPSED_SECONDS
NUMBER
CONTEXT
NUMBER
MESSAGE
VARCHAR2(512)
USERNAME
VARCHAR2(30)
SQL_ADDRESS
RAW(8)
SQL_HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
QCSID
NUMBER
V$SESSION_OBJECT_CACHE: Synonym for V_$SESSION_OBJECT_CACHE
iSelfSchooling-SQL> desc V$SESSION_OBJECT_CACHE;
Name
Null? Type
----------------------------- -------- --------------------
PINS
NUMBER
HITS
NUMBER
TRUE_HITS
NUMBER
HIT_RATIO
NUMBER
TRUE_HIT_RATIO
NUMBER
OBJECT_REFRESHES
NUMBER
CACHE_REFRESHES
NUMBER
OBJECT_FLUSHES
NUMBER
CACHE_FLUSHES
NUMBER
CACHE_SHRINKS
NUMBER
CACHED_OBJECTS
NUMBER
PINNED_OBJECTS
NUMBER
CACHE_SIZE
NUMBER
OPTIMAL_SIZE
NUMBER
MAXIMUM_SIZE
NUMBER
V$SESSION_WAIT: Synonym for V_$SESSION_WAIT
iSelfSchooling-SQL> desc V$SESSION_WAIT;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SEQ#
NUMBER
EVENT
VARCHAR2(64)
P1TEXT
VARCHAR2(64)
P1
NUMBER
P1RAW
RAW(8)
P2TEXT
VARCHAR2(64)
P2
NUMBER
P2RAW
RAW(8)
P3TEXT
VARCHAR2(64)
P3
NUMBER
P3RAW
RAW(8)
WAIT_CLASS_ID
NUMBER
WAIT_CLASS#
NUMBER
WAIT_CLASS
VARCHAR2(64)
WAIT_TIME
NUMBER
SECONDS_IN_WAIT
NUMBER
STATE
VARCHAR2(19)
V$SESSION_WAIT_CLASS: Synonym for V_$SESSION_WAIT_CLASS
iSelfSchooling-SQL> desc V$SESSION_WAIT_CLASS;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SERIAL#
NUMBER
WAIT_CLASS_ID
NUMBER
WAIT_CLASS#
NUMBER
WAIT_CLASS
VARCHAR2(64)
TOTAL_WAITS
NUMBER
TIME_WAITED
NUMBER
V$SESSION_WAIT_HISTORY: Synonym for V_$SESSION_WAIT_HISTORY
iSelfSchooling-SQL> desc V$SESSION_WAIT_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SEQ#
NUMBER
EVENT#
NUMBER
EVENT
VARCHAR2(64)
P1TEXT
VARCHAR2(64)
P1
NUMBER
P2TEXT
VARCHAR2(64)
P2
NUMBER
P3TEXT
VARCHAR2(64)
P3
NUMBER
WAIT_TIME
NUMBER
WAIT_COUNT
NUMBER
V$SESSMETRIC: Synonym for V_$SESSMETRIC
iSelfSchooling-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
V$SESSTAT: Synonym for V_$SESSTAT
iSelfSchooling-SQL> desc V$SESSTAT;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
STATISTIC#
NUMBER
VALUE
NUMBER
V$SESS_IO: Synonym for V_$SESS_IO
iSelfSchooling-SQL> desc V$SESS_IO;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
BLOCK_GETS
NUMBER
CONSISTENT_GETS
NUMBER
PHYSICAL_READS
NUMBER
BLOCK_CHANGES
NUMBER
CONSISTENT_CHANGES
NUMBER
V$SESS_TIME_MODEL: Synonym for V_$SESS_TIME_MODEL
iSelfSchooling-SQL> desc V$SESS_TIME_MODEL;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
V$SES_OPTIMIZER_ENV: Synonym for V_$SES_OPTIMIZER_ENV
iSelfSchooling-SQL> desc V$SES_OPTIMIZER_ENV;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
ID
NUMBER
NAME
VARCHAR2(40)
ISDEFAULT
VARCHAR2(3)
VALUE
VARCHAR2(25)
V$SGA: Synonym for V_$SGA
iSelfSchooling-SQL> desc V$SGA;
Name
Null?
Type
----------------------------- -------- --------------------
NAME
VARCHAR2(20)
VALUE
NUMBER
V$SGAINFO: Synonym for V_$SGAINFO
iSelfSchooling-SQL> desc V$SGAINFO;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(32)
BYTES
NUMBER
RESIZEABLE
VARCHAR2(3)
V$SGASTAT: Synonym for V_$SGASTAT
iSelfSchooling-SQL> desc V$SGASTAT;
Name
Null? Type
----------------------------- -------- --------------------
POOL
VARCHAR2(12)
NAME
VARCHAR2(26)
BYTES
NUMBER
V$SGA_CURRENT_RESIZE_OPS: Synonym for V_$SGA_CURRENT_RESIZE_OPS
iSelfSchooling-SQL> desc V$SGA_CURRENT_RESIZE_OPS;
Name
Null? Type
----------------------------- -------- --------------------
COMPONENT
VARCHAR2(64)
OPER_TYPE
VARCHAR2(13)
OPER_MODE
VARCHAR2(9)
PARAMETER
VARCHAR2(80)
INITIAL_SIZE
NUMBER
TARGET_SIZE
NUMBER
CURRENT_SIZE
NUMBER
START_TIME
DATE
LAST_UPDATE_TIME
DATE
V$SGA_DYNAMIC_COMPONENTS: Synonym for V_$SGA_DYNAMIC_COMPONENTS
iSelfSchooling-SQL> desc V$SGA_DYNAMIC_COMPONENTS;
Name
Null? Type
----------------------------- -------- --------------------
COMPONENT
VARCHAR2(64)
CURRENT_SIZE
NUMBER
MIN_SIZE
NUMBER
MAX_SIZE
NUMBER
USER_SPECIFIED_SIZE
NUMBER
OPER_COUNT
NUMBER
LAST_OPER_TYPE
VARCHAR2(13)
LAST_OPER_MODE
VARCHAR2(9)
LAST_OPER_TIME
DATE
GRANULE_SIZE
NUMBER
V$SGA_DYNAMIC_FREE_MEMORY: Synonym for V_$SGA_DYNAMIC_FREE_MEMORY
iSelfSchooling-SQL> desc V$SGA_DYNAMIC_FREE_MEMORY;
Name
Null? Type
----------------------------- -------- --------------------
CURRENT_SIZE
NUMBER
V$SGA_RESIZE_OPS: Synonym for V_$SGA_RESIZE_OPS
iSelfSchooling-SQL> desc V$SGA_RESIZE_OPS;
Name
Null? Type
----------------------------- -------- --------------------
COMPONENT
VARCHAR2(64)
OPER_TYPE
VARCHAR2(13)
OPER_MODE
VARCHAR2(9)
PARAMETER
VARCHAR2(80)
INITIAL_SIZE
NUMBER
TARGET_SIZE
NUMBER
FINAL_SIZE
NUMBER
STATUS
VARCHAR2(9)
START_TIME
DATE
END_TIME
DATE
V$SGA_TARGET_ADVICE: Synonym for V_$SGA_TARGET_ADVICE
iSelfSchooling-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
V$SHARED_POOL_ADVICE: Synonym for V_$SHARED_POOL_ADVICE
iSelfSchooling-SQL> desc V$SHARED_POOL_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
SHARED_POOL_SIZE_FOR_ESTIMATE NUMBER
SHARED_POOL_SIZE_FACTOR
NUMBER
ESTD_LC_SIZE
NUMBER
ESTD_LC_MEMORY_OBJECTS
NUMBER
ESTD_LC_TIME_SAVED
NUMBER
ESTD_LC_TIME_SAVED_FACTOR NUMBER
ESTD_LC_LOAD_TIME
NUMBER
ESTD_LC_LOAD_TIME_FACTOR
NUMBER
ESTD_LC_MEMORY_OBJECT_HITS NUMBER
V$SHARED_POOL_RESERVED: Synonym for V_$SHARED_POOL_RESERVED
iSelfSchooling-SQL> desc V$SHARED_POOL_RESERVED;
Name
Null? Type
----------------------------- -------- --------------------
FREE_SPACE
NUMBER
AVG_FREE_SIZE
NUMBER
FREE_COUNT
NUMBER
MAX_FREE_SIZE
NUMBER
USED_SPACE
NUMBER
AVG_USED_SIZE
NUMBER
USED_COUNT
NUMBER
MAX_USED_SIZE
NUMBER
REQUESTS
NUMBER
REQUEST_MISSES
NUMBER
LAST_MISS_SIZE
NUMBER
MAX_MISS_SIZE
NUMBER
REQUEST_FAILURES
NUMBER
LAST_FAILURE_SIZE
NUMBER
ABORTED_REQUEST_THRESHOLD
NUMBER
ABORTED_REQUESTS
NUMBER
LAST_ABORTED_SIZE
NUMBER
V$SHARED_SERVER: Synonym for V_$SHARED_SERVER
iSelfSchooling-SQL> desc V$SHARED_SERVER;
Name
Null?
Type
----------------------------- -------- --------------------
NAME
VARCHAR2(4)
PADDR
RAW(8)
STATUS
VARCHAR2(16)
MESSAGES
NUMBER
BYTES
NUMBER
BREAKS
NUMBER
CIRCUIT
RAW(8)
IDLE
NUMBER
BUSY
NUMBER
REQUESTS
NUMBER
V$SHARED_SERVER_MONITOR: Synonym for V_$SHARED_SERVER_MONITOR
iSelfSchooling-SQL> desc V$SHARED_SERVER_MONITOR;
Name
Null? Type
----------------------------- -------- --------------------
MAXIMUM_CONNECTIONS
NUMBER
MAXIMUM_SESSIONS
NUMBER
SERVERS_STARTED
NUMBER
SERVERS_TERMINATED
NUMBER
SERVERS_HIGHWATER
NUMBER
V$SORT_SEGMENT: Synonym for V_$SORT_SEGMENT
iSelfSchooling-SQL> desc V$SORT_SEGMENT;
Name
Null? Type
----------------------------- -------- --------------------
TABLESPACE_NAME
VARCHAR2(31)
SEGMENT_FILE
NUMBER
SEGMENT_BLOCK
NUMBER
EXTENT_SIZE
NUMBER
CURRENT_USERS
NUMBER
TOTAL_EXTENTS
NUMBER
TOTAL_BLOCKS
NUMBER
USED_EXTENTS
NUMBER
USED_BLOCKS
NUMBER
FREE_EXTENTS
NUMBER
FREE_BLOCKS
NUMBER
ADDED_EXTENTS
NUMBER
EXTENT_HITS
NUMBER
FREED_EXTENTS
NUMBER
FREE_REQUESTS
NUMBER
MAX_SIZE
NUMBER
MAX_BLOCKS
NUMBER
MAX_USED_SIZE
NUMBER
MAX_USED_BLOCKS
NUMBER
MAX_SORT_SIZE
NUMBER
MAX_SORT_BLOCKS
NUMBER
RELATIVE_FNO
NUMBER
|