awr收集

最新推荐文章于 2024-04-25 15:59:02 发布

山的那边0358

最新推荐文章于 2024-04-25 15:59:02 发布

阅读量313

点赞数

文章标签：数据库 oracle

本文链接：https://blog.csdn.net/weixin_43965733/article/details/122936546

版权

[oracle@zdb1201 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 13 17:29:33 2018

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @awrrpt.sql

Current Instance
~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
3068909879 TEST1201 1 test1201

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
------------ -------- ------------ ------------ ------------
* 3068909879 1 TEST1201 test1201 zdb1201

Using 3068909879 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: 1

Listing the last day's Completed Snapshots

Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
test1201 TEST1201 4653 13 Dec 2018 00:00 1
4654 13 Dec 2018 01:00 1
4655 13 Dec 2018 02:00 1
4656 13 Dec 2018 03:00 1
4657 13 Dec 2018 04:00 1
4658 13 Dec 2018 05:00 1
4659 13 Dec 2018 06:00 1
4660 13 Dec 2018 07:00 1
4661 13 Dec 2018 08:00 1
4662 13 Dec 2018 09:00 1
4663 13 Dec 2018 10:00 1
4664 13 Dec 2018 11:00 1
4665 13 Dec 2018 12:00 1
4666 13 Dec 2018 13:00 1
4667 13 Dec 2018 14:00 1
4668 13 Dec 2018 15:00 1
4669 13 Dec 2018 16:00 1
4670 13 Dec 2018 17:00 1

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap:
Begin Snapshot Id specified: 4669

Enter value for end_snap: 4670
End Snapshot Id specified: 4670

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_4669_4670.html. To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name: /tmp/121316.html

Using the report name /tmp/121316.html