iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Complete Syntax  |  Oracle Functions  |  PL/SQL Syntax  |  SQL Syntax  |  Tables

 

Oracle Dictionary Tables

ALL_  |  DBA_  |  USER_  |  GV$  |  V$  |  Others

ACC... | BAC... | DAT... | ENQ... | INS... | LOG... | PGA... | ROW... | SES... | SQL... | SYS...

 

GV$DATABASE: Synonym for GV_$DATABASE

 

iSelfSchooling-SQL> desc GV$DATABASE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 DBID                                   NUMBER

 NAME                                   VARCHAR2(9)

 CREATED                                DATE

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 PRIOR_RESETLOGS_CHANGE#                NUMBER

 PRIOR_RESETLOGS_TIME                   DATE

 LOG_MODE                               VARCHAR2(12)

 CHECKPOINT_CHANGE#                     NUMBER

 ARCHIVE_CHANGE#                        NUMBER

 CONTROLFILE_TYPE                       VARCHAR2(7)

 CONTROLFILE_CREATED                    DATE

 CONTROLFILE_SEQUENCE#                  NUMBER

 CONTROLFILE_CHANGE#                    NUMBER

 CONTROLFILE_TIME                       DATE

 OPEN_RESETLOGS                         VARCHAR2(11)

 VERSION_TIME                           DATE

 OPEN_MODE                              VARCHAR2(10)

 PROTECTION_MODE                        VARCHAR2(20)

 PROTECTION_LEVEL                       VARCHAR2(20)

 REMOTE_ARCHIVE                         VARCHAR2(8)

 ACTIVATION#                            NUMBER

 SWITCHOVER#                            NUMBER

 DATABASE_ROLE                          VARCHAR2(16)

 ARCHIVELOG_CHANGE#                     NUMBER

 ARCHIVELOG_COMPRESSION                 VARCHAR2(8)

 SWITCHOVER_STATUS                      VARCHAR2(20)

 DATAGUARD_BROKER                       VARCHAR2(8)

 GUARD_STATUS                           VARCHAR2(7)

 SUPPLEMENTAL_LOG_DATA_MIN              VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_PK               VARCHAR2(3)

 SUPPLEMENTAL_LOG_DATA_UI               VARCHAR2(3)

 FORCE_LOGGING                          VARCHAR2(3)

 PLATFORM_ID                            NUMBER

 PLATFORM_NAME                          VARCHAR2(101)

 RECOVERY_TARGET_INCARNATION#           NUMBER

 LAST_OPEN_INCARNATION#                 NUMBER

 CURRENT_SCN                            NUMBER

 FLASHBACK_ON                           VARCHAR2(18)

 SUPPLEMENTAL_LOG_DATA_FK               VARCHAR2(3)

 SUPPLEMENTAL_LOG_DATA_ALL              VARCHAR2(3)

 DB_UNIQUE_NAME                         VARCHAR2(30)

 STANDBY_BECAME_PRIMARY_SCN             NUMBER

 FS_FAILOVER_STATUS                     VARCHAR2(21)

 FS_FAILOVER_CURRENT_TARGET             VARCHAR2(30)

 FS_FAILOVER_THRESHOLD                  NUMBER

 FS_FAILOVER_OBSERVER_PRESENT           VARCHAR2(7)

 FS_FAILOVER_OBSERVER_HOST              VARCHAR2(512)

 

GV$DATABASE_BLOCK_CORRUPTION: Synonym for GV_$DATABASE_BLOCK_CORRUPTION

 

iSelfSchooling-SQL> desc GV$DATABASE_BLOCK_CORRUPTION;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 FILE#                                  NUMBER

 BLOCK#                                 NUMBER

 BLOCKS                                 NUMBER

 CORRUPTION_CHANGE#                     NUMBER

 CORRUPTION_TYPE                        VARCHAR2(9)

 

GV$DATABASE_INCARNATION: Synonym for GV_$DATABASE_INCARNATION

 

iSelfSchooling-SQL> desc GV$DATABASE_INCARNATION;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 INCARNATION#                           NUMBER

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 PRIOR_RESETLOGS_CHANGE#                NUMBER

 PRIOR_RESETLOGS_TIME                   DATE

 STATUS                                 VARCHAR2(7)

 RESETLOGS_ID                           NUMBER

 PRIOR_INCARNATION#                     NUMBER

 FLASHBACK_DATABASE_ALLOWED             VARCHAR2(26)

 

