Re: high avg read time for "temporary tablespace"

Mark,thanks for your response.

segtype show LOB_DATA though there is no LOB involved in the query objects.

SQL> select segtype,count(*) from gv$sort_usage group by segtype;

SEGTYPE COUNT(*)
--------- ----------
LOB_DATA 209 On 2/10/06, Powell, Mark D <mark.powell_at_eds.com> wrote:
> 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 --
>

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