本机生成远程数据库AWR报告-创新互联
创新互联专注于全椒企业网站建设,成都响应式网站建设,商城网站建设。全椒网站建设公司,为全椒等地区提供建站服务。全流程按需求定制网站,专业设计,全程项目跟踪,创新互联专业和态度为您提供的服务/>1、本机命令行连接oracle数据库
sqlplus /nolog
SQL> conn system/oracle@98149
2、执行生成AWR报告命令
SQL> @?/rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1244647887 ORAL 1 oral
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'
-----------------------------------------------------------------此处输入html
输入 report_type 的值: html
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 1244647887 1 ORAL oral s11ora11
Using 1244647887 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
specifying a number lists all completed snapshots.
-----------------------------------------------------------------此处输入需要查看报告的天数
输入 num_days 的值: 1
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
oral ORAL 17512 23 3月 2018 00:00 1
17513 23 3月 2018 00:30 1
17514 23 3月 2018 01:00 1
17515 23 3月 2018 01:30 1
17516 23 3月 2018 02:00 1
17517 23 3月 2018 02:30 1
17518 23 3月 2018 03:00 1
17519 23 3月 2018 03:30 1
17520 23 3月 2018 04:00 1
17521 23 3月 2018 04:30 1
17522 23 3月 2018 05:00 1
17523 23 3月 2018 05:30 1
17524 23 3月 2018 06:00 1
17525 23 3月 2018 06:30 1
17526 23 3月 2018 07:00 1
17527 23 3月 2018 07:30 1
17528 23 3月 2018 08:00 1
17529 23 3月 2018 08:30 1
17530 23 3月 2018 09:00 1
-----------------------------------------------------------------输入对应时间的snap_id
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入 begin_snap 的值: 17529
Begin Snapshot Id specified: 17529
输入 end_snap 的值: 17530
End Snapshot Id specified: 17530
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_17529_17530.html. To use this name,
press
-----------------------------------------------------------------直接回车,在命令行启动目录路径下生成报告
输入 report_name 的值:
文章名称:本机生成远程数据库AWR报告-创新互联
标题URL:http://pwwzsj.com/article/jeipc.html