Re: Which Tuning Method? System/Resource Tuning?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 7 Nov 2001 13:06:32 -0000
Message-ID: <1005138270.20289.0.nnrp-08.9e984b29@news.demon.co.uk>

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:

>

Received on Wed Nov 07 2001 - 07:06:32 CST