Your answer was buried in the question itself. If the TEMP tablespace had to contend with Tablespace C on the same 'disk' then such a result is expected.
John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 20, 2003 11:41 AM > To: Multiple recipients of list ORACLE-L > Subject: direct path read waits > > > All > > We are doing some performance testing while moving from one server to > another. I was trying to time some index rebuilds and noticed > something > that I cant explain. > > I am rebuilding an index on a 1 million row table. Lets say its on > tablespace A and when I rebuild it to tablespace B it does in > 33 seconds. I > put it back on A and then rebuild it on tablespace C it takes 1 min 40 > seconds. The only change here is the target tablespace. > > When I set 10046 level 12 and counted time waited (ela column) > > From A - B (33 seconds) > > sum of elapsed in "DIRECT PATH READ" = 394 ( i think this is cs) > > From A - C (1 min 40 sec) > > sum of elapsed in "DIRECT PATH READ" = 6251 > > The P1 of all of these waits point to the same file (#4 part of TEMP > tablespace) > > Why should the change in the target tablespace affect the > time taken to > read from the TEMP tablespace? > > TIA > > Babu > > _____________ > This e-mail transmission and any attachments to it are > intended solely for > the use of the individual or entity to whom it is addressed > and may contain > confidential and privileged information. If you are not the intended > recipient, your use, forwarding, printing, storing, disseminating, > distribution, or copying of this communication is prohibited. If you > received this communication in error, please notify the > sender immediately > by replying to this message and delete it from your computer. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: John Kanagaraj INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
