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... | 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