Half Hour AWR Report

Posted on 2014-02-18
Medium Priority
Last Modified: 2014-02-19
We restarted our server at 10:45 a.m.   I need to get awr from 10:00 a.m. until that time but awr only displays hour interval choice.   Is there a way to get awr between 10 and 10:45?
Question by:xoxomos
LVL 12

Assisted Solution

by:Praveen Kumar Chandrashekatr
Praveen Kumar Chandrashekatr earned 200 total points
ID: 39869719
By Default oracle generates a snapshot for every hour, if you want you can change it to
every 15mins or 30mins as per your requirement as shown below.

sqlplus "/as sysdba"
for 15 minutes and retention to 7 days
SQL>exec dbms_workload_repository.modify_snapshot_settings(1080,15);
for 30 minutes and retention to 7 days
SQL>exec dbms_workload_repository.modify_snapshot_settings(1080,30);

check these documents for more info.
LVL 36

Accepted Solution

Mark Geerlings earned 1000 total points
ID: 39870201
Yes, you can change those intervals for the future like praveencpk suggested.  But no, you cannot go back and change these times in the past.   Also, you cannot include a database shutdown and restart in an AWR snapshot.  For example, if you have snpshots at the default interval of 30 minutes, you can get an AWR report from 10 - 10:30am on the day that your server restarted at 10:45am.  And, you can get an AWR report from 11 - 11:30 am on that day, but the AWR process does not support including the time of a database shutdown and restart.

Author Comment

ID: 39870831
Many thanks.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question