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$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                                  VARCHAR2(65)

 MEDIA_POOL                             NUMBER

 TAG                                    VARCHAR2(32)

 STATUS                                 VARCHAR2(1)

 DELETED                                VARCHAR2(3)

 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

 START_TIME                             DATE

 COMPLETION_TIME                        DATE

 ELAPSED_SECONDS                        NUMBER

 RMAN_STATUS_RECID                      NUMBER

 RMAN_STATUS_STAMP                      NUMBER

 

GV$PROXY_DATAFILE: Synonym for GV_$PROXY_DATAFILE

 

iSelfSchooling-SQL> desc GV$PROXY_DATAFILE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 DEVICE_TYPE                            VARCHAR2(17)

 HANDLE                                 VARCHAR2(513)

 COMMENTS                               VARCHAR2(81)

 MEDIA                                  VARCHAR2(65)

 MEDIA_POOL                             NUMBER

 TAG                                    VARCHAR2(32)

 STATUS                                 VARCHAR2(1)

 DELETED                                VARCHAR2(3)

 FILE#                                  NUMBER

 CREATION_CHANGE#                       NUMBER

 CREATION_TIME                          DATE

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 CHECKPOINT_CHANGE#                     NUMBER

 CHECKPOINT_TIME                        DATE

 ABSOLUTE_FUZZY_CHANGE#                 NUMBER

 RECOVERY_FUZZY_CHANGE#                 NUMBER

 RECOVERY_FUZZY_TIME                    DATE

 INCREMENTAL_LEVEL                      NUMBER

 ONLINE_FUZZY                           VARCHAR2(3)

 BACKUP_FUZZY                           VARCHAR2(3)

 BLOCKS                                 NUMBER

 BLOCK_SIZE                             NUMBER

 OLDEST_OFFLINE_RANGE                   NUMBER

 START_TIME                             DATE

 COMPLETION_TIME                        DATE

 ELAPSED_SECONDS                        NUMBER

 CONTROLFILE_TYPE                       VARCHAR2(1)

 KEEP                                   VARCHAR2(3)

 KEEP_UNTIL                             DATE

 KEEP_OPTIONS                           VARCHAR2(10)

 RMAN_STATUS_RECID                      NUMBER

 RMAN_STATUS_STAMP                      NUMBER

 

GV$PWFILE_USERS: Synonym for GV_$PWFILE_USERS

 

iSelfSchooling-SQL> desc GV$PWFILE_USERS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 USERNAME                               VARCHAR2(30)

 SYSDBA                                 VARCHAR2(5)

 SYSOPER                                VARCHAR2(5)

 

GV$PX_BUFFER_ADVICE: Synonym for GV_$PX_BUFFER_ADVICE

 

iSelfSchooling-SQL> desc GV$PX_BUFFER_ADVICE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 STATISTIC                              VARCHAR2(30)

 VALUE                                  NUMBER

 

GV$PX_PROCESS: Synonym for GV_$PX_PROCESS

 

iSelfSchooling-SQL> desc GV$PX_PROCESS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SERVER_NAME                            VARCHAR2(4)

 STATUS                                 VARCHAR2(9)

 PID                                    NUMBER

 SPID                                   VARCHAR2(12)

 SID                                    NUMBER

 SERIAL#                                NUMBER

 

GV$PX_PROCESS_SYSSTAT: Synonym for GV_$PX_PROCESS_SYSSTAT

 

iSelfSchooling-SQL> desc GV$PX_PROCESS_SYSSTAT;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 STATISTIC                              VARCHAR2(30)

 VALUE                                  NUMBER

 

GV$PX_SESSION: Synonym for GV_$PX_SESSION

 

iSelfSchooling-SQL> desc GV$PX_SESSION;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SADDR                                  RAW(8)

 SID                                    NUMBER

 SERIAL#                                NUMBER

 QCSID                                  NUMBER

 QCSERIAL#                              NUMBER

 QCINST_ID                              NUMBER

 SERVER_GROUP                           NUMBER

 SERVER_SET                             NUMBER

 SERVER#                                NUMBER

 DEGREE                                 NUMBER

 REQ_DEGREE                             NUMBER

 

GV$PX_SESSTAT: Synonym for GV_$PX_SESSTAT

 

iSelfSchooling-SQL> desc GV$PX_SESSTAT;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SADDR                                  RAW(8)

 SID                                    NUMBER

 SERIAL#                                NUMBER

 QCSID                                  NUMBER

 QCSERIAL#                              NUMBER

 QCINST_ID                              NUMBER

 SERVER_GROUP                           NUMBER

 SERVER_SET                             NUMBER

 SERVER#                                NUMBER

 DEGREE                                 NUMBER

 REQ_DEGREE                             NUMBER

 STATISTIC#                             NUMBER

 VALUE                                  NUMBER

 

