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$BACKUP_ASYNC_IO: Synonym for GV_$BACKUP_ASYNC_IO

 

iSelfSchooling-SQL> desc GV$BACKUP_ASYNC_IO;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SID                                    NUMBER

 SERIAL                                 NUMBER

 USE_COUNT                              NUMBER

 RMAN_STATUS_RECID                      NUMBER

 RMAN_STATUS_STAMP                      NUMBER

 DEVICE_TYPE                            VARCHAR2(17)

 TYPE                                   VARCHAR2(9)

 STATUS                                 VARCHAR2(11)

 FILENAME                               VARCHAR2(513)

 SET_COUNT                              NUMBER

 SET_STAMP                              NUMBER

 BUFFER_SIZE                            NUMBER

 BUFFER_COUNT                           NUMBER

 TOTAL_BYTES                            NUMBER

 OPEN_TIME                              DATE

 CLOSE_TIME                             DATE

 ELAPSED_TIME                           NUMBER

 MAXOPENFILES                           NUMBER

 BYTES                                  NUMBER

 EFFECTIVE_BYTES_PER_SECOND             NUMBER

 IO_COUNT                               NUMBER

 READY                                  NUMBER

 SHORT_WAITS                            NUMBER

 SHORT_WAIT_TIME_TOTAL                  NUMBER

 SHORT_WAIT_TIME_MAX                    NUMBER

 LONG_WAITS                             NUMBER

 LONG_WAIT_TIME_TOTAL                   NUMBER

 LONG_WAIT_TIME_MAX                     NUMBER

 

GV$BACKUP_CORRUPTION: Synonym for GV_$BACKUP_CORRUPTION

 

iSelfSchooling-SQL> desc GV$BACKUP_CORRUPTION;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 SET_STAMP                              NUMBER

 SET_COUNT                              NUMBER

 PIECE#                                 NUMBER

 FILE#                                  NUMBER

 BLOCK#                                 NUMBER

 BLOCKS                                 NUMBER

 CORRUPTION_CHANGE#                     NUMBER

 MARKED_CORRUPT                         VARCHAR2(3)

 CORRUPTION_TYPE                        VARCHAR2(9)

 

GV$BACKUP_DATAFILE: Synonym for GV_$BACKUP_DATAFILE

 

iSelfSchooling-SQL> desc GV$BACKUP_DATAFILE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 SET_STAMP                              NUMBER

 SET_COUNT                              NUMBER

 FILE#                                  NUMBER

 CREATION_CHANGE#                       NUMBER

 CREATION_TIME                          DATE

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 INCREMENTAL_LEVEL                      NUMBER

 INCREMENTAL_CHANGE#                    NUMBER

 CHECKPOINT_CHANGE#                     NUMBER

 CHECKPOINT_TIME                        DATE

 ABSOLUTE_FUZZY_CHANGE#                 NUMBER

 MARKED_CORRUPT                         NUMBER

 MEDIA_CORRUPT                          NUMBER

 LOGICALLY_CORRUPT                      NUMBER

 DATAFILE_BLOCKS                        NUMBER

 BLOCKS                                 NUMBER

 BLOCK_SIZE                             NUMBER

 OLDEST_OFFLINE_RANGE                   NUMBER

 COMPLETION_TIME                        DATE

 CONTROLFILE_TYPE                       VARCHAR2(1)

 USED_CHANGE_TRACKING                   VARCHAR2(3)

 BLOCKS_READ                            NUMBER

 USED_OPTIMIZATION                      VARCHAR2(3)

 

GV$BACKUP_DEVICE: Synonym for GV_$BACKUP_DEVICE

 

iSelfSchooling-SQL> desc GV$BACKUP_DEVICE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 DEVICE_TYPE                            VARCHAR2(17)

 DEVICE_NAME                            VARCHAR2(513)

 

GV$BACKUP_PIECE: Synonym for GV_$BACKUP_PIECE

 

iSelfSchooling-SQL> desc GV$BACKUP_PIECE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 SET_STAMP                              NUMBER

 SET_COUNT                              NUMBER

 PIECE#                                 NUMBER

 COPY#                                  NUMBER

 DEVICE_TYPE                            VARCHAR2(17)

 HANDLE                                 VARCHAR2(513)

 COMMENTS                               VARCHAR2(64)

 MEDIA                                  VARCHAR2(65)

 MEDIA_POOL                             NUMBER

 CONCUR                                 VARCHAR2(3)

 TAG                                    VARCHAR2(32)

 STATUS                                 VARCHAR2(1)

 DELETED                                VARCHAR2(3)

 START_TIME                             DATE

 COMPLETION_TIME                        DATE

 ELAPSED_SECONDS                        NUMBER

 BYTES                                  NUMBER

 IS_RECOVERY_DEST_FILE                  VARCHAR2(3)

 RMAN_STATUS_RECID                      NUMBER

 RMAN_STATUS_STAMP                      NUMBER

 COMPRESSED                             VARCHAR2(3)

 

