Re: direct path read/write temp waits

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