GV$DATAFILE: Synonym for GV_$DATAFILE

 

iSelfSchooling-SQL> desc GV$DATAFILE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 FILE#                                  NUMBER

 CREATION_CHANGE#                       NUMBER

 CREATION_TIME                          DATE

 TS#                                    NUMBER

 RFILE#                                 NUMBER

 STATUS                                 VARCHAR2(7)

 ENABLED                                VARCHAR2(10)

 CHECKPOINT_CHANGE#                     NUMBER

 CHECKPOINT_TIME                        DATE

 UNRECOVERABLE_CHANGE#                  NUMBER

 UNRECOVERABLE_TIME                     DATE

 LAST_CHANGE#                           NUMBER

 LAST_TIME                              DATE

 OFFLINE_CHANGE#                        NUMBER

 ONLINE_CHANGE#                         NUMBER

 ONLINE_TIME                            DATE

 BYTES                                  NUMBER

 BLOCKS                                 NUMBER

 CREATE_BYTES                           NUMBER

 BLOCK_SIZE                             NUMBER

 NAME                                   VARCHAR2(513)

 PLUGGED_IN                             NUMBER

 BLOCK1_OFFSET                          NUMBER

 AUX_NAME                               VARCHAR2(513)

 FIRST_NONLOGGED_SCN                    NUMBER

 FIRST_NONLOGGED_TIME                   DATE

 

GV$DATAFILE_COPY: Synonym for GV_$DATAFILE_COPY

 

iSelfSchooling-SQL> desc GV$DATAFILE_COPY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 NAME                                   VARCHAR2(513)

 TAG                                    VARCHAR2(32)

 FILE#                                  NUMBER

 RFILE#                                 NUMBER

 CREATION_CHANGE#                       NUMBER

 CREATION_TIME                          DATE

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 INCREMENTAL_LEVEL                      NUMBER

 CHECKPOINT_CHANGE#                     NUMBER

 CHECKPOINT_TIME                        DATE

 ABSOLUTE_FUZZY_CHANGE#                 NUMBER

 RECOVERY_FUZZY_CHANGE#                 NUMBER

 RECOVERY_FUZZY_TIME                    DATE

 ONLINE_FUZZY                           VARCHAR2(3)

 BACKUP_FUZZY                           VARCHAR2(3)

 MARKED_CORRUPT                         NUMBER

 MEDIA_CORRUPT                          NUMBER

 LOGICALLY_CORRUPT                      NUMBER

 BLOCKS                                 NUMBER

 BLOCK_SIZE                             NUMBER

 OLDEST_OFFLINE_RANGE                   NUMBER

 DELETED                                VARCHAR2(3)

 STATUS                                 VARCHAR2(1)

 COMPLETION_TIME                        DATE

 CONTROLFILE_TYPE                       VARCHAR2(1)

 KEEP                                   VARCHAR2(3)

 KEEP_UNTIL                             DATE

 KEEP_OPTIONS                           VARCHAR2(10)

 SCANNED                                VARCHAR2(3)

 IS_RECOVERY_DEST_FILE                  VARCHAR2(3)

 RMAN_STATUS_RECID                      NUMBER

 RMAN_STATUS_STAMP                      NUMBER

 

GV$DATAFILE_HEADER: Synonym for GV_$DATAFILE_HEADER

 

iSelfSchooling-SQL> desc GV$DATAFILE_HEADER;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 FILE#                                  NUMBER

 STATUS                                 VARCHAR2(7)

 ERROR                                  VARCHAR2(18)

 FORMAT                                 NUMBER

 RECOVER                                VARCHAR2(3)

 FUZZY                                  VARCHAR2(3)

 CREATION_CHANGE#                       NUMBER

 CREATION_TIME                          DATE

 TABLESPACE_NAME                        VARCHAR2(30)

 TS#                                    NUMBER

 RFILE#                                 NUMBER

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 CHECKPOINT_CHANGE#                     NUMBER

 CHECKPOINT_TIME                        DATE

 CHECKPOINT_COUNT                       NUMBER

 BYTES                                  NUMBER

 BLOCKS                                 NUMBER

 NAME                                   VARCHAR2(513)

 SPACE_HEADER                           VARCHAR2(40)

 LAST_DEALLOC_SCN                       VARCHAR2(16)

 

GV$DATAGUARD_CONFIG: Synonym for GV_$DATAGUARD_CONFIG

 

iSelfSchooling-SQL> desc GV$DATAGUARD_CONFIG;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DB_UNIQUE_NAME                         VARCHAR2(30)

 

