Re: Which Tuning Method? System/Resource Tuning?

Jonathan Lewis wrote:
>
> You only need to look at row fetch counts to
> be confident that the queries are using different
> access paths. Your issue is a SQL one, not
> a machine/resource one.
>
> As a starting point use explain plan to check
> the execution paths.
>
> >NAME Machine A Machine B
> >----------------------------------- --------- ---------
> >table fetch by rowid 1120840 12
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
> Screen saver or Life saver: http://www.ud.com
> Use spare CPU to assist in cancer research.
>
> Vance Wu wrote in message ...
> >Hi Friends,
> >
> >I need your help, I have two machines A and B:
> >

I'm also note sure how 8.1.6 on one node, and 8.1.7 on the other counts toward: "identical databases"

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."