Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to enable AQ?

Re: How to enable AQ?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 10 Feb 2004 09:03:55 -0800
Message-ID: <1076432585.934596@yasure>


Niall Litchfield 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;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Release 9.2.0.2.1 - Production
> PL/SQL Release 9.2.0.2.1 - Production
> CORE 9.2.0.2.0 Production
> TNS for 32-bit Windows: Version 9.2.0.2.0 - Production
> NLSRTL Version 9.2.0.2.0 - Production
>
> SQL> select * from v$option;
>
> PARAMETER VALUE
> ---------------------------------------------------------------- -----------
> ---------
> Partitioning FALSE
> Objects TRUE
> Real Application Clusters FALSE
> Advanced replication FALSE
> Bit-mapped indexes FALSE
> Connection multiplexing TRUE
> Connection pooling TRUE
> Database queuing TRUE
> Incremental backup and recovery FALSE
> Instead-of triggers TRUE
> Parallel backup and recovery FALSE
> Parallel execution FALSE
> Parallel load TRUE
> Point-in-time tablespace recovery FALSE
> Fine-grained access control FALSE
> Proxy authentication/authorization TRUE
> Change Data Capture FALSE
> Plan Stability TRUE
> Online Index Build FALSE
> Coalesce Index FALSE
> Managed Standby FALSE
> Materialized view rewrite FALSE
> Materialized view warehouse refresh FALSE
> Database resource manager FALSE
> Spatial FALSE
> Visual Information Retrieval FALSE
> Export transportable tablespaces FALSE
> Transparent Application Failover FALSE
> Fast-Start Fault Recovery FALSE
> Sample Scan TRUE
> Duplexed backups FALSE
> Java TRUE
> OLAP Window Functions TRUE
> Block Media Recovery FALSE
> Fine-grained Auditing FALSE
> Application Role FALSE
> Enterprise User Security FALSE
> Oracle Data Guard FALSE
> Oracle Label Security FALSE
> OLAP FALSE
> Heap segment compression FALSE
> Join index FALSE
> Trial Recovery FALSE
> Oracle Data Mining FALSE
> Online Redefinition FALSE
> Streams FALSE
> File Mapping FALSE
>
> which suggests that the docs are wrong.

Please allow me the luxury here of playing at working for Oracle Support.

Patch to 9.2.0.4. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Feb 10 2004 - 11:03:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US