GV$DATAGUARD_STATUS: Synonym for GV_$DATAGUARD_STATUS

 

iSelfSchooling-SQL> desc GV$DATAGUARD_STATUS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 FACILITY                               VARCHAR2(24)

 SEVERITY                               VARCHAR2(13)

 DEST_ID                                NUMBER

 MESSAGE_NUM                            NUMBER

 ERROR_CODE                             NUMBER

 CALLOUT                                VARCHAR2(3)

 TIMESTAMP                              DATE

 MESSAGE                                VARCHAR2(256)

 

GV$DATAPUMP_JOB: Synonym for GV_$DATAPUMP_JOB

 

iSelfSchooling-SQL> desc GV$DATAPUMP_JOB;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 JOB_ID                                 RAW(16)

 JOB_NAME                               VARCHAR2(30)

 OWNER_NAME                             VARCHAR2(30)

 MSG_CTRL_QUEUE                         VARCHAR2(30)

 STATUS_QUEUE                           VARCHAR2(30)

 OPERATION                              VARCHAR2(30)

 JOB_MODE                               VARCHAR2(30)

 MASTER_ID                              NUMBER

 STATE                                  VARCHAR2(30)

 WORKERS                                NUMBER

 FLAGS                                  NUMBER

 

GV$DATAPUMP_SESSION: Synonym for GV_$DATAPUMP_SESSION

 

iSelfSchooling-SQL> desc GV$DATAPUMP_SESSION;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 ATTACH_ID                              NUMBER

 JOB_ID                                 RAW(16)

 SADDR                                  RAW(8)

 TYPE                                   VARCHAR2(14)

 

GV$DBFILE: Synonym for GV_$DBFILE

 

iSelfSchooling-SQL> desc GV$DBFILE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 FILE#                                  NUMBER

 NAME                                   VARCHAR2(513)

 

GV$DBLINK: Synonym for GV_$DBLINK

 

iSelfSchooling-SQL> desc GV$DBLINK;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 DB_LINK                                VARCHAR2(128)

 OWNER_ID                               NUMBER

 LOGGED_ON                              VARCHAR2(3)

 HETEROGENEOUS                          VARCHAR2(3)

 PROTOCOL                               VARCHAR2(6)

 OPEN_CURSORS                           NUMBER

 IN_TRANSACTION                         VARCHAR2(3)

 UPDATE_SENT                            VARCHAR2(3)

 COMMIT_POINT_STRENGTH                  NUMBER

 

GV$DB_CACHE_ADVICE: Synonym for GV_$DB_CACHE_ADVICE

 

iSelfSchooling-SQL> desc GV$DB_CACHE_ADVICE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 ID                                     NUMBER

 NAME                                   VARCHAR2(20)

 BLOCK_SIZE                             NUMBER

 ADVICE_STATUS                          VARCHAR2(3)

 SIZE_FOR_ESTIMATE                      NUMBER

 SIZE_FACTOR                            NUMBER

 BUFFERS_FOR_ESTIMATE                   NUMBER

 ESTD_PHYSICAL_READ_FACTOR              NUMBER

 ESTD_PHYSICAL_READS                    NUMBER

 ESTD_PHYSICAL_READ_TIME                NUMBER

 ESTD_PCT_OF_DB_TIME_FOR_READS          NUMBER

 ESTD_CLUSTER_READS                     NUMBER

 ESTD_CLUSTER_READ_TIME                 NUMBER

 

GV$DB_OBJECT_CACHE: Synonym for GV_$DB_OBJECT_CACHE

 

iSelfSchooling-SQL> desc GV$DB_OBJECT_CACHE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 OWNER                                  VARCHAR2(64)

 NAME                                   VARCHAR2(1000)

 DB_LINK                                VARCHAR2(64)

 NAMESPACE                              VARCHAR2(28)

 TYPE                                   VARCHAR2(28)

 SHARABLE_MEM                           NUMBER

 LOADS                                  NUMBER

 EXECUTIONS                             NUMBER

 LOCKS                                  NUMBER

 PINS                                   NUMBER

 KEPT                                   VARCHAR2(3)

 CHILD_LATCH                            NUMBER

 INVALIDATIONS                          NUMBER

 

GV$DB_PIPES: Synonym for GV_$DB_PIPES

 

