Re: high avg read time for "temporary tablespace"

Roger,

Thanks for your response.
As I mentioned that there is no ORDER BY,DISTINCT ,UNION and group by,etc. I put a monitoring jobs on v$sort_usage to find out who (and what statement) uses extensive temp tablespace. let me check after sometime.
Thanks again.

On 2/9/06, Roger Xu <roger_xu_at_dp7uptx.com> wrote:
> 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.

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