OraFAQ Forum: Streams & AQ » Streams: why the messages always spill into the queue table?

Home » Server Options » Streams & AQ » Streams: why the messages always spill into the queue table?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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!

Report message to a moderator

Previous Topic:	AQ to MQ
Next Topic:	Using SQL statement to browse OJMS queue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 12:26:09 CST 2024