iSelfSchooling-SQL> desc GV$DB_PIPES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 OWNERID                                NUMBER

 NAME                                   VARCHAR2(1000)

 TYPE                                   VARCHAR2(7)

 PIPE_SIZE                              NUMBER

 

GV$DELETED_OBJECT: Synonym for GV_$DELETED_OBJECT

 

iSelfSchooling-SQL> desc GV$DELETED_OBJECT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 TYPE                                   VARCHAR2(26)

 OBJECT_RECID                           NUMBER

 OBJECT_STAMP                           NUMBER

 OBJECT_DATA                            NUMBER

 

GV$DISPATCHER: Synonym for GV_$DISPATCHER

 

iSelfSchooling-SQL> desc GV$DISPATCHER;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 NAME                                   VARCHAR2(4)

 NETWORK                                VARCHAR2(128)

 PADDR                                  RAW(8)

 STATUS                                 VARCHAR2(16)

 ACCEPT                                 VARCHAR2(3)

 MESSAGES                               NUMBER

 BYTES                                  NUMBER

 BREAKS                                 NUMBER

 OWNED                                  NUMBER

 CREATED                                NUMBER

 IDLE                                   NUMBER

 BUSY                                   NUMBER

 LISTENER                               NUMBER

 CONF_INDX                              NUMBER

 

GV$DISPATCHER_CONFIG: Synonym for GV_$DISPATCHER_CONFIG

 

iSelfSchooling-SQL> desc GV$DISPATCHER_CONFIG;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 CONF_INDX                              NUMBER

 NETWORK                                VARCHAR2(128)

 DISPATCHERS                            NUMBER

 CONNECTIONS                            NUMBER

 SESSIONS                               NUMBER

 POOL                                   VARCHAR2(4)

 TICKS                                  NUMBER

 INBD_TIMOUT                            NUMBER

 OUTBD_TIMOUT                           NUMBER

 MULTIPLEX                              VARCHAR2(4)

 LISTENER                               VARCHAR2(1200)

 SERVICE                                VARCHAR2(512)

 

GV$DISPATCHER_RATE: Synonym for GV_$DISPATCHER_RATE

 

iSelfSchooling-SQL> desc GV$DISPATCHER_RATE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 NAME                                   VARCHAR2(4)

 PADDR                                  RAW(8)

 CUR_LOOP_RATE                          NUMBER

 CUR_EVENT_RATE                         NUMBER

 CUR_EVENTS_PER_LOOP                    NUMBER

 CUR_MSG_RATE                           NUMBER

 CUR_SVR_BUF_RATE                       NUMBER

 CUR_SVR_BYTE_RATE                      NUMBER

 CUR_SVR_BYTE_PER_BUF                   NUMBER

 CUR_CLT_BUF_RATE                       NUMBER

 CUR_CLT_BYTE_RATE                      NUMBER

 CUR_CLT_BYTE_PER_BUF                   NUMBER

 CUR_BUF_RATE                           NUMBER

 CUR_BYTE_RATE                          NUMBER

 CUR_BYTE_PER_BUF                       NUMBER

 CUR_IN_CONNECT_RATE                    NUMBER

 CUR_OUT_CONNECT_RATE                   NUMBER

 CUR_RECONNECT_RATE                     NUMBER

 MAX_LOOP_RATE                          NUMBER

 MAX_EVENT_RATE                         NUMBER

 MAX_EVENTS_PER_LOOP                    NUMBER

 MAX_MSG_RATE                           NUMBER

 MAX_SVR_BUF_RATE                       NUMBER

 MAX_SVR_BYTE_RATE                      NUMBER

 MAX_SVR_BYTE_PER_BUF                   NUMBER

 MAX_CLT_BUF_RATE                       NUMBER

 MAX_CLT_BYTE_RATE                      NUMBER

 MAX_CLT_BYTE_PER_BUF                   NUMBER

 MAX_BUF_RATE                           NUMBER

 MAX_BYTE_RATE                          NUMBER

 MAX_BYTE_PER_BUF                       NUMBER

 MAX_IN_CONNECT_RATE                    NUMBER

 MAX_OUT_CONNECT_RATE                   NUMBER

 MAX_RECONNECT_RATE                     NUMBER

 AVG_LOOP_RATE                          NUMBER

 AVG_EVENT_RATE                         NUMBER

 AVG_EVENTS_PER_LOOP                    NUMBER

 AVG_MSG_RATE                           NUMBER

 AVG_SVR_BUF_RATE                       NUMBER

 AVG_SVR_BYTE_RATE                      NUMBER

 AVG_SVR_BYTE_PER_BUF                   NUMBER

 AVG_CLT_BUF_RATE                       NUMBER

 AVG_CLT_BYTE_RATE                      NUMBER

 AVG_CLT_BYTE_PER_BUF                   NUMBER

 AVG_BUF_RATE                           NUMBER

 AVG_BYTE_RATE                          NUMBER

 AVG_BYTE_PER_BUF                       NUMBER

 AVG_IN_CONNECT_RATE                    NUMBER

 AVG_OUT_CONNECT_RATE                   NUMBER

 AVG_RECONNECT_RATE                     NUMBER

 TTL_LOOPS                              NUMBER

 TTL_MSG                                NUMBER

 TTL_SVR_BUF                            NUMBER

 TTL_CLT_BUF                            NUMBER

 TTL_BUF                                NUMBER

 TTL_IN_CONNECT                         NUMBER

 TTL_OUT_CONNECT                        NUMBER

 TTL_RECONNECT                          NUMBER

 SCALE_LOOPS                            NUMBER

 SCALE_MSG                              NUMBER

 SCALE_SVR_BUF                          NUMBER

 SCALE_CLT_BUF                          NUMBER

 SCALE_BUF                              NUMBER

 SCALE_IN_CONNECT                       NUMBER

 SCALE_OUT_CONNECT                      NUMBER

 SCALE_RECONNECT                        NUMBER

 

