oracle 10g 生成awr报告过程WORKLOAD REPOSITORY report for


SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@204_maridb ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 – Production on Mon Jul 1 16:08:08 2019Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining optionsSQL> var snap_id number
SQL> exec :snap_id:=dbms_workload_repository.create_snapshotPL/SQL procedure successfully completed.SQL> print snap_idSQL> @?/rdbms/admin/awrrpt.sqlCurrent InstanceWould 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: Type Specified: htmlInstances in this Workload Repository schemaEntering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing without
specifying a number lists all completed snapshots.
Enter value for num_days: 1Listing the last day’s Completed SnapshotsInstance DB Name Snap Id Snap Started LevelTSH1 SKODACOM 52416 01 Jul 2019 00:00 1
52417 01 Jul 2019 01:00 1
52418 01 Jul 2019 02:00 1
52419 01 Jul 2019 03:00 1
52420 01 Jul 2019 04:01 1
52421 01 Jul 2019 05:00 1
52422 01 Jul 2019 06:00 1
52423 01 Jul 2019 07:00 1
52424 01 Jul 2019 08:00 1
52425 01 Jul 2019 09:01 1
52426 01 Jul 2019 10:00 1
52427 01 Jul 2019 11:00 1
52428 01 Jul 2019 12:00 1
52429 01 Jul 2019 13:00 1
52430 01 Jul 2019 14:00 1
52431 01 Jul 2019 15:00 1
52432 01 Jul 2019 15:20 1
52433 01 Jul 2019 16:00 1
52434 01 Jul 2019 16:08 1Specify the Begin and End Snapshot IdsThe default report file name is awrrpt_1_52416_52434.html. To use this name,
press to continue, otherwise enter an alternative.Enter value for report_name: Using the report name awrrpt_1_52416_52434.html

Cache Sizes

Load Profile

Instance Efficiency Percentages (Target 100%)

Shared Pool Statistics

Top 5 Timed Events

Back to Wait Events Statistics

Back to Top

Back to Wait Events Statistics

Back to Top

Back to Wait Events Statistics

Back to Top

Back to Wait Events Statistics

Back to Top

Back to Wait Events Statistics

Back to Top

Back to Wait Events Statistics

Back to Top

Back to Wait Events Statistics

Back to Top

Back to SQL Statistics

Back to Top

Back to SQL Statistics

Back to Top

Back to SQL Statistics

Back to Top

Back to SQL Statistics

Back to Top

Back to SQL Statistics

Back to Top

Back to SQL Statistics

Back to Top

No data exists for this section of the report.

Back to SQL Statistics

Back to Top

No data exists for this section of the report.

Back to SQL Statistics

Back to Top

Back to SQL Statistics

Back to Top

Back to Instance Activity Statistics

Back to Top

Back to Instance Activity Statistics

Back to Top

Back to Instance Activity Statistics

Back to Top

Back to IO Stats

Back to Top

Back to IO Stats

Back to Top

Back to Top

Back to Advisory Statistics

Back to Top

Back to Advisory Statistics

Back to Top

Back to Advisory Statistics

Back to Top

Back to Advisory Statistics

Back to Top

Back to Advisory Statistics

Back to Top

Back to Advisory Statistics

Back to Top

Back to Advisory Statistics

Back to Top

Back to Advisory Statistics

Back to Top

No data exists for this section of the report.

Back to Advisory Statistics

Back to Top

No data exists for this section of the report.

Back to Advisory Statistics

Back to Top

Back to Wait Statistics

Back to Top

No data exists for this section of the report.

Back to Wait Statistics

Back to Top

Back to Undo Statistics

Back to Top

Back to Undo Statistics

Back to Top

Back to Latch Statistics

Back to Top

Back to Latch Statistics

Back to Top

Back to Latch Statistics

Back to Top

No data exists for this section of the report.

Back to Latch Statistics

Back to Top

No data exists for this section of the report.

Back to Latch Statistics

Back to Top

Back to Segment Statistics

Back to Top

Back to Segment Statistics

Back to Top

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Back to Top

Back to Top

Back to Memory Statistics

Back to Top

Back to Memory Statistics

Back to Top

Back to Memory Statistics

Back to Top

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

No data exists for this section of the report.

Back to Streams Statistics

Back to Top

No data exists for this section of the report.

Back to Top

Back to Top

End of Report

Report written to awrrpt_1_52416_52434.html
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@204_maridb ~]$ ll
总用量 19080
-rw-r–r–免费云主机域名 1 oracle oinstall 252239 7月 1 16:09 awrrpt_1_52416_52434.html
-rw-r–r– 1 oracle oinstall 249247 7月 1 15:22 awrrpt_1_52431_52432.html
-rw-r–r– 1 oracle oinstall 16444 4月 16 11:45 dbca.rsp
-rw-r–r– 1 oracle oinstall 920 4月 16 11:24 enterprise01.rsp
-rw-r–r– 1 oracle oinstall 457 4月 22 16:04 export.log
-rw-r—– 1 oracle oinstall 18321408 4月 19 10:54 full.dmp
-rw-r—– 1 oracle oinstall 1167 4月 19 11:39 impdp.log
-rw-r—– 1 oracle oinstall 291067 4月 19 11:36 import.log
-rw-r–r– 1 oracle oinstall 5742 4月 16 11:49 netca.rsp
-rw-rw-r– 1 oracle oinstall 65 4月 16 11:13 oraInst.loc
-rw-r–r– 1 root root 121910 5月 14 14:19 rlwrap-0.43-2.el7.x86_64.rpm
-rw-r–r– 1 oracle oinstall 65638 5月 14 11:48 rman_11.log
drwxr-xr-x 2 oracle oinstall 4096 5月 23 10:55 scripts
-rw-r—– 1 oracle oinstall 172032 4月 19 11:36 testexpdp.dmp

相关推荐: Redis6.0为什么要引入多线程

这篇文章给大家分享的是有关Redis6.0为什么要引入多线程的内容。小编觉得挺实用的,因此分享给大家做个参考。一起跟随小编过来看看吧。Redis6.0之前为什么采用单线程模型严格地说,从Redis 4.0之后并不是单线程。除了主线程外,还有一些后台线程处理一些…

免责声明:本站发布的图片视频文字,以转载和分享为主,文章观点不代表本站立场,本站不承担相关法律责任;如果涉及侵权请联系邮箱:360163164@qq.com举报,并提供相关证据,经查实将立刻删除涉嫌侵权内容。

(0)
打赏 微信扫一扫 微信扫一扫
上一篇 01/17 12:14
下一篇 01/17 12:15