Home » RDBMS Server » Performance Tuning » Regarding AWR report (10.2.0.4, Solaris 10)
Regarding AWR report [message #402465] Sun, 10 May 2009 22:49 Go to next message
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
Member
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?

Thanks,
Harsh
Re: Regarding AWR report [message #402466 is a reply to message #402465] Sun, 10 May 2009 23:07 Go to previous message
BlackSwan
Messages: 26766
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.
http://www.orafaq.com/forum/t/88153/0/

[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: Tue Dec 03 21:30:43 CST 2024