Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: high avg read time for "temporary tablespace"

Re: high avg read time for "temporary tablespace"

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Fri, 10 Feb 2006 16:32:00 -0500
Message-ID: <f09dd6280602101331p415a8825xb1f3875a0b8d2ec9@mail.gmail.com>


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
Received on Fri Feb 10 2006 - 15:32:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US