Re: "direct path write" waits, please help

> <Quote>: "
> Group by is still doing sorting, and is accounted in "sorts" stats (unless
> an index scan wasn't used to get rows in desired order).
> But yes, hash joins don't increase sort stats by themselves.
> " <end of quote>
>
> I think you meant "was used"in sted of "wasn't used". Just like you said,
> is's all hash joins. It's a production system; I can only peek via the
> perfstat schema, but I know the application and instance well enough.

Yeah, that's what I meant, sorry for this "typo".

Tanel.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).