GV$DLM_ALL_LOCKS: Synonym for GV_$DLM_ALL_LOCKS

 

iSelfSchooling-SQL> desc GV$DLM_ALL_LOCKS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 LOCKP                                  RAW(8)

 GRANT_LEVEL                            VARCHAR2(9)

 REQUEST_LEVEL                          VARCHAR2(9)

 RESOURCE_NAME1                         VARCHAR2(30)

 RESOURCE_NAME2                         VARCHAR2(30)

 PID                                    NUMBER

 TRANSACTION_ID0                        NUMBER

 TRANSACTION_ID1                        NUMBER

 GROUP_ID                               NUMBER

 OPEN_OPT_DEADLOCK                      NUMBER

 OPEN_OPT_PERSISTENT                    NUMBER

 OPEN_OPT_PROCESS_OWNED                 NUMBER

 OPEN_OPT_NO_XID                        NUMBER

 CONVERT_OPT_GETVALUE                   NUMBER

 CONVERT_OPT_PUTVALUE                   NUMBER

 CONVERT_OPT_NOVALUE                    NUMBER

 CONVERT_OPT_DUBVALUE                   NUMBER

 CONVERT_OPT_NOQUEUE                    NUMBER

 CONVERT_OPT_EXPRESS                    NUMBER

 CONVERT_OPT_NODEADLOCKWAIT             NUMBER

 CONVERT_OPT_NODEADLOCKBLOCK            NUMBER

 WHICH_QUEUE                            NUMBER

 LOCKSTATE                              VARCHAR2(64)

 AST_EVENT0                             NUMBER

 OWNER_NODE                             NUMBER

 BLOCKED                                NUMBER

 BLOCKER                                NUMBER

 

GV$DLM_CONVERT_LOCAL: Synonym for GV_$DLM_CONVERT_LOCAL

 

iSelfSchooling-SQL> desc GV$DLM_CONVERT_LOCAL;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 CONVERT_TYPE                           VARCHAR2(16)

 AVERAGE_CONVERT_TIME                   NUMBER

 CONVERT_COUNT                          NUMBER

 

GV$DLM_CONVERT_REMOTE: Synonym for GV_$DLM_CONVERT_REMOTE

 

iSelfSchooling-SQL> desc GV$DLM_CONVERT_REMOTE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 CONVERT_TYPE                           VARCHAR2(16)

 AVERAGE_CONVERT_TIME                   NUMBER

 CONVERT_COUNT                          NUMBER

 

GV$DLM_LATCH: Synonym for GV_$DLM_LATCH

 

