OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » AWR (Oracle 10g 10.2.0.1.0/Windows 2003 Server)

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

AWR [message #504005]

Thu, 21 April 2011 00:19

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

Hello to all

I am new to Oracle DBA.i need to share my AWR report with anyone of you who can suggest me about the perfomence problem coming these days in my production database. i am single DBA here and just started my career in Oracle DBA.

Need your help

GG

Report message to a moderator

Re: AWR [message #504015 is a reply to message #504005]

Thu, 21 April 2011 01:16

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

Senior Member
Account Moderator

Database Performance Tuning Guide.
Performances Tuning sticky.

Regards
Michel

[Updated on: Thu, 21 April 2011 01:17]

Report message to a moderator

Re: AWR [message #504019 is a reply to message #504005]

Thu, 21 April 2011 01:45

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

Senior Member

Is there a problem with uploading the AWR report to here? With any thoughts you may have?

Report message to a moderator

Re: AWR [message #504022 is a reply to message #504019]

Thu, 21 April 2011 02:09

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

Hi Jhon

i am sending my latest AWR report of my Database.Its taking too much time.Even processing queries and statements are slow. what could be the cause. please suggest.

Attachment: ar.txt
(Size: 109.91KB, Downloaded 1875 times)

Report message to a moderator

Re: AWR [message #504025 is a reply to message #504022]

Thu, 21 April 2011 02:39

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

Senior Member

Before doing anything else, I would patch it up to 10.2.0.5.

Report message to a moderator

Re: AWR [message #504144 is a reply to message #504022]

Thu, 21 April 2011 12:35

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Also you could run it through statspack analyzer.

[Updated on: Thu, 21 April 2011 12:41] by Moderator

Report message to a moderator

Re: AWR [message #504406 is a reply to message #504022]

Sun, 24 April 2011 22:41

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

You shouldn't be running 10.2.0.1 but 10.2.0.5.
Since you have a Standby configured, many of the waits relate to redo shipping to the Standby. Is the database configured in MAXIMUM PROTECTION mode or MAXIMUM AVAILABILTIY mode ? (Query V$DATABASE).
Apparently, a large portion of your redo and commit processing time is spent waiting on the commit to the standby.

You also have slightly high write wait times.

An 8 Hour AWR very unfortunately doesn't provide good diagnostic information as the statistics are "averaged out" over 8 hours.
You should take a peak period and generate a few AWR snapshots and reports for 15minutes or 30minutes.

Hemant K Chitale

Report message to a moderator

Previous Topic:	Kill the process
Next Topic:	Only LOCAL bitmap indexes are permitted on partitioned tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 20:41:53 CST 2024