Home » RDBMS Server » Performance Tuning » Regarding AWR report (, Solaris 10)
Regarding AWR report [message #402465] Sun, 10 May 2009 22:49 Go to next message
Messages: 34
Registered: February 2008
Location: Delhi
Hello Experts,

I have a small query regarding the AWR reports.

If i take AWR of two snapshot of "01-Apr-09 00:01" and "04-Apr-09 23:59" then if it will display the information about all the activities of 4 days?

Re: Regarding AWR report [message #402466 is a reply to message #402465] Sun, 10 May 2009 23:07 Go to previous message
Messages: 25542
Registered: January 2009
Location: SoCal
Senior Member
If you mean the starting snapshot "01-Apr-09 00:01" and ending snaphot "04-Apr-09 23:59" , then the report covers the activity in between; assuming the database was never restarted in between.

However, the results in report will be borderline useless.
Oracle recommends the best duration for AWR report is 10 or 15 minutes.

You need to help us by following the Posting Guidelines as stated below.

[Updated on: Sun, 10 May 2009 23:08]

Report message to a moderator

Previous Topic: Gets and GetHits difference ?
Next Topic: No performance boost after upgrading database server RAM from 3GB to 16G
Goto Forum:

Current Time: Wed Jul 26 14:02:19 CDT 2017

Total time taken to generate the page: 0.09495 seconds