Re: Bitmap Indexes (again)

We did have to add the init.ora events on our 7.3.2.2 to get the bitmap indexes to work. We will be upgrading to 7.3.3. What are "events" in the parameter file and why is it not recommended to use them on a production database?

TIA Don

Thomas Kyte wrote:
>
> Bitmap indexes are production in release 7.3.2.3, and require the parallel
> query option. You should be able to create bitmap indexes without any special
> init.ora events (other than an appropriate COMPATIBILITY setting) with this
> release.
>
> I heard that the 'magic cookie' (the three init.ora events) enables an alpha
> version of bitmap indexes in earlier releases of 7.3.2. This pre-beta feature
> lacks the full functionality of 7.3.2.3's bitmap indexes, and is buggy. You
> will be much happier if you upgrade to 7.3.2.3 before using bitmap indexes.
>
> I strongly recommend against using the events, particularly in a production
> database.
>
> On Thu, 14 Aug 1997 03:25:45 GMT, rspies_at_minn.net (Rob Spies) wrote:
>
> >Pages 380-381 of Advanced Oracle Tuning and Administration from Oracle
> >Press states the following:
> >
> >To enable bitmap indexes in Oracle7.3.2, you should add the following
> >lines to your database's init.ora file:
> >
> >event = "10111 trace name context forever"
> >event = "10112 trace name context forever"
> >event = "10114 trace name context forever"
> >
> >
> >
> >Rob Spies
> >rspies_at_minn.net
> >
> >
> >---
> >"Andreas Hess" <ahess_at_truworths.co.za> wrote:
> >
> >>I'm getting a little frustrated with this wonderful feature...
 

> >>We were running Oracle 7.3.2.1.0 on AIX. Oracle informed
> >>us that bitmap indexes are only available from 7.3.2.2.
> >>( so close, yet so far).
 

> >>We upgraded to 7.3.2.3.0 (and yes, I did set compatible = 7.3.2.3.0).
 

> >>The moment of truth:
 

> >>CREATE BITMAP INDEX TEST ON TEST_TABLE(INDEX_COLUMN);
 
> >>ORA-00901: invalid CREATE command
 

> >>Let me guess - we need 7.3.2.3.1 ...?
 

> >>Any help will be appreciated - thanks...
 

> >>Andreas Hess
> >>Oracle DBA
> >
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government
> Bethesda MD
>
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Thu Aug 14 1997 - 00:00:00 CDT