OraFAQ Forum: Performance Tuning » Different Explain in Different Instances.

Home » RDBMS Server » Performance Tuning » Different Explain in Different Instances.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Different Explain in Different Instances. [message #258625]

Mon, 13 August 2007 03:51

maggy_ashee
Messages: 70
Registered: May 2007

Member

Hi all,

when am trying to run a query in my test instance it runs faster and the cost is just '7000' but when i run the same query in another instance the cost is '64000'.

The explain plan is extremely different.Different Indexes are being used.Can any one help me out in this,plz this some wat urgent?

The version and all are one and the same.

Thanks in Advance.

Report message to a moderator

Re: Different Explain in Different Instances. [message #258626 is a reply to message #258625]

Mon, 13 August 2007 03:53

rons
Messages: 18
Registered: June 2007
Location: Scottland

Junior Member

Hi,

May be gathering stats will help.

Ronald.

Report message to a moderator

Re: Different Explain in Different Instances. [message #258630 is a reply to message #258626]

Mon, 13 August 2007 03:55

maggy_ashee
Messages: 70
Registered: May 2007

Member

Please let me know how to do that ?

Report message to a moderator

Re: Different Explain in Different Instances. [message #258632 is a reply to message #258625]

Mon, 13 August 2007 03:57

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

plz this some wat urgent?

Nothing is urgent in forum but you to read the sticky and don't use IM speak.

Regards
Michel

[Updated on: Mon, 13 August 2007 03:57]

Report message to a moderator

Re: Different Explain in Different Instances. [message #258633 is a reply to message #258625]

Mon, 13 August 2007 03:58

rons
Messages: 18
Registered: June 2007
Location: Scottland

Junior Member

Hi,

Please check this.

Ronald.

Report message to a moderator

Re: Different Explain in Different Instances. [message #258686 is a reply to message #258633]

Mon, 13 August 2007 06:28

maggy_ashee
Messages: 70
Registered: May 2007

Member

If the cost has got reduced ,can we be sure that the performance has been improved.

Because in some cases I see that even the cost get reduced the performance is still worse.

Report message to a moderator

Re: Different Explain in Different Instances. [message #258693 is a reply to message #258686]

Mon, 13 August 2007 06:48

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

maggy_ashee wrote on Mon, 13 August 2007 12:28

If the cost has got reduced ,can we be sure that the performance has been improved.

Because in some cases I see that even the cost get reduced the performance is still worse.

Not to be facetious, but your second statement seems to answer your first Smile

Report message to a moderator

Re: Different Explain in Different Instances. [message #258759 is a reply to message #258693]

Mon, 13 August 2007 09:35

maggy_ashee
Messages: 70
Registered: May 2007

Member

It was my doubt?noting to be facetious Laughing

ok fin

Gather statistics is being done for all the tables periodically.
Can you suggest some other way to rectify the said problem.?

Report message to a moderator

Previous Topic:	10g performance tuning (how can I practice?)
Next Topic:	Takes more time - DELETE.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 22:56:07 CST 2024