Listing the last 3 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
orclsid ORCL 220 19 May 2013 10:18 1
221 19 May 2013 11:00 1
222 19 May 2013 11:42 1
223 19 May 2013 12:00 1
224 19 May 2013 12:30 1
225 19 May 2013 13:00 1
226 19 May 2013 13:30 1
227 19 May 2013 14:00 1
228 19 May 2013 14:30 1
229 19 May 2013 15:00 1
230 19 May 2013 15:31 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 228
Enter value for end_snap: 229
End Snapshot Id specified: 229
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_1_228_229.txt. To use this name,
press
Enter value for report_name: 可以使用默认文件名
DETAILED ADDM REPORT FOR TASK 'TASK_1814' WITH ID 1814
Analysis Period: 19-MAY-2013 from 13:30:50 to 14:00:57
Database ID/Instance: 1326384392/1
Database/Instance Names: ORCL/orclsid
Host Name: localhost.localdomain
Database Version: 10.2.0.1.0
Snapshot Range: from 226 to 227
Database Time: 11 seconds
Average Database Load: 0 active sessions
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
THERE WAS NOT ENOUGH DATABASE TIME FOR ADDM ANALYSIS.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ADDITIONAL INFORMATION
----------------------
There was no significant database activity to run the ADDM.
The database's maintenance windows were active during 99% of the analysis
period.
The analysis of I/O performance is based on the default assumption that the
average read time for one database block is 10000 micro-seconds.
An explanation of the terminology used in this report is available when you
run the report with the 'ALL' level of detail.
