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
SEGBLK#
NUMBER
EXTENTS
NUMBER
BLOCKS
NUMBER
SEGRFNO#
NUMBER
GV$TEMPSTAT: Synonym for GV_$TEMPSTAT
iSelfSchooling-SQL> desc GV$TEMPSTAT;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
PHYRDS
NUMBER
PHYWRTS
NUMBER
PHYBLKRD
NUMBER
PHYBLKWRT
NUMBER
SINGLEBLKRDS
NUMBER
READTIM
NUMBER
WRITETIM
NUMBER
SINGLEBLKRDTIM
NUMBER
AVGIOTIM
NUMBER
LSTIOTIM
NUMBER
MINIOTIM
NUMBER
MAXIORTM
NUMBER
MAXIOWTM
NUMBER
GV$TEMP_CACHE_TRANSFER: Synonym for GV_$TEMP_CACHE_TRANSFER
iSelfSchooling-SQL> desc GV$TEMP_CACHE_TRANSFER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$TEMP_EXTENT_MAP: Synonym for GV_$TEMP_EXTENT_MAP
iSelfSchooling-SQL> desc GV$TEMP_EXTENT_MAP;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
FILE_ID
NUMBER
BLOCK_ID
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
OWNER
NUMBER
RELATIVE_FNO
NUMBER
GV$TEMP_EXTENT_POOL: Synonym for GV_$TEMP_EXTENT_POOL
iSelfSchooling-SQL> desc GV$TEMP_EXTENT_POOL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
FILE_ID
NUMBER
EXTENTS_CACHED
NUMBER
EXTENTS_USED
NUMBER
BLOCKS_CACHED
NUMBER
BLOCKS_USED
NUMBER
BYTES_CACHED
NUMBER
BYTES_USED
NUMBER
RELATIVE_FNO
NUMBER
GV$TEMP_HISTOGRAM: Synonym for GV_$TEMP_HISTOGRAM
iSelfSchooling-SQL> desc GV$TEMP_HISTOGRAM;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
SINGLEBLKRDTIM_MILLI
NUMBER
SINGLEBLKRDS
NUMBER
GV$TEMP_PING: Synonym for GV_$TEMP_PING
iSelfSchooling-SQL> desc GV$TEMP_PING;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$TEMP_SPACE_HEADER: Synonym for GV_$TEMP_SPACE_HEADER
iSelfSchooling-SQL> desc GV$TEMP_SPACE_HEADER;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
FILE_ID
NUMBER
BYTES_USED
NUMBER
BLOCKS_USED
NUMBER
BYTES_FREE
NUMBER
BLOCKS_FREE
NUMBER
RELATIVE_FNO
NUMBER
GV$THREAD: Synonym for GV_$THREAD
iSelfSchooling-SQL> desc GV$THREAD;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
THREAD#
NUMBER
STATUS
VARCHAR2(6)
ENABLED
VARCHAR2(8)
GROUPS
NUMBER
INSTANCE
VARCHAR2(80)
OPEN_TIME
DATE
CURRENT_GROUP#
NUMBER
SEQUENCE#
NUMBER
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
ENABLE_CHANGE#
NUMBER
ENABLE_TIME
DATE
DISABLE_CHANGE#
NUMBER
DISABLE_TIME
DATE
LAST_REDO_SEQUENCE#
NUMBER
LAST_REDO_BLOCK
NUMBER
LAST_REDO_CHANGE#
NUMBER
LAST_REDO_TIME
DATE
GV$THRESHOLD_TYPES: Synonym for GV_$THRESHOLD_TYPES
iSelfSchooling-SQL> desc GV$THRESHOLD_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
METRICS_ID
NUMBER
METRICS_GROUP_ID
NUMBER
OPERATOR_MASK
NUMBER
OBJECT_TYPE
VARCHAR2(64)
ALERT_REASON_ID
NUMBER
METRIC_VALUE_TYPE
NUMBER
GV$TIMER: Synonym for GV_$TIMER
iSelfSchooling-SQL> desc GV$TIMER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
HSECS
NUMBER
GV$TIMEZONE_FILE: Synonym for GV_$TIMEZONE_FILE
iSelfSchooling-SQL> desc GV$TIMEZONE_FILE;
Name
Null? Type
----------------------------- -------- --------------------
FILENAME
VARCHAR2(12)
VERSION
NUMBER
GV$TIMEZONE_NAMES: Synonym for GV_$TIMEZONE_NAMES
iSelfSchooling-SQL> desc GV$TIMEZONE_NAMES;
Name
Null? Type
-----------------------------
-------- --------------------
TZNAME
VARCHAR2(64)
TZABBREV
VARCHAR2(64)
GV$TRANSACTION: Synonym for GV_$TRANSACTION
iSelfSchooling-SQL> desc GV$TRANSACTION;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
XIDUSN
NUMBER
XIDSLOT
NUMBER
XIDSQN
NUMBER
UBAFIL
NUMBER
UBABLK
NUMBER
UBASQN
NUMBER
UBAREC
NUMBER
STATUS
VARCHAR2(16)
START_TIME
VARCHAR2(20)
START_SCNB
NUMBER
START_SCNW
NUMBER
START_UEXT
NUMBER
START_UBAFIL
NUMBER
START_UBABLK
NUMBER
START_UBASQN
NUMBER
START_UBAREC
NUMBER
SES_ADDR
RAW(8)
FLAG
NUMBER
SPACE
VARCHAR2(3)
RECURSIVE
VARCHAR2(3)
NOUNDO
VARCHAR2(3)
PTX
VARCHAR2(3)
NAME
VARCHAR2(256)
PRV_XIDUSN
NUMBER
PRV_XIDSLT
NUMBER
PRV_XIDSQN
NUMBER
PTX_XIDUSN
NUMBER
PTX_XIDSLT
NUMBER
PTX_XIDSQN
NUMBER
DSCN-B
NUMBER
DSCN-W
NUMBER
USED_UBLK
NUMBER
USED_UREC
NUMBER
LOG_IO
NUMBER
PHY_IO
NUMBER
CR_GET
NUMBER
CR_CHANGE
NUMBER
START_DATE
DATE
DSCN_BASE
NUMBER
DSCN_WRAP
NUMBER
START_SCN
NUMBER
DEPENDENT_SCN
NUMBER
XID
RAW(8)
PRV_XID
RAW(8)
PTX_XID
RAW(8)
GV$TRANSACTION_ENQUEUE: Synonym for GV_$TRANSACTION_ENQUEUE
iSelfSchooling-SQL> desc GV$TRANSACTION_ENQUEUE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
KADDR
RAW(8)
SID
NUMBER
TYPE
VARCHAR2(2)
ID1
NUMBER
ID2
NUMBER
LMODE
NUMBER
REQUEST
NUMBER
CTIME
NUMBER
BLOCK
NUMBER
GV$TSM_SESSIONS: Synonym for GV_$TSM_SESSIONS
iSelfSchooling-SQL> desc GV$TSM_SESSIONS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$TYPE_SIZE: Synonym for GV_$TYPE_SIZE
iSelfSchooling-SQL> desc GV$TYPE_SIZE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(8)
TYPE
VARCHAR2(8)
DESCRIPTION
VARCHAR2(32)
TYPE_SIZE
NUMBER
GV$UNDOSTAT: Synonym for GV_$UNDOSTAT
iSelfSchooling-SQL> desc GV$UNDOSTAT;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
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
GV$VERSION: Synonym for GV_$VERSION
iSelfSchooling-SQL> desc GV$VERSION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
BANNER
VARCHAR2(64)
GV$VPD_POLICY: Synonym for GV_$VPD_POLICY
iSelfSchooling-SQL> desc GV$VPD_POLICY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
PARADDR
RAW(8)
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)
GV$WAITCLASSMETRIC: Synonym for GV_$WAITCLASSMETRIC
iSelfSchooling-SQL> desc GV$WAITCLASSMETRIC;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$WAITCLASSMETRIC_HISTORY: Synonym for GV_$WAITCLASSMETRIC_HISTORY
iSelfSchooling-SQL> desc GV$WAITCLASSMETRIC_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$WAITSTAT: Synonym for GV_$WAITSTAT
iSelfSchooling-SQL> desc GV$WAITSTAT;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CLASS
VARCHAR2(18)
COUNT
NUMBER
TIME
NUMBER
GV$WALLET: Synonym for GV_$WALLET
iSelfSchooling-SQL> desc GV$WALLET;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CERT_ID
VARCHAR2(52)
DN
VARCHAR2(255)
SERIAL_NUM
VARCHAR2(40)
ISSUER
VARCHAR2(255)
KEYSIZE
NUMBER
STATUS
VARCHAR2(16)
GV$XML_AUDIT_TRAIL: Synonym for GV_$XML_AUDIT_TRAIL
iSelfSchooling-SQL> desc GV$XML_AUDIT_TRAIL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
AUDIT_TYPE
NUMBER
SESSION_ID
NUMBER
PROXY_SESSIONID
NUMBER
STATEMENTID
NUMBER
ENTRYID
NUMBER
EXTENDED_TIMESTAMP
TIMESTAMP(6)
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(30)
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)
GV$_LOCK: Synonym for GV_$_LOCK
iSelfSchooling-SQL> desc GV$_LOCK;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
LADDR
RAW(8)
KADDR
RAW(8)
SADDR
RAW(8)
RADDR
RAW(8)
LMODE
NUMBER
REQUEST
NUMBER
CTIME
NUMBER
BLOCK
NUMBER
|