Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Which Tuning Method? System/Resource Tuning?
Tsk, tsk -
you are confusing 'database' with 'instance' ;)
It is a good point, though, and one that I feel I should have spotted.
-- 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. Connor McDonald wrote in message <3BE9351A.55F1_at_yahoo.com>...Received on Wed Nov 07 2001 - 07:52:18 CST
>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..."