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 Received on Thu Feb 09 2006 - 16:43:27 CST