RE: high avg read time for "temporary tablespace"

 Hash joins may also require space in the temporary tablespace. What is the value of the SEGTYPE column in v$sort_usage?

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sami Seerangan Sent: Friday, February 10, 2006 11:32 AM To: Roger Xu
Cc: oracle-l
Subject: 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


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