In the above statement, sender_name
shows the Capture Process and the sender_address shows
This view displays information about all
buffered queues in the instance. There is one row per queue. It
shows statistics such as LCR in memory and spilled LCRs. The
user’s goal should be to control spilled LCRs. Spilled LCR
events are written in a physical table where they may have
performance impact on Streams processing
COLUMN QUEUE_SCHEMA HEADING 'Queue Owner'
COLUMN QUEUE_NAME HEADING 'Queue Name'
COLUMN MEM_MSG HEADING 'LCRs in Memory'
COLUMN SPILL_MSGS HEADING 'Spilled LCRs'
COLUMN NUM_MSGS HEADING 'Total Captured
LCRs|in Buffered Queue' FORMAT 99999999