ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$BACKUP_ASYNC_IO: Synonym for V_$BACKUP_ASYNC_IO
iSelfSchooling-SQL> desc V$BACKUP_ASYNC_IO;
Name
Null? Type
----------------------------- -------- --------------------
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
V$BACKUP_CONTROLFILE_DETAILS: Synonym for
V_$BACKUP_CONTROLFILE_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_CONTROLFILE_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
BTYPE
CHAR(9)
BTYPE_KEY
NUMBER
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
ID1
NUMBER
ID2
NUMBER
CREATION_TIME
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
FILESIZE
NUMBER
COMPRESSION_RATIO
NUMBER
FILESIZE_DISPLAY
VARCHAR2(4000)
V$BACKUP_CONTROLFILE_SUMMARY: Synonym for
V_$BACKUP_CONTROLFILE_SUMMARY
iSelfSchooling-SQL> desc V$BACKUP_CONTROLFILE_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
NUM_FILES_BACKED
NUMBER
NUM_DISTINCT_FILES_BACKED
NUMBER
MIN_CHECKPOINT_CHANGE#
NUMBER
MAX_CHECKPOINT_CHANGE#
NUMBER
MIN_CHECKPOINT_TIME
DATE
MAX_CHECKPOINT_TIME
DATE
INPUT_BYTES
NUMBER
OUTPUT_BYTES
NUMBER
COMPRESSION_RATIO
NUMBER
INPUT_BYTES_DISPLAY
VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_COPY_DETAILS: Synonym for V_$BACKUP_COPY_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_COPY_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
COPY_KEY
NUMBER
FILE#
NUMBER
NAME
VARCHAR2(513)
TAG
VARCHAR2(32)
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
MARKED_CORRUPT
NUMBER
OUTPUT_BYTES
NUMBER
COMPLETION_TIME
DATE
CONTROLFILE_TYPE
VARCHAR2(1)
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(10)
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_COPY_SUMMARY: Synonym for V_$BACKUP_COPY_SUMMARY
iSelfSchooling-SQL> desc V$BACKUP_COPY_SUMMARY;
Name
Null?
Type
----------------------------- -------- --------------------
NUM_COPIES
NUMBER
NUM_DISTINCT_COPIES
NUMBER
MIN_CHECKPOINT_CHANGE#
NUMBER
MAX_CHECKPOINT_CHANGE#
NUMBER
MIN_CHECKPOINT_TIME
DATE
MAX_CHECKPOINT_TIME
DATE
OUTPUT_BYTES
NUMBER
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_CORRUPTION: Synonym for V_$BACKUP_CORRUPTION
iSelfSchooling-SQL> desc V$BACKUP_CORRUPTION;
Name
Null? Type
----------------------------- -------- --------------------
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)
V$BACKUP_DATAFILE: Synonym for V_$BACKUP_DATAFILE
iSelfSchooling-SQL> desc V$BACKUP_DATAFILE;
Name
Null? Type
----------------------------- -------- --------------------
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)
V$BACKUP_DATAFILE_DETAILS: Synonym for V_$BACKUP_DATAFILE_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_DATAFILE_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
BTYPE
CHAR(9)
BTYPE_KEY
NUMBER
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
ID1
NUMBER
ID2
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
MARKED_CORRUPT
NUMBER
FILESIZE
NUMBER
COMPRESSION_RATIO
NUMBER
TS#
NUMBER
TSNAME
VARCHAR2(30)
FILESIZE_DISPLAY
VARCHAR2(4000)
V$BACKUP_DATAFILE_SUMMARY: Synonym for V_$BACKUP_DATAFILE_SUMMARY
iSelfSchooling-SQL> desc V$BACKUP_DATAFILE_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
NUM_FILES_BACKED
NUMBER
NUM_DISTINCT_FILES_BACKED
NUMBER
NUM_DISTINCT_TS_BACKED
NUMBER
MIN_CHECKPOINT_CHANGE#
NUMBER
MAX_CHECKPOINT_CHANGE#
NUMBER
MIN_CHECKPOINT_TIME
DATE
MAX_CHECKPOINT_TIME
DATE
INPUT_BYTES
NUMBER
OUTPUT_BYTES
NUMBER
COMPRESSION_RATIO
NUMBER
INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_DEVICE: Synonym for V_$BACKUP_DEVICE
iSelfSchooling-SQL> desc V$BACKUP_DEVICE;
Name
Null? Type
----------------------------- -------- --------------------
DEVICE_TYPE
VARCHAR2(17)
DEVICE_NAME
VARCHAR2(513)
V$BACKUP_FILES: Synonym for V_$BACKUP_FILES
iSelfSchooling-SQL> desc V$BACKUP_FILES;
Name
Null? Type
----------------------------- -------- --------------------
PKEY
NUMBER
BACKUP_TYPE
VARCHAR2(32)
FILE_TYPE
VARCHAR2(32)
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(13)
STATUS
VARCHAR2(16)
FNAME
VARCHAR2(1024)
TAG
VARCHAR2(32)
MEDIA
VARCHAR2(80)
RECID
NUMBER
STAMP
NUMBER
DEVICE_TYPE
VARCHAR2(255)
BLOCK_SIZE
NUMBER
COMPLETION_TIME
DATE
COMPRESSED
VARCHAR2(3)
OBSOLETE
VARCHAR2(3)
BYTES
NUMBER
BS_KEY
NUMBER
BS_COUNT
NUMBER
BS_STAMP
NUMBER
BS_TYPE
VARCHAR2(32)
BS_INCR_TYPE
VARCHAR2(32)
BS_PIECES
NUMBER
BS_COPIES
NUMBER
BS_COMPLETION_TIME
DATE
BS_STATUS
VARCHAR2(16)
BS_BYTES
NUMBER
BS_COMPRESSED
VARCHAR2(3)
BS_TAG
VARCHAR2(1024)
BS_DEVICE_TYPE
VARCHAR2(255)
BP_PIECE#
NUMBER
BP_COPY#
NUMBER
DF_FILE#
NUMBER
DF_TABLESPACE
VARCHAR2(30)
DF_RESETLOGS_CHANGE#
NUMBER
DF_CREATION_CHANGE#
NUMBER
DF_CHECKPOINT_CHANGE#
NUMBER
DF_CKP_MOD_TIME
DATE
RL_THREAD#
NUMBER
RL_SEQUENCE#
NUMBER
RL_RESETLOGS_CHANGE#
NUMBER
RL_FIRST_CHANGE#
NUMBER
RL_FIRST_TIME
DATE
RL_NEXT_CHANGE#
NUMBER
RL_NEXT_TIME
DATE
V$BACKUP_PIECE: Synonym for V_$BACKUP_PIECE
iSelfSchooling-SQL> desc V$BACKUP_PIECE;
Name
Null? Type
----------------------------- -------- --------------------
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)
START_TIME
DATE
COMPLETION_TIME
DATE
ELAPSED_SECONDS
NUMBER
DELETED
VARCHAR2(3)
BYTES
NUMBER
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
COMPRESSED
VARCHAR2(3)
V$BACKUP_PIECE_DETAILS: Synonym for V_$BACKUP_PIECE_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_PIECE_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
BS_KEY
NUMBER
BP_KEY
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)
START_TIME
DATE
COMPLETION_TIME
DATE
ELAPSED_SECONDS
NUMBER
DELETED
VARCHAR2(3)
BYTES
NUMBER
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
COMPRESSED
VARCHAR2(3)
PIECES_PER_SET
NUMBER
SIZE_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_REDOLOG: Synonym for V_$BACKUP_REDOLOG
iSelfSchooling-SQL> desc V$BACKUP_REDOLOG;
Name
Null? Type
----------------------------- -------- --------------------
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
V$BACKUP_SET: Synonym for V_$BACKUP_SET
iSelfSchooling-SQL> desc V$BACKUP_SET;
Name
Null? Type
----------------------------- -------- --------------------
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)
V$BACKUP_SET_DETAILS: Synonym for V_$BACKUP_SET_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_SET_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
BS_KEY
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
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(10)
DEVICE_TYPE
VARCHAR2(17)
COMPRESSED
VARCHAR2(3)
NUM_COPIES
NUMBER
OUTPUT_BYTES
NUMBER
ORIGINAL_INPUT_BYTES
NUMBER
COMPRESSION_RATIO
NUMBER
STATUS
CHAR(1)
ORIGINAL_INPRATE_BYTES
NUMBER
OUTPUT_RATE_BYTES
NUMBER
ORIGINAL_INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
ORIGINAL_INPRATE_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_RATE_BYTES_DISPLAY
VARCHAR2(4000)
TIME_TAKEN_DISPLAY
VARCHAR2(4000)
V$BACKUP_SET_SUMMARY: Synonym for V_$BACKUP_SET_SUMMARY
iSelfSchooling-SQL> desc V$BACKUP_SET_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
NUM_BACKUPSETS
NUMBER
OLDEST_BACKUP_TIME
DATE
NEWEST_BACKUP_TIME
DATE
OUTPUT_BYTES
NUMBER
ORIGINAL_INPUT_BYTES
NUMBER
ORIGINAL_INPRATE_BYTES
NUMBER
OUTPUT_RATE_BYTES
NUMBER
COMPRESSION_RATIO
NUMBER
ORIGINAL_INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
ORIGINAL_INPRATE_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_RATE_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_SPFILE: Synonym for V_$BACKUP_SPFILE
iSelfSchooling-SQL> desc V$BACKUP_SPFILE;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
SET_STAMP
NUMBER
SET_COUNT
NUMBER
MODIFICATION_TIME
DATE
BYTES
NUMBER
COMPLETION_TIME
DATE
V$BACKUP_SPFILE_DETAILS: Synonym for V_$BACKUP_SPFILE_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_SPFILE_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
BS_KEY
NUMBER
SET_STAMP
NUMBER
SET_COUNT
NUMBER
MODIFICATION_TIME
DATE
FILESIZE
NUMBER
FILESIZE_DISPLAY
VARCHAR2(4000)
V$BACKUP_SPFILE_SUMMARY: Synonym for V_$BACKUP_SPFILE_SUMMARY
iSelfSchooling-SQL> desc V$BACKUP_SPFILE_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
NUM_FILES_BACKED
NUMBER
NUM_DISTINCT_FILES_BACKED NUMBER
MIN_MODIFICATION_TIME
DATE
MAX_MODIFICATION_TIME
DATE
INPUT_BYTES
NUMBER
INPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_SYNC_IO: Synonym for V_$BACKUP_SYNC_IO
iSelfSchooling-SQL> desc V$BACKUP_SYNC_IO;
Name
Null? Type
----------------------------- -------- --------------------
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
V$BGPROCESS: Synonym for V_$BGPROCESS
iSelfSchooling-SQL> desc V$BGPROCESS;
Name
Null? Type
----------------------------- -------- --------------------
PADDR
RAW(8)
PSERIAL#
NUMBER
NAME
VARCHAR2(5)
DESCRIPTION
VARCHAR2(64)
ERROR
NUMBER
V$BH: Synonym for V_$BH
iSelfSchooling-SQL> desc V$BH;
Name
Null?
Type
----------------------------- -------- --------------------
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
V$BLOCKING_QUIESCE: Synonym for V_$BLOCKING_QUIESCE
iSelfSchooling-SQL> desc V$BLOCKING_QUIESCE;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
V$BLOCK_CHANGE_TRACKING: Synonym for V_$BLOCK_CHANGE_TRACKING
iSelfSchooling-SQL> desc V$BLOCK_CHANGE_TRACKING;
Name
Null? Type
----------------------------- -------- --------------------
STATUS
VARCHAR2(10)
FILENAME
VARCHAR2(513)
BYTES
NUMBER
V$BSP: Synonym for V_$BSP
iSelfSchooling-SQL> desc V$BSP;
Name
Null? Type
----------------------------- -------- --------------------
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
V$BUFFERED_PUBLISHERS: Synonym for V_$BUFFERED_PUBLISHERS
iSelfSchooling-SQL> desc V$BUFFERED_PUBLISHERS;
Name
Null? Type
----------------------------- -------- --------------------
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)
V$BUFFERED_QUEUES: Synonym for V_$BUFFERED_QUEUES
iSelfSchooling-SQL> desc V$BUFFERED_QUEUES;
Name
Null? Type
----------------------------- -------- --------------------
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
|