Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: parallel query
If your server has multiple cpu's parallel query can be used to distribute
the query between the multiple cpu's.
Oracle will not automatically use parallel query. This depends on
- the feature being installed (not ALL flavors of Oracle have it, check this
by select * from v$option)
- either init.ora parameters - or settings on table level - or settings on statement level
Hth,
--
Sybrand Bakker, Oracle DBA
My Name <spring13_at_earthlink.net> wrote in message
news:383B2E4C.837CD020_at_earthlink.net...
> Hi,
> Can you tell me what does Parallel query mean?
> and how can I tell if my database is using parallel query?
>
> thank you
>
>
Received on Tue Nov 23 1999 - 23:33:13 CST