No other replies yet, so here goes.
First of all, what does it really mean when you say:
users are complaining that Precise is showing a whole lot of time in "Parallel Sync Wait".
Are these end users, or developers? Seems rather curious that users would be mentioning this.
Second, what % of wait time do the Sync Waits contribute to?
If a small % of total, then there's not much point in spending time on it.
Third, is this actually causing a performance problem, or is it just appearing
as a 'trouble' item on some monitor?
Jared
|
| mkline1@comcast.net
Sent by: ml-errors@fatcity.com
01/20/2004 11:29 AM
Please respond to ORACLE-L
|
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
cc:
Subject: 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@comcast.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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 - 17:49:44 CST
