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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxx 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@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: