ASH 报告生成过程中 Enter value for duration 需要输入一个数字，表示持续的分钟

最新推荐文章于 2023-03-12 13:51:07 发布

转载最新推荐文章于 2023-03-12 13:51:07 发布 · 471 阅读

SQL> @ashrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
4110082405 ORA11G 1 ora11g1

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

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 4110082405 1 ORA11G ora11g1 smp-1
4110082405 2 ORA11G ora11g2 smp-2
Defaults to current database
Using database id: 4110082405
Defaults to current instance
Using instance number: 1

ASH Samples in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Oldest ASH sample available: 23-Mar-12 08:00:37 [ 12025 mins in the past]
Latest ASH sample available: 31-Mar-12 16:22:58 [ 2 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: 03/31/12 10:00:00
Report begin time specified: 03/31/12 10:00: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: 03/31/12 10:10:00 -- 这里是 duration，这种写法是错误的 ,表示持续时间，