GV$BACKUP_REDOLOG: Synonym for GV_$BACKUP_REDOLOG

 

iSelfSchooling-SQL> desc GV$BACKUP_REDOLOG;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 SET_STAMP                              NUMBER

 SET_COUNT                              NUMBER

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 FIRST_CHANGE#                          NUMBER

 FIRST_TIME                             DATE

 NEXT_CHANGE#                           NUMBER

 NEXT_TIME                              DATE

 BLOCKS                                 NUMBER

 BLOCK_SIZE                             NUMBER

 

GV$BACKUP_SET: Synonym for GV_$BACKUP_SET

 

iSelfSchooling-SQL> desc GV$BACKUP_SET;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 SET_STAMP                              NUMBER

 SET_COUNT                              NUMBER

 BACKUP_TYPE                            VARCHAR2(1)

 CONTROLFILE_INCLUDED                   VARCHAR2(3)

 INCREMENTAL_LEVEL                      NUMBER

 PIECES                                 NUMBER

 START_TIME                             DATE

 COMPLETION_TIME                        DATE

 ELAPSED_SECONDS                        NUMBER

 BLOCK_SIZE                             NUMBER

 INPUT_FILE_SCAN_ONLY                   VARCHAR2(3)

 KEEP                                   VARCHAR2(3)

 KEEP_UNTIL                             DATE

 KEEP_OPTIONS                           VARCHAR2(10)

 

GV$BACKUP_SPFILE: Synonym for GV_$BACKUP_SPFILE

 

iSelfSchooling-SQL> desc GV$BACKUP_SPFILE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 SET_STAMP                              NUMBER

 SET_COUNT                              NUMBER

 MODIFICATION_TIME                      DATE

 BYTES                                  NUMBER

 COMPLETION_TIME                        DATE

 

GV$BACKUP_SYNC_IO: Synonym for GV_$BACKUP_SYNC_IO

 

iSelfSchooling-SQL> desc GV$BACKUP_SYNC_IO;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SID                                    NUMBER

 SERIAL                                 NUMBER

 USE_COUNT                              NUMBER

 RMAN_STATUS_RECID                      NUMBER

 RMAN_STATUS_STAMP                      NUMBER

 DEVICE_TYPE                            VARCHAR2(17)

 TYPE                                   VARCHAR2(9)

 STATUS                                 VARCHAR2(11)

 FILENAME                               VARCHAR2(513)

 SET_COUNT                              NUMBER

 SET_STAMP                              NUMBER

 BUFFER_SIZE                            NUMBER

 BUFFER_COUNT                           NUMBER

 TOTAL_BYTES                            NUMBER

 OPEN_TIME                              DATE

 CLOSE_TIME                             DATE

 ELAPSED_TIME                           NUMBER

 MAXOPENFILES                           NUMBER

 BYTES                                  NUMBER

 EFFECTIVE_BYTES_PER_SECOND             NUMBER

 IO_COUNT                               NUMBER

 IO_TIME_TOTAL                          NUMBER

 IO_TIME_MAX                            NUMBER

 DISCRETE_BYTES_PER_SECOND              NUMBER

 

GV$BGPROCESS: Synonym for GV_$BGPROCESS

 

iSelfSchooling-SQL> desc GV$BGPROCESS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 PADDR                                  RAW(8)

 PSERIAL#                               NUMBER

 NAME                                   VARCHAR2(5)

 DESCRIPTION                            VARCHAR2(64)

 ERROR                                  NUMBER

 

GV$BH: Synonym for GV_$BH

 

