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
- dgoulet_at_vicr.com 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)"
> <Bruce.Reardon_at_comalco.riotinto.com.au>
> 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_at_comalco.riotinto.com.au
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Reardon, Bruce (CALBBAY)
> INET: Bruce.Reardon_at_comalco.riotinto.com.au
>
> 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).
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.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).
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: mkb125_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 Oct 30 2002 - 08:59:16 CST