| Regarding AWR report [message #402465] |
Sun, 10 May 2009 22:49  |
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  |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
