Re: nested loop anti join vs hash anti join

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 28 Mar 2006 14:13:02 +0100
Message-ID: <weSdncBlgcP_q7TZRVnyvA@bt.com>

<dbaplusplus_at_hotmail.com> wrote in message news:1143548798.233678.216710_at_v46g2000cwv.googlegroups.com...
> Thanks. Not sure what you mean by execution rrows statiisctis from a
> trace file. How does one get that,
>

Connect through sql*plus

Enable sql_trace, or set event 10046

Run the query and quit from sql*plus

Locate the trace file (check the value for parameter user_dump_dest) run tkprof against the trace file.

Search the resulting file for the statement, and it's execution statistics, and the execution plan which will be labelled Row Source Operation Each line has a row-count beside it.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

Received on Tue Mar 28 2006 - 07:13:02 CST