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: direct path read/write temp waits

Re: direct path read/write temp waits

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 26 Apr 2007 13:39:11 +1100
Message-ID: <49d668000704251939g5b87d35bp6997c7fe8d8e2fed@mail.gmail.com>


Gene,

you probably was looking for a wrong segment type.

In 10GR2 group by can be done as a hash group by. So try to look for a SEGTYPE=HASH instead of SORT.

HTH. On 4/26/07, genegurevich_at_discoverfinancial.com <genegurevich_at_discoverfinancial.com> wrote:
>

> I have however checked the sessstat table for the
> sessions listed in the tempseg_usage view
> and found no data for sorts. I am not sure how to reconcile these two
> pieces of data.
>

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 25 2007 - 21:39:11 CDT

Original text of this message

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