question about AQ

From: Cole Zhai <cole_zhai_at_yahoo.com>
Date: Wed, 30 Apr 2003 01:41:44 -0800
Message-ID: <F001.0058C717.20030430014144@fatcity.com>

Hello,List
There're two question about AQ.My local queue have one enqueue and one dequeue process runing on same machine.My DB server have 4 CPUs.
First question:how can I enable parallel dequeue processes?Just start another dequeue process? I'm now using dbms_job to start a dequeue process:

SQL>exec dbms_job.submit(:jobnum,'p_dequeue;');

If I want to enable two parallel dequeue processes,just execute it again,right?

Second question:What's the best way to stop the background dequeue processes? I'm now using a signal table.Before every loop the dequeue procedure check the signal value to determine if it should stop.

Thanks advance!

---

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Cole Zhai
  INET: cole_zhai_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 30 2003 - 04:41:44 CDT