GV$QUEUE: Synonym for GV_$QUEUE

 

iSelfSchooling-SQL> desc GV$QUEUE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 PADDR                                  RAW(8)

 TYPE                                   VARCHAR2(10)

 QUEUED                                 NUMBER

 WAIT                                   NUMBER

 TOTALQ                                 NUMBER

 

GV$QUEUEING_MTH: Synonym for GV_$QUEUEING_MTH

 

iSelfSchooling-SQL> desc GV$QUEUEING_MTH;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 NAME                                   VARCHAR2(40)

 

GV$RECOVERY_FILE_STATUS: Synonym for GV_$RECOVERY_FILE_STATUS

 

iSelfSchooling-SQL> desc GV$RECOVERY_FILE_STATUS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 FILENUM                                NUMBER

 FILENAME                               VARCHAR2(513)

 STATUS                                 VARCHAR2(13)

 

GV$RECOVERY_LOG: Synonym for GV_$RECOVERY_LOG

 

iSelfSchooling-SQL> desc GV$RECOVERY_LOG;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 TIME                                   DATE

 ARCHIVE_NAME                           VARCHAR2(513)

 

GV$RECOVERY_PROGRESS: Synonym for GV_$RECOVERY_PROGRESS

 

iSelfSchooling-SQL> desc GV$RECOVERY_PROGRESS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 START_TIME                             DATE

 TYPE                                   VARCHAR2(64)

 ITEM                                   VARCHAR2(32)

 UNITS                                  VARCHAR2(32)

 SOFAR                                  NUMBER

 TOTAL                                  NUMBER

 TIMESTAMP                              DATE

 

GV$RECOVERY_STATUS: Synonym for GV_$RECOVERY_STATUS

 

iSelfSchooling-SQL> desc GV$RECOVERY_STATUS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RECOVERY_CHECKPOINT                    DATE

 THREAD                                 NUMBER

 SEQUENCE_NEEDED                        NUMBER

 SCN_NEEDED                             VARCHAR2(16)

 TIME_NEEDED                            DATE

 PREVIOUS_LOG_NAME                      VARCHAR2(513)

 PREVIOUS_LOG_STATUS                    VARCHAR2(13)

 REASON                                 VARCHAR2(13)

 

GV$RECOVER_FILE: Synonym for GV_$RECOVER_FILE

 

iSelfSchooling-SQL> desc GV$RECOVER_FILE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 FILE#                                  NUMBER

 ONLINE                                 VARCHAR2(7)

 ONLINE_STATUS                          VARCHAR2(7)

 ERROR                                  VARCHAR2(18)

 CHANGE#                                NUMBER

 TIME                                   DATE

 

GV$REPLPROP: Synonym for GV_$REPLPROP

 

iSelfSchooling-SQL> desc GV$REPLPROP;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SID                                    NUMBER

 SERIAL#                                NUMBER

 NAME                                   VARCHAR2(71)

 DBLINK                                 VARCHAR2(128)

 STATE                                  VARCHAR2(12)

 XID                                    VARCHAR2(22)

 SEQUENCE                               NUMBER

 

GV$REPLQUEUE: Synonym for GV_$REPLQUEUE

 

iSelfSchooling-SQL> desc GV$REPLQUEUE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 TXNS_ENQUEUED                          NUMBER

 CALLS_ENQUEUED                         NUMBER

 TXNS_PURGED                            NUMBER

 LAST_ENQUEUE_TIME                      DATE

 LAST_PURGE_TIME                        DATE

 

GV$REQDIST: Synonym for GV_$REQDIST

 

iSelfSchooling-SQL> desc GV$REQDIST;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 BUCKET                                 NUMBER

 COUNT                                  NUMBER

 

GV$RESERVED_WORDS: Synonym for GV_$RESERVED_WORDS

 

iSelfSchooling-SQL> desc GV$RESERVED_WORDS;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 KEYWORD                                VARCHAR2(30)

 LENGTH                                 NUMBER

 RESERVED                               VARCHAR2(1)

 RES_TYPE                               VARCHAR2(1)

 RES_ATTR                               VARCHAR2(1)

 RES_SEMI                               VARCHAR2(1)

 DUPLICATE                              VARCHAR2(1)

 

GV$RESOURCE: Synonym for GV_$RESOURCE

 

