Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate AWR report

533779Sep 25 2009 — edited Sep 25 2009
Hi All,

DB - 10.2.0.4.0

I ned to generate AWR report for 30 minute time intervel. For expample, if I need to generate AWR report for the timmig 03:00 PM to 03:30 PM, DO I need to create snapshot manually at 3 pm and 3:30 pm.

exec dbms_workload_repository.create_snapshot(); at 03:00 PM
exec dbms_workload_repository.create_snapshot(); at 03:30 PM

Also, is there any way, if the current time is 01:00 pm and can we create snapshot for 03:00PM and 03:30 PM?

hare krishna
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2009
Added on Sep 25 2009
#general-database-discussions
7 comments
2,092 views