| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Bitmap Indexes (again)
By putting the events in, you enabled ALPHA code in the kernel. Events are trace flags for the kernel, they are switches that turn things on and off. They are in general undocumented.
The production version of bitmap indexes are enabled in 7.3.2.3 by having
With the distributed, replication, parallel query and Spatial Data options
The ALPHA feature you enabled is not the same code as the code enabled by the above steps. The ALPHA code was for testing only. Alpha code is Alpha code, I would not want Alpha level code running in my production database (hence the caveat to NOT use that in a production database, only in a test instance).
On Thu, 14 Aug 1997 11:56:20 -0400, Don Bowles <dbowles_at_praca.ksc.nasa.gov> wrote:
>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
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |