OraFAQ Forum: Performance Tuning » Application is running slow time to time

Home » RDBMS Server » Performance Tuning » Application is running slow time to time (linux)

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

Application is running slow time to time [message #656041]

Wed, 21 September 2016 06:16

dbabertrand
Messages: 1
Registered: September 2016

Junior Member

Hello guys,
I have a very strange situation. One of the application job is running very slow time to time. Even when I switch from one disk group to the other.
I have the awr reports when the results are good and bad. Can someone able to help?

Report message to a moderator

Re: Application is running slow time to time [message #656042 is a reply to message #656041]

Wed, 21 September 2016 06:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

ORAFAQ tuning below -
Since NOBODY can optimize SQL just by looking at it, we need a few more details.
http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) ddl for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof

Report message to a moderator

Re: Application is running slow time to time [message #656043 is a reply to message #656041]

Wed, 21 September 2016 06:32

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Can someone able to help?

Possibly - if you provide the AWR reports.

Report message to a moderator

Re: Application is running slow time to time [message #656044 is a reply to message #656043]

Wed, 21 September 2016 06:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>One of the application job is running very slow time to time.
Does SQL use bind variables?

Report message to a moderator

Re: Application is running slow time to time [message #656121 is a reply to message #656041]

Fri, 23 September 2016 08:39

bpeasland
Messages: 51
Registered: February 2015
Location: United States

Member

If you have an AWR report from the period when performance is good, and another from when performance is bad, then look at them side by side to see which areas are being negatively impacted the most. That's probably the best place to start. You might want to pay close attention to the areas of the report that detail the Top N SQL statements. During worse performance, is there a SQL statement or two that seem to be acting differently?

Cheers,
Brian

Report message to a moderator

Previous Topic:	What should i do for tuning this query
Next Topic:	Database options to address work load increase

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 31 21:13:02 CDT 2023