OraFAQ Forum: Performance Tuning » Don't Know how to start performance tuning.

Home » RDBMS Server » Performance Tuning » Don't Know how to start performance tuning. (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)

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

Don't Know how to start performance tuning. [message #522408]

Fri, 09 September 2011 05:00

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi All,

One of my procedure recently taking very long time to execute. I'm attaching AWR report. But I don't know how to read and understand this. Please guide me throuh some steps and help me to focus on the issues hilighted in this AWR report.

Thanks & Regards
Manoj

Attachment: AWR.lst
(Size: 271.98KB, Downloaded 1382 times)

Report message to a moderator

Re: Don't Know how to start performance tuning. [message #522411 is a reply to message #522408]

Fri, 09 September 2011 05:04

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can read:
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page

You can also have a look at Database Performance Tuning Guide.

Regards
Michel

Report message to a moderator

Re: Don't Know how to start performance tuning. [message #522434 is a reply to message #522411]

Fri, 09 September 2011 08:04

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

If the problem is a particular procedure you should use sql trace on it to determine where the time is being spent.

Report message to a moderator

Re: Don't Know how to start performance tuning. [message #522476 is a reply to message #522408]

Sat, 10 September 2011 08:28

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

Senior Member

One thing that jumps out of the report is that you appear to be log switching about once a minute. This cost you 85946 seconds of processing time. It looks as though your logfile group members are perhaps 200M big? I would replace them with groups of 4G.
And of course the memory advisor is suggesting that you up the sga_target to 14G, which might reduce your disc I/O.

I would do that, and see what happens. That's about it for instance tuning. Then you'll need identify the SQL that is not performing adequately.

Report message to a moderator

Re: Don't Know how to start performance tuning. [message #522486 is a reply to message #522408]

Sat, 10 September 2011 10:55

halim
Messages: 100
Registered: September 2008

Senior Member

You should use sql trace as says cookiemonster .

for this see here...

http://halimdba.blogspot.com/2009/03/trace-objects-querys-execution-path.html

regards
Halim

Report message to a moderator

Previous Topic:	How to find out all the queries that are executed in particular range of time in oracle instance.
Next Topic:	Advice on Gather_stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 12:24:57 CDT 2024