OraFAQ Forum: Performance Tuning » Same query , Same database

Home » RDBMS Server » Performance Tuning » Same query , Same database - Different performances ??

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

Same query , Same database - Different performances ?? [message #157259]

Wed, 01 February 2006 05:28

aditya_itc
Messages: 6
Registered: November 2005
Location: In

Junior Member

Hi gurus,

I have a query which runs under the production database.
At times it takes 3 seconds to run and at times around 5 or 6 or 7 seconds.

What could be the possible reason ?
The database is the same, the data is same, then why the difference ??

Thanks in advance,
Aditya

Report message to a moderator

Re: Same query , Same database - Different performances ?? [message #157283 is a reply to message #157259]

Wed, 01 February 2006 07:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

No oracle version, no os/hardware information, no query information,no plan, no statistics, no statspack report ,no traceoutput no nothing.
With the wealth of information you have provided,we can have no better idea than you have!.
>>At times it takes 3 seconds to run and at times around 5 or 6 or 7 seconds
You think this is big difference?
Does it increase if the volume of data handled is increase?

Report message to a moderator

Re: Same query , Same database - Different performances ?? [message #157290 is a reply to message #157259]

Wed, 01 February 2006 07:44

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

If seven seconds versus three seconds is truly worth your effort, then I would run a 10046 trace profiler (like this free one) to see what I was waiting for in the seven-second case that I wasn't waiting for in the three-second case.

Report message to a moderator

Re: Same query , Same database - Different performances ?? [message #157325 is a reply to message #157290]

Wed, 01 February 2006 10:23

Frank
Messages: 7901
Registered: March 2000

Senior Member

How lucky you are, that all you have to worry about is an increase from 3 to 5-7 seconds.
Is the server-load the same? The number of users? The number of queries they fire? Are the same long-running queries running?
Could be that some data is aged out of the cache, which would show as an increase in performance when you resubmit the query.

So many possible causes. (But it hardly seems worth it)

Report message to a moderator

Re: Same query , Same database - Different performances ?? [message #157545 is a reply to message #157325]

Fri, 03 February 2006 02:38

aditya_itc
Messages: 6
Registered: November 2005
Location: In

Junior Member

Thanx Frank,

Your reply has given me a lot of input !!!

Rgds,
Aditya

Report message to a moderator

Previous Topic:	statistics - to Update or Not
Next Topic:	help plzz, oracle slow response

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 14:48:29 CST 2024