Home » Server Options » Streams & AQ » Streams: why the messages always spill into the queue table?
Streams: why the messages always spill into the queue table? [message #164774] Sat, 25 March 2006 21:58
Teddyboy
Messages: 8
Registered: September 2005
Junior Member
SQL> --Determining the Number of Messages in Each Buffered Queue
SQL> COLUMN QUEUE_SCHEMA HEADING 'Queue Owner' FORMAT A15
SQL> COLUMN QUEUE_NAME HEADING 'Queue Name' FORMAT A20
SQL> COLUMN MEM_MSG HEADING 'Messages|in Memory' FORMAT 99999999
SQL> COLUMN SPILL_MSGS HEADING 'Messages|Spilled' FORMAT 99999999
SQL> COLUMN NUM_MSGS HEADING 'Total Messages|in Buffered Queue' FORMAT 99999999
SQL> SELECT QUEUE_SCHEMA,
2 QUEUE_NAME,
3 (NUM_MSGS - SPILL_MSGS) MEM_MSG,
4 SPILL_MSGS,
5 NUM_MSGS
6 FROM V$BUFFERED_QUEUES;

Messages Messages Total Messages
Queue Owner Queue Name in Memory Spilled in Buffered Queue
--------------- -------------------- --------- --------- -----------------
STRMADMIN QUE_CAPTURE_BJDB 0 202680 202680

Elapsed: 00:00:00.00


i didn't set streams_pool_size, but set sga_target to 10g.
database version: 10.2.0.1
any advice will be welcome, thanks all!
Previous Topic: AQ to MQ
Next Topic: Using SQL statement to browse OJMS queue
Goto Forum:
  


Current Time: Thu Mar 28 13:31:41 CDT 2024