Re: direct path read/write temp waits

From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
Date: Thu, 26 Apr 2007 13:39:11 +1100

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@xxxxxxxxxxxxxxxxxxxxx
<genegurevich@xxxxxxxxxxxxxxxxxxxxx> 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

References:

direct path read/write temp waits
From: genegurevich

Other related posts:

Browse oracle-l