Re: How to enable AQ?

On Tue, 10 Feb 2004 15:19:48 -0000, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>According to the docs it isn't available in std either in 9i.
>http://tinyurl.com/3ecnw.
>
>but, FWIW this is what we get
>
>SQL> select banner from v$version;

>Oracle9i Release 9.2.0.2.1 - Production
>
>SQL> select * from v$option;
>
>PARAMETER VALUE
>---------------------------------------------------------------- -----------
>Database queuing TRUE
>
>which suggests that the docs are wrong.

 Yep, they are. For the corrected list see Note:161556.1.

 Also available as a PDF on otn:
 http://otn.oracle.com/products/oracle9i/pdf/9idb_rel2_prod_fam.pdf

 Both have AQ in 9i Standard, also confirmed by Oracle in various places on Metalink.

-- 
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>