RE: direct path read waits

Tablespace C is on the I/O path as TEMP tablespace maybe???

> -----Original Message-----
> From: babu.nagarajan_at_cummins.com [mailto:babu.nagarajan_at_cummins.com]
> Sent: Thursday, February 20, 2003 1:41 PM
> 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: babu.nagarajan_at_Cummins.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.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).