ORACLE 生成ASH 报告

SQL> @$ORACLE_HOME/rdbms/admin/ashrpt.sql

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: html

ASH Samples in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Oldest ASH sample available:  18-Feb-19 22:21:49   [    618 mins in the past]
Latest ASH sample available:  19-Feb-19 08:39:23   [      0 mins in the past]

Specify the timeframe to generate the ASH report
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter begin time for report:

--    Valid input formats:
--  To specify absolute begin time:
--    [MM/DD[/YY]] HH24:MI[:SS]
--    Examples: 02/23/03 14:30:15
--          02/23 14:30:15
--          14:30:15
--          14:30
--  To specify relative begin time: (start with '-' sign)
--    -[HH24:]MI
--    Examples: -1:15  (SYSDATE - 1 Hr 15 Mins)
--          -25    (SYSDATE - 25 Mins)

Defaults to -15 mins
Enter value for begin_time: 02/19/19 08:10:00
Report begin time specified: 02/19/19 08:10:00

Enter duration in minutes starting from begin time:
Defaults to SYSDATE - begin_time
Press Enter to analyze till current time
Enter value for duration: 10

Using 19-Feb-19 08:10:00 as report begin time
Using 19-Feb-19 08:20:00 as report end time

Enter value for report_name: ash_0219.html