iSelfSchooling-SQL> desc GV$BH;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 FILE#                                  NUMBER

 BLOCK#                                 NUMBER

 CLASS#                                 NUMBER

 STATUS                                 VARCHAR2(7)

 XNC                                    NUMBER

 FORCED_READS                           NUMBER

 FORCED_WRITES                          NUMBER

 LOCK_ELEMENT_ADDR                      RAW(8)

 LOCK_ELEMENT_NAME                      NUMBER

 LOCK_ELEMENT_CLASS                     NUMBER

 DIRTY                                  VARCHAR2(1)

 TEMP                                   VARCHAR2(1)

 PING                                   VARCHAR2(1)

 STALE                                  VARCHAR2(1)

 DIRECT                                 VARCHAR2(1)

 NEW                                    CHAR(1)

 OBJD                                   NUMBER

 TS#                                    NUMBER

 

GV$BLOCKING_QUIESCE: Synonym for GV_$BLOCKING_QUIESCE

 

iSelfSchooling-SQL> desc GV$BLOCKING_QUIESCE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SID                                    NUMBER

 

GV$BSP: Synonym for GV_$BSP

 

iSelfSchooling-SQL> desc GV$BSP;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 CR_REQUESTS                            NUMBER

 CURRENT_REQUESTS                       NUMBER

 DATA_REQUESTS                          NUMBER

 UNDO_REQUESTS                          NUMBER

 TX_REQUESTS                            NUMBER

 CURRENT_RESULTS                        NUMBER

 PRIVATE_RESULTS                        NUMBER

 ZERO_RESULTS                           NUMBER

 DISK_READ_RESULTS                      NUMBER

 FAIL_RESULTS                           NUMBER

 FAIRNESS_DOWN_CONVERTS                 NUMBER

 FAIRNESS_CLEARS                        NUMBER

 FREE_LOCK_ELEMENTS                     NUMBER

 FLUSHES                                NUMBER

 FLUSHES_QUEUED                         NUMBER

 FLUSH_QUEUE_FULL                       NUMBER

 FLUSH_MAX_TIME                         NUMBER

 LIGHT_WORKS                            NUMBER

 ERRORS                                 NUMBER

 

GV$BUFFERED_PUBLISHERS: Synonym for GV_$BUFFERED_PUBLISHERS

 

iSelfSchooling-SQL> desc GV$BUFFERED_PUBLISHERS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 QUEUE_ID                               NUMBER

 QUEUE_SCHEMA                           VARCHAR2(30)

 QUEUE_NAME                             VARCHAR2(30)

 SENDER_NAME                            VARCHAR2(30)

 SENDER_ADDRESS                         VARCHAR2(1024)

 SENDER_PROTOCOL                        NUMBER

 NUM_MSGS                               NUMBER

 CNUM_MSGS                              NUMBER

 LAST_ENQUEUED_MSG                      NUMBER

 UNBROWSED_MSGS                         NUMBER

 OVERSPILLED_MSGS                       NUMBER

 MEMORY_USAGE                           NUMBER

 PUBLISHER_STATE                        VARCHAR2(59)

 

GV$BUFFERED_QUEUES: Synonym for GV_$BUFFERED_QUEUES

 

iSelfSchooling-SQL> desc GV$BUFFERED_QUEUES;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 QUEUE_ID                               NUMBER

 QUEUE_SCHEMA                           VARCHAR2(30)

 QUEUE_NAME                             VARCHAR2(30)

 STARTUP_TIME                           DATE

 NUM_MSGS                               NUMBER

 SPILL_MSGS                             NUMBER

 CNUM_MSGS                              NUMBER

 CSPILL_MSGS                            NUMBER

 EXPIRED_MSGS                           NUMBER

 

GV$BUFFERED_SUBSCRIBERS: Synonym for GV_$BUFFERED_SUBSCRIBERS

 

iSelfSchooling-SQL> desc GV$BUFFERED_SUBSCRIBERS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 QUEUE_ID                               NUMBER

 QUEUE_SCHEMA                           VARCHAR2(30)

 QUEUE_NAME                             VARCHAR2(30)

 SUBSCRIBER_ID                          NUMBER

 SUBSCRIBER_NAME                        VARCHAR2(30)

 SUBSCRIBER_ADDRESS                     VARCHAR2(1024)

 PROTOCOL                               NUMBER

 SUBSCRIBER_TYPE                        VARCHAR2(30)

 STARTUP_TIME                           DATE

 LAST_BROWSED_SEQ                       NUMBER

 LAST_BROWSED_NUM                       NUMBER

 LAST_DEQUEUED_SEQ                      NUMBER

 LAST_DEQUEUED_NUM                      NUMBER

 CURRENT_ENQ_SEQ                        NUMBER

 NUM_MSGS                               NUMBER

 CNUM_MSGS                              NUMBER

 TOTAL_DEQUEUED_MSG                     NUMBER

 TOTAL_SPILLED_MSG                      NUMBER

 EXPIRED_MSGS                           NUMBER

 