iSelfSchooling-SQL> desc GV$DLM_LATCH;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 ADDR                                   RAW(8)

 LATCH#                                 NUMBER

 LEVEL#                                 NUMBER

 NAME                                   VARCHAR2(50)

 GETS                                   NUMBER

 MISSES                                 NUMBER

 SLEEPS                                 NUMBER

 IMMEDIATE_GETS                         NUMBER

 IMMEDIATE_MISSES                       NUMBER

 WAITERS_WOKEN                          NUMBER

 WAITS_HOLDING_LATCH                    NUMBER

 SPIN_GETS                              NUMBER

 SLEEP1                                 NUMBER

 SLEEP2                                 NUMBER

 SLEEP3                                 NUMBER

 SLEEP4                                 NUMBER

 SLEEP5                                 NUMBER

 SLEEP6                                 NUMBER

 SLEEP7                                 NUMBER

 SLEEP8                                 NUMBER

 SLEEP9                                 NUMBER

 SLEEP10                                NUMBER

 SLEEP11                                NUMBER

 WAIT_TIME                              NUMBER

 

GV$DLM_LOCKS: Synonym for GV_$DLM_LOCKS

 

iSelfSchooling-SQL> desc GV$DLM_LOCKS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 LOCKP                                  RAW(8)

 GRANT_LEVEL                            VARCHAR2(9)

 REQUEST_LEVEL                          VARCHAR2(9)

 RESOURCE_NAME1                         VARCHAR2(30)

 RESOURCE_NAME2                         VARCHAR2(30)

 PID                                    NUMBER

 TRANSACTION_ID0                        NUMBER

 TRANSACTION_ID1                        NUMBER

 GROUP_ID                               NUMBER

 OPEN_OPT_DEADLOCK                      NUMBER

 OPEN_OPT_PERSISTENT                    NUMBER

 OPEN_OPT_PROCESS_OWNED                 NUMBER

 OPEN_OPT_NO_XID                        NUMBER

 CONVERT_OPT_GETVALUE                   NUMBER

 CONVERT_OPT_PUTVALUE                   NUMBER

 CONVERT_OPT_NOVALUE                    NUMBER

 CONVERT_OPT_DUBVALUE                   NUMBER

 CONVERT_OPT_NOQUEUE                    NUMBER

 CONVERT_OPT_EXPRESS                    NUMBER

 CONVERT_OPT_NODEADLOCKWAIT             NUMBER

 CONVERT_OPT_NODEADLOCKBLOCK            NUMBER

 WHICH_QUEUE                            NUMBER

 LOCKSTATE                              VARCHAR2(64)

 AST_EVENT0                             NUMBER

 OWNER_NODE                             NUMBER

 BLOCKED                                NUMBER

 BLOCKER                                NUMBER

 

GV$DLM_MISC: Synonym for GV_$DLM_MISC

 

iSelfSchooling-SQL> desc GV$DLM_MISC;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 STATISTIC#                             NUMBER

 NAME                                   VARCHAR2(38)

 VALUE                                  NUMBER

 

GV$DLM_RESS: Synonym for GV_$DLM_RESS

 

iSelfSchooling-SQL> desc GV$DLM_RESS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 RESP                                   RAW(8)

 RESOURCE_NAME                          VARCHAR2(30)

 ON_CONVERT_Q                           NUMBER

 ON_GRANT_Q                             NUMBER

 PERSISTENT_RES                         NUMBER

 MASTER_NODE                            NUMBER

 NEXT_CVT_LEVEL                         VARCHAR2(9)

 VALUE_BLK_STATE                        VARCHAR2(32)

 VALUE_BLK                              VARCHAR2(64)

 

GV$DLM_TRAFFIC_CONTROLLER: Synonym for GV_$DLM_TRAFFIC_CONTROLLER

 

iSelfSchooling-SQL> desc GV$DLM_TRAFFIC_CONTROLLER;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 LOCAL_NID                              NUMBER

 REMOTE_NID                             NUMBER

 REMOTE_RID                             NUMBER

 REMOTE_INC                             NUMBER

 TCKT_AVAIL                             NUMBER

 TCKT_LIMIT                             NUMBER

 TCKT_RCVD                              NUMBER

 TCKT_WAIT                              VARCHAR2(10)

 SND_SEQ_NO                             NUMBER

 RCV_SEQ_NO                             NUMBER

 SND_Q_LEN                              NUMBER

 SND_Q_MAX                              NUMBER

 SND_Q_TOT                              NUMBER

 SND_Q_TM_BASE                          NUMBER

 SND_Q_TM_WRAP                          NUMBER

 STATUS                                 NUMBER

 SND_PROXY                              NUMBER

 

GV$ENABLEDPRIVS: Synonym for GV_$ENABLEDPRIVS

 

iSelfSchooling-SQL> desc GV$ENABLEDPRIVS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 PRIV_NUMBER                            NUMBER

 

 

 

Google
 
Web web site