本文共 2589 字，大约阅读时间需要 8 分钟。

以下是优化后的内容：

---

当前实例信息

DB Id DB Name Inst Num Instance

---

2545367939 RAC 1 rac1

报告类型选择

Would you like an HTML report, or a plain text report?

Enter 'html' for an HTML report, or 'text' for plain textDefaults to 'html'

Enter value for report_type: text

Type Specified: text

实例在这个工作负载仓库架构中

DB Id Inst Num DB Name Instance

---

• 2545367939 1 RAC rac1 rac1
  2545367939 2 RAC rac2 rac2

使用 2545367939 为数据库 Id

使用 1 为实例编号

指定要保留的快照天数

Entering 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: 1

最近一天的完成快照

Snap Instance DB Name Snap Id Snap Started Level

---

rac1 RAC 3 14 Jan 2018 14:35 1

4 14 Jan 2018 16:00 1

指定快照的开始和结束快照 ID

Enter value for begin_snap: 3

Begin Snapshot Id specified: 3

Enter value for end_snap: 4

End Snapshot Id specified: 4

指定 SQL ID

Enter value for sql_id: 5mycvad72f8qc

报告名称

The default report file name is awrsqlrpt_1_3_4.txt. To use this name, press

to continue, otherwise enter an alternative.

Enter value for report_name: lijiaman_awrsqpt_1.txt

报告内容如下：

WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

DB Name DB Id Instance Inst Num Startup Time Release RAC

---

RAC 2545367939 rac1 1 14-Jan-18 14:23 11.2.0.1.0 YES

SQL Summary DB/Inst: RAC/rac1 Snaps: 3-4

Elapsed Time (ms) Time (ms) Executions Snap ID Snap ID

---

1 303035560 18 2 2 4

Plan Hash Total DB Time Elapsed Time (ms) Executions Snap ID Snap ID

Value Time(ms) Time(ms) Per Execution % Snap

---

1 303035560 18 9.1 0.0

Plan 1(PHV: 303035560)

Plan Statistics

% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Stat Name Statement Per Execution % Snap

Elapsed Time (ms) 18 9.1 0.0CPU Time (ms) 7 3.5 0.0Executions 2 N/A N/ABuffer Gets 23 11.5 0.0Disk Reads 1 0.5 0.0Parse Calls 2 1.0 0.0Rows 214 107.0 N/AUser I/O Wait Time (ms) 9 N/A N/ACluster Wait Time (ms) 0 N/A N/AApplication Wait Time (ms) 0 N/A N/AConcurrency Wait Time (ms) 0 N/A N/AInvalidations 0 N/A N/AVersion Count 2 N/A N/ASharable Mem(KB) 34 N/A N/A

Execution Plan

Id Operation Name Rows Bytes Cost (%CPU) Time

0 SELECT STATEMENT 214 5457 6 (100)1 MERGE JOIN 107 8988 6 (17)2 TABLE ACCESS BY INDEX ROWID JOBS 19 627 2 (0)3 INDEX FULL SCAN JOB_ID_PK 19 627 1 (0)4 SORT JOIN 107 5457 4 (25)5 TABLE ACCESS FULL EMPLOYEES 107 5457 3 (0)

Full SQL Text

SQL ID SQL Text

---

5mycvad72f8q select j.job_id, j.job_title, j.min_salary, j.max_salary, e.emplo

yee_id, e.first_name||e.last_name as name, e.email, e.phone_number from jobs j, employees e where j.job_id = e.job_id

---

转载地址：http://iysyz.baihongyu.com/