GV$BUFFER_POOL: Synonym for GV_$BUFFER_POOL

 

iSelfSchooling-SQL> desc GV$BUFFER_POOL;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 ID                                     NUMBER

 NAME                                   VARCHAR2(20)

 BLOCK_SIZE                             NUMBER

 RESIZE_STATE                           VARCHAR2(10)

 CURRENT_SIZE                           NUMBER

 BUFFERS                                NUMBER

 TARGET_SIZE                            NUMBER

 TARGET_BUFFERS                         NUMBER

 PREV_SIZE                              NUMBER

 PREV_BUFFERS                           NUMBER

 LO_BNUM                                NUMBER

 HI_BNUM                                NUMBER

 LO_SETID                               NUMBER

 HI_SETID                               NUMBER

 SET_COUNT                              NUMBER

 

GV$BUFFER_POOL_STATISTICS: Synonym for GV_$BUFFER_POOL_STATISTICS

 

iSelfSchooling-SQL> desc GV$BUFFER_POOL_STATISTICS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 ID                                     NUMBER

 NAME                                   VARCHAR2(20)

 BLOCK_SIZE                             NUMBER

 SET_MSIZE                              NUMBER

 CNUM_REPL                              NUMBER

 CNUM_WRITE                             NUMBER

 CNUM_SET                               NUMBER

 BUF_GOT                                NUMBER

 SUM_WRITE                              NUMBER

 SUM_SCAN                               NUMBER

 FREE_BUFFER_WAIT                       NUMBER

 WRITE_COMPLETE_WAIT                    NUMBER

 BUFFER_BUSY_WAIT                       NUMBER

 FREE_BUFFER_INSPECTED                  NUMBER

 DIRTY_BUFFERS_INSPECTED                NUMBER

 DB_BLOCK_CHANGE                        NUMBER

 DB_BLOCK_GETS                          NUMBER

 CONSISTENT_GETS                        NUMBER

 PHYSICAL_READS                         NUMBER

 PHYSICAL_WRITES                        NUMBER

 

GV$CIRCUIT: Synonym for GV_$CIRCUIT

 

iSelfSchooling-SQL> desc GV$CIRCUIT;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 CIRCUIT                                RAW(8)

 DISPATCHER                             RAW(8)

 SERVER                                 RAW(8)

 WAITER                                 RAW(8)

 SADDR                                  RAW(8)

 STATUS                                 VARCHAR2(16)

 QUEUE                                  VARCHAR2(16)

 MESSAGE0                               NUMBER

 MESSAGE1                               NUMBER

 MESSAGE2                               NUMBER

 MESSAGE3                               NUMBER

 MESSAGES                               NUMBER

 BYTES                                  NUMBER

 BREAKS                                 NUMBER

 PRESENTATION                           VARCHAR2(257)

 PCIRCUIT                               RAW(8)

 

GV$CLASS_CACHE_TRANSFER: Synonym for GV_$CLASS_CACHE_TRANSFER

 

iSelfSchooling-SQL> desc GV$CLASS_CACHE_TRANSFER;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 CLASS                                  CHAR(10)

 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

 NULL_2_X                               NUMBER

 S_2_X                                  NUMBER

 NULL_2_S                               NUMBER

 CR_TRANSFER                            NUMBER

 CURRENT_TRANSFER                       NUMBER

 

GV$CLASS_PING: Synonym for GV_$CLASS_PING

 

iSelfSchooling-SQL> desc GV$CLASS_PING;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 CLASS                                  CHAR(10)

 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

 OP_2_SS                                NUMBER

 NULL_2_X                               NUMBER

 S_2_X                                  NUMBER

 SSX_2_X                                NUMBER

 NULL_2_S                               NUMBER

 NULL_2_SS                              NUMBER

 

GV$CLIENT_STATS: Synonym for GV_$CLIENT_STATS

 

iSelfSchooling-SQL> desc GV$CLIENT_STATS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 CLIENT_IDENTIFIER                      VARCHAR2(64)

 STAT_ID                                NUMBER

 STAT_NAME                              VARCHAR2(64)

 VALUE                                  NUMBER

 

GV$CLUSTER_INTERCONNECTS: Synonym for GV_$CLUSTER_INTERCONNECTS

 

