Re: How to enable AQ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 10 Feb 2004 15:19:48 -0000
Message-ID: <4028f697$0$10335$ed9e5944@reading.news.pipex.net>

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.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Andy Hassall" <andy_at_andyh.co.uk> wrote in message
news:95rh20pkecajqavme06mu3fdifp3v0utt1_at_4ax.com...


> On Tue, 10 Feb 2004 13:57:46 -0000, "Niall Litchfield"

> <n-litchfield_at_audit-commission.gov.uk> wrote:

>

> >AQ is, I believe, an Enterprise Edition only feature.

>

>  EE only in 8i, moved to Standard in 9i.

>

> -- 

> Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool

> <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

Received on Tue Feb 10 2004 - 09:19:48 CST