Re: high avg read time for "temporary tablespace"
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: mark.powell@xxxxxxx
- Date: Fri, 10 Feb 2006 16:32:00 -0500
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@xxxxxxx> 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 --
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
