No Snapshot Avaliable for AWR Report [message #492707] |
Tue, 01 February 2011 23:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pradies
Messages: 250 Registered: May 2008
|
Senior Member |
|
|
Hi,
I am trying to generate AWR report for database observation. But I am not getting any snapshot listed there. below is the output of my awrrpt.sql
SQL> @?/rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1140984076 AFCCV 1 afccv
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: html
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 1140984076 1 AFCCV afccv SERVICEDB1
Using 1140984076 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 3
Listing the last 3 days of Completed Snapshots
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap:
========================================================
Can someone tell me why this is happening and for resolution what can I do?
Regards
Pradeep
|
|
|
|
|
Re: No Snapshot Avaliable for AWR Report [message #492711 is a reply to message #492708] |
Tue, 01 February 2011 23:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pradies
Messages: 250 Registered: May 2008
|
Senior Member |
|
|
Hi,
User is sys !!!!
I have never used awr for this server. Today I get some performance issue then I tried for AWR report and same below problem occured.
Rest wait for an hour.
Revert Back soon.
Thanks and regards
pradeep
|
|
|
|
Re: No Snapshot Avaliable for AWR Report [message #492716 is a reply to message #492712] |
Wed, 02 February 2011 00:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pradies
Messages: 250 Registered: May 2008
|
Senior Member |
|
|
hi,
I have checked that from OEM where the AWR baseline Snapshot collection option was off. After changing it to on mode Fist snap id has been generated at db level. and it is showing the snap id in AWR report.
Regards
Pradeep
|
|
|
Re: No Snapshot Avaliable for AWR Report [message #492728 is a reply to message #492716] |
Wed, 02 February 2011 01:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Please Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Post the (formatted) result of the following queries:
select dbid, instance_number, startup_time, min(snap_id), max(snap_id)
from DBA_HIST_SNAPSHOT
group by dbid, instance_number, startup_time
order by dbid, instance_number, startup_time
/
select dbid, instance_number, snap_id, table_name, error_number
from DBA_HIST_SNAP_ERROR
order by dbid, instance_number, snap_id
/
Regards
Michel
|
|
|
Re: No Snapshot Avaliable for AWR Report [message #492731 is a reply to message #492728] |
Wed, 02 February 2011 01:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pradies
Messages: 250 Registered: May 2008
|
Senior Member |
|
|
Hi,
I will take care of formatting in further post.
Rest find the required output.
SQL> select dbid, instance_number, startup_time, min(snap_id), max(snap_id)
2 from DBA_HIST_SNAPSHOT
3 group by dbid, instance_number, startup_time
4 order by dbid, instance_number, startup_time
5 /
DBID INSTANCE_NUMBER STARTUP_TIME MIN(SNAP_ID) MAX(SNAP_ID)
----------- --------------- -------------------------- ------------- --------------
1140984076 1 02-FEB-11 09.44.09.000 AM 1309 1310
SQL> select dbid, instance_number, snap_id, table_name, error_number
2 from DBA_HIST_SNAP_ERROR
3 order by dbid, instance_number, snap_id
4 /
no rows selected
regards
pradeep
|
|
|
|