RE: high avg read time for "temporary tablespace"

From: <oracle-l-bounce_at_freelists.org>
Date: Thu, 9 Feb 2006 17:11:14 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7095E6889@irv2kexch01.tx.bg.corp>

I meant it depends on the SQL statements either using a cursor or not.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Thursday, February 09, 2006 5:04 PM To: dba.orcl_at_gmail.com; oracle-l
Subject: RE: high avg read time for "temporary tablespace"

yes, cursor uses temp if the sql statements have ORDER BY,DISTINCT ,UNION and group by,etc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sami Seerangan Sent: Thursday, February 09, 2006 4:43 PM To: oracle-l
Subject: high avg read time for "temporary tablespace"

The statspack report shows "high Avg read time" (more than 10000 ms) for Temp tablespace. This is true only when particular batch job runs. The batch job is not doing any ORDER BY,DISTINCT ,UNION and group by,etc, however it uses many cursors.

My question is "does cursor will use temporary tablespace?"

                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)


-------------- ------- ------ ------- ------------ -------- ---------- ------

TEMP                     /u04/oradata/pnet1/temp01.dbf
             8       0    3.8     1.0           14        0          0
                         /u07/oradata/pnet1/temp02.dbf
            28       0 ######     4.0          128        0          0

Thanks
Sami
--

http://www.freelists.org/webpage/oracle-l

For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.
--

http://www.freelists.org/webpage/oracle-l

For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.