Bruce, We used to use queues in 8.1.6 on Solaris. Don't remember much about them except that they were, at that time, unreliable. We'd have push/pulls jobs that would run extract and transformation routines from multiple databases into a reporting DW.
We finally switched over to Informatica because of the unreliabilty of the queues. As for seperate queue tables, don't remember. I believe the queues were owned by the application schema since I remember looking for stopped jobs in user_jobs as the application owner. mkb --- [EMAIL PROTECTED] wrote: > Bruce, > > No we don't use advanced queuing here. Don't > have the time to figure out > how to make it work. > > Dick Goulet > > ____________________Reply > Separator____________________ > Author: "Reardon; Bruce (CALBBAY)" > <[EMAIL PROTECTED]> > Date: 10/29/2002 10:58 PM > > Hi, > > I've sent a couple of questions on queues and got no > answers - that's fine and I > understand we're all busy. > > What I'm wondering though is whether anyone is > actually using Oracle queues at > all? > > Any feedback would be appreciated. > > For anyone out there who does use Advanced queues: > one of our developers read that "Creating a queue > table in a tablespace will > disable that particular tablespace for point-in-time > recovery". > > - Do you normally put your AQ tables in a separate > tablespace (we're currently > looking at doing just that)? > - Who normally owns the queues and queue tables - > system or the application > schema. > > Thanks, > Bruce Reardon > mailto:bruce.reardon@;comalco.riotinto.com.au > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Reardon, Bruce (CALBBAY) > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).