Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bitmap indexes - clarification
A copy of this was sent to Ian Jennings <ij_at_microware.demon.co.uk>
(if that email address didn't require changing)
On Tue, 30 Jun 1998 08:33:07 +0100, you wrote:
>Hi all,
>
[snip]
>
>I get the good old 00901 error when I try and create my indexes. Now
>I've seen lots of replies to posts on that message and lots of FAQs. So
>far I've only managed to get more confused as I go. I am running 7.3.3
>on an NT4 box with a single CPU.
>
>One thing in common with everything I've read is that <compatible =
>7.3.2.0.0> (or better) must be set. As I am running 7.3.3 should that be
>in there?
>
>After that it all goes to pot. Some posts say that the parallel query
>option must be set, others say it isn't necessary. Which is correct?
>
PQO must be installed to get bitmapped indexing. Thats a fact.
>Another problem is how to set it if it is necessary. So far I've seen:
>
>event = "10111 trace name context forever"
>event = "10112 trace name context forever"
>event = "10224 trace name context forever"
>
do not do that, those events enabled a pre-beta version of bitmapped indexing and may be wholely unreliable.
>as being the advised way to do it and I've seen:
>
>PARALLEL_MIN_SERVERS
> PARALLEL_MAX_SERVERS
> etc.
that won't do it.
>
>as being correct. Which is right? If it's the second way then do I enter
>'1' for both values. I realise that it's processes not actual processors
>for parallel queries (or so several of the posts said) but it all seems
>a bit grey.
>
just make sure that the sqlplus banner has:
With the distributed, replication, parallel query and Spatial Data option ^^^^^^^^^^^^^^
in it...
>Apologies if I seem a bit thick but things appear to be a little vague.
>Any assistance will be much appreciated.
>
>TIA
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jun 30 1998 - 08:55:15 CDT