iSelfSchooling-SQL> desc GV$RESOURCE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 ADDR                                   RAW(8)

 TYPE                                   VARCHAR2(2)

 ID1                                    NUMBER

 ID2                                    NUMBER

 

GV$RESOURCE_LIMIT: Synonym for GV_$RESOURCE_LIMIT

 

iSelfSchooling-SQL> desc GV$RESOURCE_LIMIT;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 RESOURCE_NAME                          VARCHAR2(30)

 CURRENT_UTILIZATION                    NUMBER

 MAX_UTILIZATION                        NUMBER

 INITIAL_ALLOCATION                     VARCHAR2(10)

 LIMIT_VALUE                            VARCHAR2(10)

 

GV$RESTORE_POINT: Synonym for GV_$RESTORE_POINT

 

iSelfSchooling-SQL> desc GV$RESTORE_POINT;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SCN                                    NUMBER

 DATABASE_INCARNATION#                  NUMBER

 GUARANTEE_FLASHBACK_DATABASE           VARCHAR2(3)

 STORAGE_SIZE                           NUMBER

 TIME                                   TIMESTAMP(9)

 NAME                                   VARCHAR2(128)

 

GV$RESUMABLE: Synonym for GV_$RESUMABLE

 

iSelfSchooling-SQL> desc GV$RESUMABLE;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 ADDR                                   RAW(8)

 SID                                    NUMBER

 ENABLED                                VARCHAR2(3)

 STATUS                                 VARCHAR2(9)

 TIMEOUT                                NUMBER

 SUSPEND_TIME                           VARCHAR2(20)

 RESUME_TIME                            VARCHAR2(20)

 NAME                                   VARCHAR2(4000)

 ERROR_NUMBER                           NUMBER

 ERROR_PARAMETER1                       VARCHAR2(80)

 ERROR_PARAMETER2                       VARCHAR2(80)

 ERROR_PARAMETER3                       VARCHAR2(80)

 ERROR_PARAMETER4                       VARCHAR2(80)

 ERROR_PARAMETER5                       VARCHAR2(80)

 ERROR_MSG                              VARCHAR2(4000)

 

GV$RFS_THREAD: Synonym for GV_$RFS_THREAD

 

iSelfSchooling-SQL> desc GV$RFS_THREAD;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 THREAD#                                NUMBER

 RESETLOGS_CHANGE#                      NUMBER

 RESET_TIMESTAMP                        NUMBER

 LAST_REDO_SEQ#                         NUMBER

 LAST_REDO_BLK#                         NUMBER

 LAST_REDO_TIME                         DATE

 LOW_GAP_SCN                            NUMBER

 LOW_GAP_TIME                           DATE

 LAST_PING_TIME                         DATE

 

GV$RMAN_CONFIGURATION: Synonym for GV_$RMAN_CONFIGURATION

 

iSelfSchooling-SQL> desc GV$RMAN_CONFIGURATION;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 CONF#                                  NUMBER

 NAME                                   VARCHAR2(65)

 VALUE                                  VARCHAR2(1025)

 

GV$RMAN_OUTPUT: Synonym for GV_$RMAN_OUTPUT

 

iSelfSchooling-SQL> desc GV$RMAN_OUTPUT;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 SID                                    NUMBER

 RECID                                  NUMBER

 STAMP                                  NUMBER

 SESSION_RECID                          NUMBER

 SESSION_STAMP                          NUMBER

 OUTPUT                                 VARCHAR2(130)

 RMAN_STATUS_RECID                      NUMBER

 RMAN_STATUS_STAMP                      NUMBER

 

GV$ROLLSTAT: Synonym for GV_$ROLLSTAT

 

iSelfSchooling-SQL> desc GV$ROLLSTAT;

 Name                          Null?    Type

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

 INST_ID                                NUMBER

 USN                                    NUMBER

 LATCH                                  NUMBER

 EXTENTS                                NUMBER

 RSSIZE                                 NUMBER

 WRITES                                 NUMBER

 XACTS                                  NUMBER

 GETS                                   NUMBER

 WAITS                                  NUMBER

 OPTSIZE                                NUMBER

 HWMSIZE                                NUMBER

 SHRINKS                                NUMBER

 WRAPS                                  NUMBER

 EXTENDS                                NUMBER

 AVESHRINK                              NUMBER

 AVEACTIVE                              NUMBER

 STATUS                                 VARCHAR2(15)

 CUREXT                                 NUMBER

 CURBLK                                 NUMBER

 

 

 

Google
 
Web web site