Home » RDBMS Server » Performance Tuning » AWR (Oracle 10g 10.2.0.1.0/Windows 2003 Server)
AWR [message #504005] Thu, 21 April 2011 00:19 Go to next message
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
Re: AWR [message #504015 is a reply to message #504005] Thu, 21 April 2011 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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?
Re: AWR [message #504022 is a reply to message #504019] Thu, 21 April 2011 02:09 Go to previous messageGo to next message
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 1684 times)
Re: AWR [message #504025 is a reply to message #504022] Thu, 21 April 2011 02:39 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Before doing anything else, I would patch it up to 10.2.0.5.
Re: AWR [message #504144 is a reply to message #504022] Thu, 21 April 2011 12:35 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Kill the process
Next Topic: Only LOCAL bitmap indexes are permitted on partitioned tables
Goto Forum:
  


Current Time: Thu Mar 28 13:56:00 CDT 2024