| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Parallel Query determined by?
I've inherited a system that has a whole lot of indexes set to degree 10 and many tables set to 2 & 4.
The users are complaining that Precise is showing a whole lot of time in "Parallel Sync Wait".
It is an HP box running 8.1.7.4 with 16 processors. The box is normally not very busy.
Are there various init.ora settings that help the Parallel servers sync up, or is this just too high a setting?
I'm suggesting we back of a good many of these things to simply 2 or 4 and then work our way up from there. Some of those indexes set to 10 are only 20 meg and 4 extents. There's no way they are getting 10 on that I would think.
Can't find a whole lot on Metalink either. Or a good book on 800 gig warehouses using parallel?
--
13308 Thornridge Ct
Midlothian, VA 23112
804-744-1545
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: mkline1_at_comcast.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 20 2004 - 13:29:35 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |