while rebuilding indexes i gave parrallel 2 . But I see there are
four ora_p00 processes . ???
-ak
but you have probably 2 CPU-us
mac
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: mac
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
oramagic.
parallel_clause
Use the PARALLEL clause to change the default degree of
parallelism for queries and DML on the index.
Restriction: You cannot specify this
clause for an index on a temporary table.
Note:
The syntax of the parallel_clause
2 producers
2 consumers
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 8:44
PMTo: Multiple recipients of list ORACLE-LSubject:
parallel processes
while rebuilding indexes i gave parrallel 2 . But
I see there are four ora_p00
Been like that since Oracle v7.1.3.
For the short answer -
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c22paral.htm#3166
But I think it's time for a little reading -
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c22paral.htm