iSelfSchooling-SQL> desc GV$CLUSTER_INTERCONNECTS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 NAME                                   VARCHAR2(15)

 IP_ADDRESS                             VARCHAR2(16)

 IS_PUBLIC                              VARCHAR2(3)

 SOURCE                                 VARCHAR2(31)

 

GV$CONFIGURED_INTERCONNECTS: Synonym for GV_$CONFIGURED_INTERCONNECTS

 

iSelfSchooling-SQL> desc GV$CONFIGURED_INTERCONNECTS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 NAME                                   VARCHAR2(15)

 IP_ADDRESS                             VARCHAR2(16)

 IS_PUBLIC                              VARCHAR2(3)

 SOURCE                                 VARCHAR2(31)

 

GV$CONTEXT: Synonym for GV_$CONTEXT

 

iSelfSchooling-SQL> desc GV$CONTEXT;

 Name                          Null?    Type

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

 NAMESPACE                              VARCHAR2(31)

 ATTRIBUTE                              VARCHAR2(31)

 VALUE                                  VARCHAR2(4000)

 

GV$CONTROLFILE: Synonym for GV_$CONTROLFILE

 

iSelfSchooling-SQL> desc GV$CONTROLFILE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 STATUS                                 VARCHAR2(7)

 NAME                                   VARCHAR2(513)

 IS_RECOVERY_DEST_FILE                  VARCHAR2(3)

 BLOCK_SIZE                             NUMBER

 FILE_SIZE_BLKS                         NUMBER

 

GV$CONTROLFILE_RECORD_SECTION: Synonym for GV_$CONTROLFILE_RECORD_SECTION

 

iSelfSchooling-SQL> desc GV$CONTROLFILE_RECORD_SECTION;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 TYPE                                   VARCHAR2(28)

 RECORD_SIZE                            NUMBER

 RECORDS_TOTAL                          NUMBER

 RECORDS_USED                           NUMBER

 FIRST_INDEX                            NUMBER

 LAST_INDEX                             NUMBER

 LAST_RECID                             NUMBER

 

GV$COPY_CORRUPTION: Synonym for GV_$COPY_CORRUPTION

 

iSelfSchooling-SQL> desc GV$COPY_CORRUPTION;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 COPY_RECID                             NUMBER

 COPY_STAMP                             NUMBER

 FILE#                                  NUMBER

 BLOCK#                                 NUMBER

 BLOCKS                                 NUMBER

 CORRUPTION_CHANGE#                     NUMBER

 MARKED_CORRUPT                         VARCHAR2(3)

 CORRUPTION_TYPE                        VARCHAR2(9)

 

GV$CR_BLOCK_SERVER: Synonym for GV_$CR_BLOCK_SERVER

 

iSelfSchooling-SQL> desc GV$CR_BLOCK_SERVER;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 CR_REQUESTS                            NUMBER

 CURRENT_REQUESTS                       NUMBER

 DATA_REQUESTS                          NUMBER

 UNDO_REQUESTS                          NUMBER

 TX_REQUESTS                            NUMBER

 CURRENT_RESULTS                        NUMBER

 PRIVATE_RESULTS                        NUMBER

 ZERO_RESULTS                           NUMBER

 DISK_READ_RESULTS                      NUMBER

 FAIL_RESULTS                           NUMBER

 FAIRNESS_DOWN_CONVERTS                 NUMBER

 FAIRNESS_CLEARS                        NUMBER

 FREE_GC_ELEMENTS                       NUMBER

 FLUSHES                                NUMBER

 FLUSHES_QUEUED                         NUMBER

 FLUSH_QUEUE_FULL                       NUMBER

 FLUSH_MAX_TIME                         NUMBER

 LIGHT_WORKS                            NUMBER

 ERRORS                                 NUMBER

 

GV$CURRENT_BLOCK_SERVER: Synonym for GV_$CURRENT_BLOCK_SERVER

 

iSelfSchooling-SQL> desc GV$CURRENT_BLOCK_SERVER;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 PIN1                                   NUMBER

 PIN10                                  NUMBER

 PIN100                                 NUMBER

 PIN1000                                NUMBER

 PIN10000                               NUMBER

 FLUSH1                                 NUMBER

 FLUSH10                                NUMBER

 FLUSH100                               NUMBER

 FLUSH1000                              NUMBER

 FLUSH10000                             NUMBER

 WRITE1                                 NUMBER

 WRITE10                                NUMBER

 WRITE100                               NUMBER

 WRITE1000                              NUMBER

 WRITE10000                             NUMBER

 

 

 

Google
 
Web web site