Advanced Queues

2001-09-07 Thread ARUN K C

Hi All,
Is Anybody using Advanced Queues of oracle,If yes, can u share if's and 
dont's of this product, Is it really worth to go into this product.
We are planning to implement this on the middleware level.
THANKS


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ARUN K C
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



Advanced Queues

2001-08-03 Thread David Turner


I just started looking into Advanced Queues and I'm wondering what types
of apps they're used for? What would be their biggest advantage?

Dave Turner 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Turner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



RE: Advanced Queues

2001-08-03 Thread Raymond Lee Meng Hong

SET ORACLE-L DIGEST 

-Original Message-
Sent: Friday, August 03, 2001 6:52 AM
To: Multiple recipients of list ORACLE-L



I just started looking into Advanced Queues and I'm wondering what types
of apps they're used for? What would be their biggest advantage?

Dave Turner 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Turner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Raymond Lee Meng Hong
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



Advanced Queues for dummies

2002-09-25 Thread Reardon, Bruce (CALBBAY)

Hi,

We're investigating the use of Advanced Queues as a way of transferring information 
between OSI's PI and Oracle.
The data will originate on the Oracle side and end up in PI.

We were thinking of using Oracle's Heterogeneous services and PI's ODBC driver, but 
ran into 2 phase commit errors (how do you tell a commit not be a 2-phase commit) and 
problems (ie not supported until 9iR2) with autonomous transactions and database links.

We're using Oracle 81714 (soon to be 81745) on Windows.

Having not used Advanced Queues before, I will look at the manuals, but is their a 
site or book on Advanced Queues for dummies (otherwise known as Intro to Advanced 
Queues in Oracle).

For those who 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?
- Who normally owns the queues and queue tables - system or the application schema.

Any suggestions, links or books would be appreciated.

Thanks,
Bruce Reardon
mailto:[EMAIL PROTECTED]
--
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).