RE: high avg read time for "temporary tablespace"
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 10 Feb 2006 12:48:05 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxx> wrote:
> I meant it depends on the SQL statements either using a cursor or not.
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
> Sent: Thursday, February 09, 2006 5:04 PM
> To: dba.orcl@xxxxxxxxx; 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
