Re: Advanced queueing and Oracle 9i standard engine

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 21 Feb 2005 12:50:15 +0000
Message-ID: <7765c89705022104508235e90@mail.gmail.com>

Ah lovely.

In the 10g Licensing Guide you'll see that Change Data Capture isn't available, but message queing and apply is.

Metalink Note 185049.1 will tell you that AQ is available from 9i SE, (and could sort of be used in 8i with products like Oracle Workflow).

The note is, apparently, correct

SQL>SELECT BANNER FROM V$VERSION; BANNER

---

Oracle9i Release 9.2.0.3.0 - Production
PL/SQL Release 9.2.0.3.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.3.0 - Production NLSRTL Version 9.2.0.3.0 - Production

5 rows selected.

SQL>SELECT * FROM V$OPTION WHERE PARAMETER = 'Database queuing';

PARAMETER

---

VALUE

---

Database queuing
TRUE Clear as mud then. Incidentally the metalink search that turned up the note (I knew it existed which was why I was brief ) also turned up a variety of different responses from Oracle Employees, not all of which are adeqauately explainable by the version the person posting the question was running.

On Mon, 21 Feb 2005 10:09:07 -0000, John Dunn <jdunn_at_sefas.com> wrote:
> Um..I'm confused
>
> The following document seems to say that it is NOT part of 9i standard
> edition
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96531/ch5_edit
> .htm
>
> -----Original Message-----
> From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
> Sent: 16 February 2005 20:42
> To: jdunn_at_sefas.com
> Cc: Oracle-L_at_freelists.org
> Subject: Re: Advanced queueing and Oracle 9i standard engine
>
> On Wed, 16 Feb 2005 14:27:50 -0000, John Dunn <jdunn_at_sefas.com> wrote:
> > Is AQ available in 9i Standard Engine...or only in Enterprise?
>
> Yes.
> --
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 21 2005 - 07:53:16 CST