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