【博客文章2025】Oracle 23ai RAC 6节点集群AWR报告解析
Author: Bo Tang
1. Oracle 23ai RAC 6节点集群环境：
1.1 网格基础架构部分：
[grid@station21 ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM1
[grid@station21 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [23.0.0.0.0] |
1.2 集群资源列表：
[grid@station21 ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM1
The Oracle base has been set to /u01/app/grid
[grid@station21 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE station21 STABLE
ONLINE ONLINE station22 STABLE
ONLINE ONLINE station23 STABLE
ONLINE ONLINE station24 STABLE
ONLINE ONLINE station25 STABLE
ONLINE ONLINE station26 STABLE
ora.chad
ONLINE ONLINE station21 STABLE
ONLINE ONLINE station22 STABLE
ONLINE ONLINE station23 STABLE
ONLINE ONLINE station24 STABLE
ONLINE ONLINE station25 STABLE
ONLINE ONLINE station26 STABLE
ora.helper
OFFLINE OFFLINE station21 IDLE,STABLE
OFFLINE OFFLINE station22 IDLE,STABLE
OFFLINE OFFLINE station23 IDLE,STABLE
OFFLINE OFFLINE station24 IDLE,STABLE
OFFLINE OFFLINE station25 IDLE,STABLE
OFFLINE OFFLINE station26 IDLE,STABLE
ora.net1.network
ONLINE ONLINE station21 STABLE
ONLINE ONLINE station22 STABLE
ONLINE ONLINE station23 STABLE
ONLINE ONLINE station24 STABLE
ONLINE ONLINE station25 STABLE
ONLINE ONLINE station26 STABLE
ora.ons
ONLINE ONLINE station21 STABLE
ONLINE ONLINE station22 STABLE
ONLINE ONLINE station23 STABLE
ONLINE ONLINE station24 STABLE
ONLINE ONLINE station25 STABLE
ONLINE ONLINE station26 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE station24 STABLE
2 ONLINE ONLINE station22 STABLE
3 ONLINE ONLINE station21 STABLE
ora.ASMNET2LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE station24 STABLE
2 ONLINE ONLINE station22 STABLE
3 ONLINE ONLINE station21 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE station24 STABLE
2 ONLINE ONLINE station22 STABLE
3 ONLINE ONLINE station21 STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE station24 STABLE
2 ONLINE ONLINE station22 STABLE
3 ONLINE ONLINE station21 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE station23 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE station22 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE station24 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE station24 Started,STABLE
2 ONLINE ONLINE station22 Started,STABLE
3 ONLINE ONLINE station21 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE station24 STABLE
2 ONLINE ONLINE station22 STABLE
3 ONLINE ONLINE station21 STABLE
ora.asmnet2.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE station24 STABLE
2 ONLINE ONLINE station22 STABLE
3 ONLINE ONLINE station21 STABLE
ora.cdb1.db
1 ONLINE ONLINE station21 Open,HOME=/u01/app/o
racle/product/23.5.0
/dbhome_1,STABLE
2 ONLINE ONLINE station22 Open,HOME=/u01/app/o
racle/product/23.5.0
/dbhome_1,STABLE
3 ONLINE ONLINE station23 Open,HOME=/u01/app/o
racle/product/23.5.0
/dbhome_1,STABLE
4 ONLINE ONLINE station24 Open,HOME=/u01/app/o
racle/product/23.5.0
/dbhome_1,STABLE
5 ONLINE ONLINE station25 Open,HOME=/u01/app/o
racle/product/23.5.0
/dbhome_1,STABLE
6 ONLINE ONLINE station26 Open,HOME=/u01/app/o
racle/product/23.5.0
/dbhome_1,STABLE
ora.cdb1.pdb1_1.pdb
1 ONLINE ONLINE station21 READ WRITE,STABLE
2 ONLINE ONLINE station22 READ WRITE,STABLE
3 ONLINE ONLINE station23 READ WRITE,STABLE
4 ONLINE ONLINE station24 READ WRITE,STABLE
5 ONLINE ONLINE station25 READ WRITE,STABLE
6 ONLINE ONLINE station26 READ WRITE,STABLE
ora.cdp1.cdp
1 ONLINE ONLINE station23 STABLE
ora.cdp2.cdp
1 ONLINE ONLINE station22 STABLE
ora.cdp3.cdp
1 ONLINE ONLINE station24 STABLE
ora.cvu
1 ONLINE ONLINE station24 STABLE
ora.gns
1 ONLINE ONLINE station24 STABLE
ora.gns.vip
1 ONLINE ONLINE station24 STABLE
ora.rhpserver
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE station23 STABLE
ora.scan2.vip
1 ONLINE ONLINE station22 STABLE
ora.scan3.vip
1 ONLINE ONLINE station24 STABLE
ora.station21.vip
1 ONLINE ONLINE station21 STABLE
ora.station22.vip
1 ONLINE ONLINE station22 STABLE
ora.station23.vip
1 ONLINE ONLINE station23 STABLE
ora.station24.vip
1 ONLINE ONLINE station24 STABLE
ora.station25.vip
1 ONLINE ONLINE station25 STABLE
ora.station26.vip
1 ONLINE ONLINE station26 STABLE
--------------------------------------------------------------------------------
|
|
1.3 数据库部分：
[oracle@station21 ~]$ . oraenv
ORACLE_SID = [oracle] ? cdb11
The Oracle base has been set to /u01/app/oracle
[oracle@station21 ~]$ srvctl status database -d cdb1 -v
Instance cdb11 is running on node station21. Instance status: Open,HOME=/u01/app/oracle/product/23.5.0/dbhome_1.
Instance cdb12 is running on node station22. Instance status: Open,HOME=/u01/app/oracle/product/23.5.0/dbhome_1.
Instance cdb13 is running on node station23. Instance status: Open,HOME=/u01/app/oracle/product/23.5.0/dbhome_1.
Instance cdb14 is running on node station24. Instance status: Open,HOME=/u01/app/oracle/product/23.5.0/dbhome_1.
Instance cdb15 is running on node station25. Instance status: Open,HOME=/u01/app/oracle/product/23.5.0/dbhome_1.
Instance cdb16 is running on node station26. Instance status: Open,HOME=/u01/app/oracle/product/23.5.0/dbhome_1.
[oracle@station21 ~]$ srvctl config database -d cdb1
Database unique name: cdb1
Database name:
Oracle home: /u01/app/oracle/product/23.5.0/dbhome_1
Oracle user: oracle
Spfile: +data/CDB1/PARAMETERFILE/spfile.315.1213116919
Password file: +data/CDB1/PASSWORD/pwdcdb1.263.1212350979
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: cdb11,cdb12,cdb13,cdb14,cdb15,cdb16
Configured nodes: station21,station22,station23,station24,station25,station26
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@station21 ~]$ sqlplus /nolog SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Oct 3 02:15:55 2025
Version 23.5.0.24.07 Copyright (c) 1982, 2024, Oracle. All rights reserved. SQL> conn / as sysdba
Connected.
SQL> select * from v$version; BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems
Version 23.5.0.24.07 BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems
0
|
|
1.4 插件数据库部分：
SQL> col name format a30 trunc
SQL> select CON_ID,NAME,OPEN_MODE from v$pdbs; CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ ONLY
4 PDB1_1 READ WRITE SQL> alter session set container=pdb1_1; Session altered. SQL> show parameter compati NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 23.0.0
noncdb_compatible boolean FALSE
plsql_v2_compatibility boolean FALSE
|
|
2. 工作负载和AWR快照：
需要使用PDB的AWR快照生成PDB的AWR报告。如果AWR报告开头显示“（PDB snapshots）”如下图：
WORKLOAD REPOSITORY PDB report (PDB snapshots)
|
则说明是使用在同一个开库周期的两张PDB快照制作的PDB AWR报告。
3. AWR快照解析：
3.1 第一部分列出主机/数据库/快照的拍摄场景：
| DB Name | DB Id | Unique Name | Role | Edition | Release | RAC | CDB |
|---|
| CDB1 | 2871972511 | cdb1 | PRIMARY | EE | 23.5.0.24.07 | YES | YES |
注释：数据库的版本是23.5.0.24.07，而且是容器数据库（23ai都必须是多租户架构）。| Instance | Inst Num | Startup Time | User Name | System Data Visible |
|---|
| cdb11 | 1 | 03-10月-25 06:25 | SYS | YES |
| Container DB Id | Container Name | Open Time |
|---|
| 2871972511 | PDB1_1 | 03-10月-25 06:25 |
| Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
|---|
| station21.lab.example.com | Linux x86 64-bit | 8 | 8 | 8 | 11.12 |
| Snap Id | Snap Time | Sessions | Cursors/Session | Instances |
|---|
| Begin Snap: | 55 | 03-10月-25 08:58:15 | 178 | 2.5 | 6 | | End Snap: | 65 | 03-10月-25 18:58:23 | 0 | .0 | 6 | | Elapsed: | | 600.14 (mins) | | | | | DB Time: | | 5,245.95 (mins) | | | |
注释： 整个过程都是6个实例运行；开始时集群数据库有较多的并发会话（178）；时间间隔10个小时（大型工作负载持续高负载运行）。
|
|
3.2 可以说，AWR报告的正文是从下面开始，首先是负载概览（称其为第1部分）： 如每秒/每事务/每次执行/每条SQL语句所包含的：
Report SummaryLoad Profile
| Per Second | Per Transaction | Per Exec | Per Call |
|---|
| DB Time(s): | 8.7注释：共8个CPU全满 | 125.2 | 1.27 | 2.49 | | DB CPU(s): | 0.9 | 12.3 | 0.13 | 0.24 | | Background CPU(s): | 0.0 | 0.0 | 0.00 | 0.00 | | Redo size (bytes): | 2,119.9 | 30,352.4 | | | | Logical read (blocks): | 554,994.6 | 7,946,146.4 | | | | Block changes: | 11.5 | 163.9 | | | | Physical read (blocks): | 93.0注释：物理读并不高 | 1,332.2 | | | | Physical write (blocks): | 92.6 | 1,325.6 | | | | Read IO requests: | 13.4 | 191.5 | | | | Write IO requests: | 12.8 | 183.0 | | | | Read IO (MB): | 0.7 | 10.4 | | | | Write IO (MB): | 0.7 | 10.4 | | | | IM scan rows: | 0.0 | 0.0 | | | | Session Logical Read IM: | 0.0 | 0.0 | | | | Global Cache blocks received: | 1.0 | 13.8 | | | | Global Cache blocks read: | 0.0 | 0.1 | | | | Global Cache blocks served: | 0.0 | 0.0 | | | | User calls: | 3.5 | 50.4 | | | | Parses (SQL): | 2.2 | 31.9 | | | | Hard parses (SQL): | 0.1注释：硬解析并不高 | 1.6 | | | | SQL Work Area (MB): | 1.5 | 22.0 | | | | Logons: | 0.3 | 4.0 | | | | User logons: | 0.0 | 0.1 | | | | Executes (SQL): | 6.9 | 98.5 | | | | Rollbacks: | 0.0 | 0.0 | | | | Transactions: | 0.1 | | | |
注释：每秒逻辑读数据块个数非常高（554,994.6）；每事务逻辑读数据块个数也非常高（7,946,146.4）；说明工作负载中有大量结果集很大的报表类查询。 Top 10 Foreground Events by Total Wait Time | Event | Waits | Total Wait Time (sec) | Avg Wait | % DB time | Wait Class |
|---|
| gc buffer busy acquire | 4,475 | 139.9K | 31.26 s | 44.4 | Cluster | | resmgr:cpu quantum | 217,642 | 83.1K | 381.91ms | 26.4 | Scheduler | | DB CPU | | 31K | | 9.8 | | | buffer busy waits | 4,329 | 19.8K | 4562.85ms | 6.3 | Concurrency | | gc buffer busy release | 4,206 | 19.3K | 4585.89ms | 6.1 | Cluster | | direct path write temp | 354,759 | 4376.4 | 12.34ms | 1.4 | User I/O | | optimizer stats update retry | 396 | 4024 | 10.16 s | 1.3 | Other | | direct path read temp | 356,335 | 3541.3 | 9.94ms | 1.1 | User I/O | | gc current block busy | 133 | 1781.2 | 13.39 s | .6 | Cluster | | library cache lock | 3,861 | 631.2 | 163.47ms | .2 | Concurrency |
注释：gc buffer busy acquire / gc current block busy表示请求实例需要等待拥有数据块的实例处理完成某些操作后才能传送数据块。 请求实例也需要把redo log刷回redo log文件后才能从拥有实例传送该一致性数据块拷贝。这种情况下，请验证下面的"Wait Classes by Total Wait Time"，一定能够观察到：Cluster类别占用DBTime一定最大。要本质解决这个问题，一定要减少实例之间的交叉访问。 注释：resmgr:cpu quantum是资源管理器分配会话cpu资源时的等待事件。Oracle为了能够保证自动维护任务有足够的资源来运行，通过资源管理器来限制会话对cpu的使用。按照本工作负载的当前状态，resmgr:cpu quantum这么高，建议禁用资源管理器的限制：alter system set "_resource_manager_always_off"=true。 Wait Classes by Total Wait Time | Wait Class | Waits | Total Wait Time (sec) | Avg Wait Time | % DB time | Avg Active Sessions |
|---|
| Cluster | 128,712 | 161,461 | 1254.43ms | 51.3 | 4.5 | | Scheduler | 219,298 | 83,155 | 379.19ms | 26.4 | 2.3 | | DB CPU | | 30,998 | | 9.8 | 0.9 | | Concurrency | 25,490 | 20,475 | 803.25ms | 6.5 | 0.6 | | User I/O | 2,387,691 | 8,291 | 3.47ms | 2.6 | 0.2 | | Other | 478,853 | 5,289 | 11.04ms | 1.7 | 0.1 | | System I/O | 46,523 | 527 | 11.33ms | .2 | 0.0 | | Administrative | 47 | 7 | 141.85ms | .0 | 0.0 | | Application | 4,237 | 6 | 1.30ms | .0 | 0.0 | | Commit | 121 | 4 | 32.57ms | .0 | 0.0 | | Configuration | 245 | 2 | 10.18ms | .0 | 0.0 | | Network | 70,065 | 1 | 13.04us | .0 | 0.0 |
IO Profile
| Read+Write Per Second | Read per Second | Write Per Second |
|---|
| Total Requests: | 27.6 | 14.5 | 13.1 | | Database Requests: | 26.2 | 13.4 | 12.8 | | Optimized Requests: | 0.0 | 0.0 | 0.0 | | Redo Requests: | | | | | Total (MB): | 1.5 | 0.7 | 0.7 | | Database (MB): | 1.5 | 0.7 | 0.7 | | Optimized Total (MB): | 0.0 | 0.0 | 0.0 | | Redo (MB): | | | | | Database (blocks): | 185.6 | 93.0 | 92.6 | | Via Buffer Cache (blocks): | 3.2 | 3.2 | 0.0 | | Direct (blocks):注释：这项与临时表空间访问相关 | 182.4 | 89.9 | 92.6 |
Database Resource Limits
| Begin | End |
|---|
| CPUs: | 8 | 8 | | SGA Target: | 0 | 0 | | PGA Target: | 802,160,640 | 802,160,640 | | Memory Target | 0 | 0 |
Main Report |
|
3.3 接着是等待事件和等待类概览（称其为第2部分）：
Wait Events StatisticsBack to Top
Time Model Statistics- DB Time represents total time in user calls
- DB CPU represents CPU time of foreground processes
- Total CPU Time represents foreground and background processes
- Statistics including the word "background" measure background process time, therefore do not contribute to the DB time statistic
- Ordered by % of DB time in descending order, followed by Statistic Name
| Statistic Name | Time (s) | % of DB Time | % of Total CPU Time |
|---|
| sql execute elapsed time [1] | 314,061.64 | 99.78 | | | DB CPU | 30,997.57 | 9.85 | 100.00注释：说明数据全程在使用CPU，执行报表查询 | | PL/SQL execution elapsed time [1] | 4,688.54 | 1.49 | | | connection management call elapsed time [1] | 21.77 | 0.01 | | | parse time elapsed [1] | 21.35 | 0.01 | | | hard parse elapsed time [1] | 17.82 | 0.01 | 注释：硬解析并不多 | | hard parse (sharing criteria) elapsed time [1] | 2.17 | 0.00 | | | failed parse elapsed time [1] | 1.22 | 0.00 | | | PL/SQL compilation elapsed time [1] | 0.74 | 0.00 | | | repeated bind elapsed time [1] | 0.11 | 0.00 | | | DB time | 314,757.17 | | | | total CPU time | 30,997.57 | | |
Back to Wait Events Statistics
Back to Top
Foreground Wait Class- s - second, ms - millisecond, us - microsecond, ns - nanosecond
- ordered by wait time desc, waits desc
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
- Captured Time accounts for 98.3% of Total DB time 314,757.17 (s)
- Total FG Wait Time: 278,428.08 (s) DB CPU time: 30,997.57 (s)
| Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait | %DB time |
|---|
| Cluster | 53,020 | 0 | 161,005 | 3036.68ms | 51.15 | | Scheduler | 219,189 | 1 | 83,141 | 379.31ms | 26.41 | | DB CPU | | | 30,998 | | 9.85 | | Concurrency | 20,459 | 52 | 20,416 | 997.90ms | 6.49 | | User I/O | 2,357,860注释：大量的用户IO | 0 | 8,259 | 3.50ms | 2.62 | | Other | 433,735 | 35 | 5,067 | 11.68ms | 1.61 | | System I/O | 45,278 | 0 | 525 | 11.60ms | 0.17 | | Administrative | 47 | 0 | 7 | 141.85ms | 0.00 | | Commit | 120 | 0 | 4 | 32.62ms | 0.00 | | Configuration | 130 | 10 | 2 | 15.24ms | 0.00 | | Application | 2,157 | 19 | 2 | 727.14us | 0.00 | | Network | 68,727 | 0 | 1 | 13.17us | 0.00 |
Back to Wait Events Statistics
Back to Top
Foreground Wait Events- s - second, ms - millisecond, us - microsecond, ns - nanosecond
- Only events with Total Wait Time (s) >= .001 are shown
- ordered by wait time desc, waits desc (idle events last)
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
注释：下面头3条等待事件一定已经在本AWR报告最前面的Load Profile中提现。| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait | Waits /txn | % DB time |
|---|
| gc buffer busy acquire | 4,475 | | 139,869 | 31.26 s | 1.78 | 44.44 | | resmgr:cpu quantum | 217,642 | | 83,121 | 381.91ms | 86.54 | 26.41 | buffer busy waits注释：从本质上讲，这个等待事件的产生仅说明了一个会话在等待一个Buffer（数据块），但是导致这个现象的原因却有很多种。常见的两种是：
当一个会话视图修改一个数据块，但这个数据块正在被另一个会话修改时。
当一个会话需要读取一个数据块，但这个数据块正在被另一个会话读取到内存中时。
微观上（latch）看：当你对这个数据块做修改（不是宏观上的行级锁的概念）的短暂时间内，其他的会话将被阻止对这个数据块上的数据做修改（即使其他用户修改的不是当前用户修改的数据），但是可以以一致性的方式读取这个数据块（from undo）。当前的用户修改完这个数据块后，将会立即释放掉加在这个数据块上的排他锁，这样另一个会话就可以继续修改它。 修改操作是一个非常短暂的时间，这种加锁的机制我们叫 Latch。
当一个会话修改一个数据块时，是按照以下步骤来完成的：
（1）以排他的方式获得这个数据块（Latch） （2）修改这个数据块。（3）释放 Latch。
Buffer busy waits 等待事件常见于数据库中存在的热块的时候，当多个用户频繁地读取或者修改同样的数据块时，这个等待事件就会产生。 如果等待的时间很长，我们在AWR或者statspack报告中就可以看到。
这个等待事件有三个参数。 查看有几个参数我们可以用以下SQL:
SQL> select name, parameter1, parameter2, parameter3 from v$event_name where name='buffer busy waits';
NAME PARAMETER1 PARAMETER2 PARAMETER3
-------------------- ---------- ---------- ----------
buffer busy waits file# block# class#
File#: 等待访问数据块所在的文件id号。
Blocks：等待访问的数据块号。
ID： 在10g之前，这个值表示一个等待时间的原因，10g 之后则表示等待事件的类别。 | 4,329 | | 19,753 | 4562.85ms | 1.72 | 6.28 | | gc buffer busy release注释：在11g以前和gc buffer busy acquire合并在一起 | 4,206 | 0 | 19,288 | 4585.89ms | 1.67 | 6.13 | | direct path write temp注释：这项与临时表空间访问相关，所执行的sql语句中有大量的多表关联，产生了很多中间数据，pga内存中放不下，用到了临时表空间，也有可能是用到了lob字段，在用lob字段的时候，也会用到临时表空间。 | 354,759 | | 4,376 | 12.34ms | 141.06 | 1.39 | | optimizer stats update retry | 396 | 100 | 4,024 | 10.16 s | 0.16 | 1.28 | | direct path read temp注释：这项与临时表空间访问相关 | 356,335 | | 3,541 | 9.94ms | 141.68 | 1.13 | | gc current block busy注释：请求实例需要等待拥有数据块的实例处理完成某些操作后才能传送数据块。 请求实例也需要把redo log刷回redo log文件后才能传送该一致性数据块拷贝。单实例的环境也可能会有buffer busy的情况。 | 133 | | 1,781 | 13.39 s | 0.05 | 0.57 | | library cache lock注释：这是Enqueue的L[A-p]子类等待事件，说明数据库共享池中出现了阻塞和等待，往往由热点块引起。这个等待时间发生在不同用户在共享中由于并发操作同一个数据库对象导致的资源争用的时候。比如当一个用户正在对一个表做DDL操作时，其他的用户如果要访问这张表，就会发生library cache lock等待事件，它要一直等到DDL操作完成后，才能继续操作。这个事件包含四个参数：Handle address: 被加载的对象的地址；Lock address： 锁的地址；Mode： 被加载对象的数据片段；Namespace： 被加载对象在 v$db_object_cache 视图中 namespace 名称。 | 3,861 | 59 | 631 | 163.47ms | 1.54 | 0.20 | | control file sequential read注释：当数据库需要读取控制文件上的信息时，会出现这个等待事件。因为控制文件的信息是顺序写的，所以读取的时候也是顺序的，因此称为控制文件顺序读，它经常发生在以下情况：（1）备份控制文件（2）RAC 环境下不同实例之间控制文件的信息共享（3）读取控制文件的文件头信息（4）读取控制文件其他信息。这个等待事件有三个参数：File#：要读取信息的控制文件的文件号。Block#：读取控制文件信息的起始数据块号。Blocks：需要读取的控制文件数据块数目。 | 37,840 | | 483 | 12.76ms | 15.05 | 0.15 | | PX Deq: Slave Session Stats | 10,088 | | 252 | 25.00ms | 4.01 | 0.08 | | IPC send completion sync | 29,206 | | 218 | 7.46ms | 11.61 | 0.07 | | Disk file Mirror Read | 9,432 | | 180 | 19.08ms | 3.75 | 0.06 | | DLM cross inst call completion | 27,442 | 47 | 162 | 5.91ms | 10.91 | 0.05 | | DFS lock handle | 128 | | 107 | 834.31ms | 0.05 | 0.03 | | KSV master wait | 5,893 | | 87 | 14.76ms | 2.34 | 0.03 | | enq: PS - contention注释：这是Enqueue的PS子类等待事件，说明并行子进程出现了阻塞和等待 | 10,932 | 10 | 85 | 7.77ms | 4.35 | 0.03 | | local write wait | 9,398 | | 68 | 7.27ms | 3.74 | 0.02 | | reliable message | 2,646 | | 55 | 20.81ms | 1.05 | 0.02 | | ASM IO for non-blocking poll | 1,585,205 | | 37 | 23.06us | 630.30 | 0.01 | | db file sequential read注释：按照索引访问出现等待事件。当Oracle需要每次I/O只读取单个数据块这样的操作时，会产生这个等待事件。这个等待事件有三个参数：File#：要读取的数据块锁在数据文件的文件号。Block#：要读取的起始数据块号。Blocks：要读取的数据块数目（这里应该等于 1）。 | 29,513 | | 32 | 1.09ms | 11.73 | 0.01 | | control file parallel write注释：当数据库中有多个控制文件的拷贝时，Oracle需要保证信息同步地写到各个控制文件当中，这是一个并行的物理操作过程。当发生这样的操作时，就会产生control file parallel write等待事件。控制文件频繁写入的原因很多，比如：（1）日志切换太过频繁，导致控制文件信息相应地需要频繁更新。（2）系统I/O出现瓶颈，导致所有I/O出现等待。当系统出现日志切换过于频繁的情形时，可以考虑适当地增大日志文件的大小来降低日志切换频率。当系统出现大量的control file parallel write等待事件时，可以通过比如降低控制文件的拷贝数量，将控制文件的拷贝存放在不同的物理磁盘上的方式来缓解I/O 争用。这个等待事件包含三个参数：Files： Oracle要写入的控制文件个数。Blocks：写入控制文件的数据块数目。Requests：写入控制请求的I/O次数。 | 4,446 | | 28 | 6.22ms | 1.77 | 0.01 | | near PGA limit throttle | 1,547 | 99 | 20 | 12.90ms | 0.62 | 0.01 | | enq: CR - block range reuse ckpt | 2,888 | | 18 | 6.28ms | 1.15 | 0.01 | | latch: cache buffers chains | 815 | | 16 | 19.43ms | 0.32 | 0.01返回 | | gc current block 3-way注释：3个以上实例的Global Cache block requests等待事件。Master实例内存中没有所需要的数据块，需要发送请求给拥有该数据块的实例（就是请求实例和Master实例外的第三方）。 | 1,322 | | 15 | 11.31ms | 0.53 | 0.00 | | kfk: async disk IO | 2,992 | | 15 | 4.97ms | 1.19 | 0.00 | | enq: CF - contention注释：这是Enqueue的CF子类等待事件，说明控制文件的内部事务 | 1,870 | | 14 | 7.56ms | 0.74 | 0.00 | | db file scattered read注释：按照全表访问或者全索引访问出现等待事件 | 4,727 | | 13 | 2.65ms | 1.88 | 0.00 | | row cache lock | 7,789 | 100 | 13 | 1.61ms | 3.10 | 0.00 | | PX Deq: Join ACK | 300 | | 11 | 36.20ms | 0.12 | 0.00 | | gc current grant 2-way注释：master实例发现所有实例中都没有所需要的块，请求实例需要执行IO | 5,683 | | 11 | 1.86ms | 2.26 | 0.00 | | gc cr block busy注释：请求实例需要等待拥有数据块的实例处理完成某些操作后才能传送数据块。 请求实例也需要把redo log刷回redo log文件后才能传送该一致性数据块拷贝。单实例的环境也可能会有buffer busy的情况。 | 2,863 | | 9 | 3.28ms | 1.14 | 0.00 | | gc cr grant 2-way注释：master实例发现所有实例中都没有所需要的块，请求实例需要执行IO | 21,167 | | 9 | 422.99us | 8.42 | 0.00 | | db file single write注释：这个等待事件通常只发生在一种情况下，就是Oracle更新数据文件头信息时（比如发生 Checkpoint）。当这个等待事件很明显时，需要考虑是不是数据库中的数据文件数量太大，导致Oracle需要花较长的时间来做所有文件头的更新操作（checkpoint）。这个等待事件有三个参数：File#: 需要更新的数据块所在的数据文件的文件号。Block#：需要更新的数据块号。Blocks：需要更新的数据块数目（通常来说应该等于 1）。 | 1,482 | | 7 | 4.96ms | 0.59 | 0.00 | | JS kgl get object wait | 47 | | 7 | 141.85ms | 0.02 | 0.00 | | ges inquiry response | 1,482 | | 6 | 3.79ms | 0.59 | 0.00 | | KJC: Wait for msg sends to complete | 7,483 | | 5 | 688.60us | 2.98 | 0.00 | | gc cr multi block mixed | 2,288 | | 5 | 2.22ms | 0.91 | 0.00 | | enq: SW - contention | 1,482 | | 5 | 3.35ms | 0.59 | 0.00 | | gc cr block 3-way注释：3个以上实例的Global Cache block requests等待事件。Master实例内存中没有所需要的数据块，需要发送请求给拥有该数据块的实例（就是请求实例和Master实例外的第三方）。 | 3,594 | | 4 | 1.15ms | 1.43 | 0.00 | log file sync注释：这是一个用户会话行为导致的等待事件，当一个会话发出一个commit 命令时，LGWR 进程会将这个事务产生的redo log从log buffer里面写到磁盘上，以确保用户提交的信息被安全地记录到数据库中。会话发出的commit指令后，需要等待LGWR将这个事务产生的redo成功写入到磁盘之后，才可以继续进行后续的操作，这个等待事件就叫作log file sync。当系统中出现大量的log file sync等待事件时，应该检查数据库中是否有用户在做频繁的提交操作。这种等待事件通常发生在 OLTP 系统上。 OLTP 系统中存在很多小的事务，
如果这些事务频繁被提交，可能引起大量的 log file sync 的等待事件。
这个等待事件包含一个参数： | 120 | | 4 | 32.62ms | 0.05 | 0.00 | | Allocate UGA memory from OS | 167,949 | | 4 | 21.78us | 66.78 | 0.00 | | enq: TS - contention注释：这是Enqueue的TS，与SS类同时产生，说明在临时表空间中排序段中产生 | 59 | 93 | 3 | 55.90ms | 0.02 | 0.00 | library cache pin注释：这个等待事件和library cache lock一样是发生在共享池中并发操作引起的事件。通常来讲，如果Oracle要对一些PL/SQL或者视图这样的对象做重新编译，需要将这些对象pin到共享池中。 如果此时这个对象被其他的用户特有，就会产生一个library cache pin的等待。
这个等待事件也包含四个参数：
Handle address: 被加载的对象的地址。
Lock address：锁的地址。
Mode：被加载对象的数据片段。
Namespace： 被加载对象在v$db_object_cache视图中namespace名称。 | 3,280 | 18 | 3 | 948.14us | 1.30 | 0.00 | | PX Deq: Signal ACK EXT | 300 | | 3 | 9.94ms | 0.12 | 0.00 | | gc cr multi block grant | 4,097 | | 3 | 673.34us | 1.63 | 0.00 | | gc current block 2-way注释：2个实例的Global Cache block requests等待事件。Master实例内存中有所需要的数据块的等待事件。Master实例可以发送该数据块给所需要的实例。 | 584 | | 2 | 3.81ms | 0.23 | 0.00 | | gc cr block lost注释：内连网故障 | 3 | | 2 | 648.05ms | 0.00 | 0.00 | | Free private memory to OS | 10,341 | | 2 | 187.36us | 4.11 | 0.00 | | enq: SS - contention注释：这是Enqueue的SS子类等待事件，说明在临时表空间中排序段中产生 | 97 | | 2 | 19.85ms | 0.04 | 0.00 | | CSS initialization | 392 | | 2 | 4.46ms | 0.16 | 0.00 | | PX Deq: reap credit | 135,218 | 100 | 2 | 12.88us | 53.76 | 0.00 | | gc current grant busy | 411 | | 2 | 4.20ms | 0.16 | 0.00 | | Disk file operations I/O | 6,200 | | 2 | 246.13us | 2.47 | 0.00 | | gc cr block 2-way注释：2个实例的Global Cache block requests等待事件。Master实例内存中有所需要的数据块的等待事件。Master实例可以发送该数据块给所需要的实例。 | 1,584 | | 1 | 897.51us | 0.63 | 0.00 | | enq: TM - contention注释：这是Enqueue的TM子类等待事件，说明DML enqueue | 1,973 | 12 | 1 | 670.30us | 0.78 | 0.00 | db file parallel read注释：这是一个很容易引起误导的等待事件，实际上这个等待事件和并行操作（比如并行查询，并行 DML）没有关系。 这个事件发生在数据库恢复的时候，当有一些数据块需要恢复的时候，Oracle 会以并行的方式把他们从数据文件中读入到内存中进行恢复操作。
这个等待事件包含三个参数：
Files： 操作需要读取的文件个数。
Blocks： 操作需要读取的数据块个数。
Requests：操作需要执行的I/O次数。 | 588 | | 1 | 2.14ms | 0.23 | 0.00 | | gc cr block direct read | 306 | | 1 | 3.55ms | 0.12 | 0.00 | SQL*Net message to client注释：这个等待事件发生在服务器端向客户端发送消息的时候。当服务器端向客户端发送消息产生等待时，可能的原因是用户端太繁忙，无法及时接收服务器端送来的消息，也可能是网络问题导致消息无法从服务器端发送到客户端。
这个等待事件有两个参数：
Driver id: 服务器端和客户端连接使用的协议信息。
#bytes: 服务器端向客户端发送消息的字节数。 | 66,812 | | 1 | 13.28us | 26.57 | 0.00 | direct path read注释：这个等待事件发生在会话将数据块直接读取到PGA当中而不是SGA中的情况，这些被读取的数据通常是这个会话私有的数据，所以不需要放到SGA作为共享数据。 这些数据通常是来自与临时段上的数据，比如一个会话中SQL 的排序数据、并行执行过程中间产生的数据以及 Hash Join、merge join产生的排序数据，因为这些数据只对当前的会话的SQL操作有意义，所以不需要放到 SGA 当中。当发生direct path read等待事件时，意味着磁盘上有大量的临时数据产生，比如排序、并行执行等操作。 或者意味着PGA中空闲空间不足。
这个等待事件有三个参数：
Descriptor address: 一个指针，指向当前会话正在等待的一个 direct read I/O。
First dba:descriptor address 中最旧的一个 I/O 数据块地址。
Block cnt: descriptor address 上下文中涉及的有效的 buffer 数量。 | 88 | | 1 | 9.75ms | 0.03 | 0.00 | | gc current retry | 4 | | 1 | 167.40ms | 0.00 | 0.00 | | gc current multi block request注释：1个请求访问多个数据块，一般是全表扫描或者全索引扫描。 | 182 | | 1 | 3.49ms | 0.07 | 0.00 | | enq: PE - contention注释：这是Enqueue的PE子类等待事件，说明Alter system set parameter =value时产生的 | 68 | | 1 | 8.57ms | 0.03 | 0.00 | | CSS operation: action | 392 | | 1 | 1.42ms | 0.16 | 0.00 | | library cache load lock | 1 | | 0 | 475.18ms | 0.00 | 0.00 | latch free注释：在10g之前的版本里，latch free等待事件代表了所有的latch等待。在10g以后，一些常用的latch事件已经被独立了出来：
SQL> select name from v$event_name where name like 'latch%' order by 1;
NAME
----------------------------------------------------------------
latch activity
latch free
latch: Change Notification Hash table latch
latch: In memory undo latch
latch: MQL Tracking Latch
latch: PX hash array latch
latch: Undo Hint Latch
latch: WCR: processes HT
latch: WCR: sync
latch: cache buffer handles
latch: cache buffers chains
latch: cache buffers lru chain
latch: call allocation
latch: change notification client cache latch
latch: checkpoint queue latch
latch: enqueue hash chains
latch: gc element
latch: gcs resource hash
latch: ges resource hash list
latch: lob segment dispenser latch
latch: lob segment hash table latch
latch: lob segment query latch
latch: messages
latch: object queue header operation
latch: parallel query alloc buffer
latch: redo allocation
latch: redo copy
latch: redo writing
latch: row cache objects
latch: session allocation
latch: shared pool
latch: undo global data
latch: virtual circuit queues
已选择 33 行。
所以latch free等待事件在10g以后的版本中并不常见，而是以具体的Latch等待事件出现。
这个等待事件有三个参数：
Address: 会话等待的 latch 地址。
Number： latch 号，通过这个号，可以从 v$latchname视图中找到这个latch的相关的信息。
SQL> select * from v$latchname where latch#=number;
Tries: 会话尝试获取 Latch 的次数。 | 114 | | 0 | 4.01ms | 0.05 | 0.00 | | CSS operation: query | 1,176 | | 0 | 278.93us | 0.47 | 0.00 | direct path write注释：这个等待事件和direct path read正好相反，是会话将一些数据从PGA中直接写入到磁盘文件上，而不经过SGA。这种情况通常发生在：
（1）使用临时表空间排序（内存不足）
（2）数据的直接加载（使用 append 方式加载数据）
（3）并行DML操作。
这个等待事件有三个参数：
Descriptor address: 一个指针，指向当前会话正在等待的一个direct I/O。
First dba: descriptor address中最旧的一个 I/O 数据块地址。
Block cnt: descriptor address上下文中涉及的有效地 buffer 数量。 | 130 | | 0 | 1.93ms | 0.05 | 0.00 | | enq: RC - Result Cache: Contention | 176 | 99 | 0 | 1.38ms | 0.07 | 0.00 | | resmgr:internal state change | 2 | 100 | 0 | 111.68ms | 0.00 | 0.00 | | enq: MA - MMON Autotask setting | 116 | | 0 | 1.92ms | 0.05 | 0.00 | | gc cr grant congested | 33 | | 0 | 6.44ms | 0.01 | 0.00 | | enq: TX - index contention注释：这是Enqueue的PE子类等待事件，说明更新索引产生的事务等待 | 310 | | 0 | 677.43us | 0.12 | 0.00 | | enq: OD - Serializing DDLs | 349 | | 0 | 563.10us | 0.14 | 0.00 | | latch: ges resource hash list | 24 | | 0 | 5.57ms | 0.01 | 0.00 | | enq: MM - MMON Autotask scheduling | 118 | | 0 | 876.77us | 0.05 | 0.00 | | Allocate PGA memory from OS | 7,313 | | 0 | 13.35us | 2.91 | 0.00 | | enq: JS - job run lock - synchronize注释：这是Enqueue的JS子类等待事件，说明scheduler作业运行锁 | 50 | 100 | 0 | 1.92ms | 0.02 | 0.00 | | enq: FB - contention | 44 | | 0 | 1.27ms | 0.02 | 0.00 | | enq: ZH - compression analysis | 119 | 100 | 0 | 463.74us | 0.05 | 0.00 | | enq: HW - contention注释：这是Enqueue的HW子类等待事件，说明高水位线锁 | 33 | 39 | 0 | 1.66ms | 0.01 | 0.00 | | gc current grant congested | 8 | | 0 | 6.29ms | 0.00 | 0.00 | | read by other session | 3 | | 0 | 16.33ms | 0.00 | 0.00 | | ASM file metadata operation | 2,964 | | 0 | 15.39us | 1.18 | 0.00 | | gc cr disk read | 67 | | 0 | 622.42us | 0.03 | 0.00 | | Allocate CGA memory from OS | 2,231 | | 0 | 17.92us | 0.89 | 0.00 | | IPC group service call | 1,915 | | 0 | 9.25us | 0.76 | 0.00 | | gc cr block congested注释：因为CPU或者内存不够导致LMS进程跟进不及请求 | 2 | | 0 | 8.39ms | 0.00 | 0.00 | | library cache: mutex X | 51 | | 0 | 290.31us | 0.02 | 0.00 | | Compression analysis | 140 | | 0 | 98.19us | 0.06 | 0.00 | | enq: TO - contention注释：这是Enqueue的TO子类等待事件，说明临时表对象入队等待 | 22 | 50 | 0 | 599.45us | 0.01 | 0.00 | | datafile move cleanup during resize | 1,482 | | 0 | 8.84us | 0.59 | 0.00 | | enq: TQ - DDL contention | 8 | 50 | 0 | 1.14ms | 0.00 | 0.00 | | gc current block congested注释：因为CPU或者内存不够导致LMS进程跟进不及请求 | 1 | | 0 | 5.54ms | 0.00 | 0.00 | | Allocate DGA memory from OS | 296 | | 0 | 18.27us | 0.12 | 0.00 | | latch: shared pool | 21 | | 0 | 240.38us | 0.01 | 0.00 | | gc obj ckpt direct read | 7 | | 0 | 564.86us | 0.00 | 0.00 | | enq: US - contention注释：这是Enqueue的US子类等待事件，说明Undo段等待事件 | 5 | | 0 | 673.20us | 0.00 | 0.00 | SQL*Net break/reset to client注释：当出现这个等待事件时，说明服务器端在给客户端发送一个断开连接或者重置连接的请求，正在等待客户的响应，通常的原因是服务器到客户端的网络不稳定导致的。
这个等待事件包含两个参数：
Driver id: 服务器和客户端连接使用的协议信息。
Break？：零表示服务端向客户端发送一个重置（reset）信息，非零表示服务器端向客户端发送一个断开（break）消息。 | 8 | | 0 | 293.75us | 0.00 | 0.00 | | rdbms ipc reply | 1 | | 0 | 2.01ms | 0.00 | 0.00 | SQL*Net message from client注释:这个等待事件基本上是最常见的一个等待事件。当一个会话建立成功后，客户端会向服务器端发送请求，服务器端处理完客户端请求后，将结果返回给客户端，并继续等待客户端的请求，这时候会产生 SQL*Net message from client等待事件。很显然，这是一个空闲等待，如果客户端不再向服务器端发送请求，服务器端将一直处于这个等待事件状态。
这个等待事件包含两个参数：
Driver id: 服务器端和客户端连接使用的协议信息。
#bytes: 服务器端接收到的来自客户端消息的字节数。 | 66,897 | | 275,362 | 4116.20ms | 26.60 | | | PX Deq: Execution Msg | 29,363 | | 1,712 | 58.31ms | 11.68 | | | PX Deq: Execute Reply | 300 | | 8 | 27.29ms | 0.12 | | | PX Deq: Parse Reply | 299 | | 1 | 4.25ms | 0.12 | | | PX Deq Credit: send blkd | 174 | | 1 | 4.81ms | 0.07 | | | PX Deq: Msg Fragment | 28 | | 0 | 1.59ms | 0.01 | |
Back to Wait Events Statistics
Back to Top
Service Statistics| Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
|---|
| pdb1_1 | 309,847 | 30,911 | 3,223 | 19,977,863 |
Back to Wait Events Statistics
Back to Top
Service Wait Class Stats- Wait Class info for services in the Service Statistics section.
- Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
- Time Waited (Wt Time) in seconds
| Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
|---|
| pdb1_1 | 2313521 | 8226 | 5345 | 19781 | 0 | 0 | 68445 | 1 |
Back to Wait Events Statistics
Back to Top
Top Process Types by Wait ClassNo data exists for this section of the report. Back to Wait Events Statistics
Back to Top
Top Process Types by CPU UsedNo data exists for this section of the report. |
|
3.4 接着是各种TOP SQL（称其为第3部分）： 对于RAC系统，“SQL ordered by Cluster Wait Time”是首先需要看的。其次，如果从前面的分析来看逻辑读很高的系统，应该关注“SQL ordered by Gets”。通过观察这两段，我们会发现结果都指向标记为“DWH_TEST”模块的SQL语句。这些语句在工作负载脚本中可以找到： .........
PROMPT @Statement 1
execute dbms_application_info.set_module('DWH_TEST','1');
SET TIMING ON;
SELECT DISTINCT
'B' || t1.pg_featurevalue_15_id pg_featurevalue_15_id
FROM
lu_pg_featurevalue_15 t1,
lu_elementrange_rel t2
WHERE
/* Attribute Joins */
((t1.pg_featurevalue_15_num BETWEEN t2.lbound AND t2.ubound)
)
/* Attribute Filters */
AND ((t1.pg_featurevalue_15_id = 1485)
AND (t2.elementrange_id = 3091)
)
/
PROMPT @1 Results in 15 Ticks
...... |
|
SQL StatisticsSQL ordered by Elapsed Time [1]SQL ordered by CPU TimeSQL ordered by User I/O Wait Time注释：这一部分，通过Buffer Gets对SQL语句进行排序，即通过它执行了多少个逻辑I/O来排序。顶端的注释表明一个PL/SQL单元的缓存获得值(Buffer Gets)包括被这个代码块执行的所有SQL语句的Buffer Gets的总和。因此将经常在这个列表的顶端看到PL/SQL过程，因为存储过程执行的单独的语句的数目被总计出来。在这里的Buffer Gets是一个累积值，所以这个值大并不一定意味着这条语句的性能存在问题。通常我们可以通过对比该条语句的Buffer Gets和physical reads值，如果这两个比较接近，肯定这条语句是存在问题的，我们可以通过执行计划来分析，为什么physical reads的值如此之高。另外，我们在这里也可以关注gets per exec的值，这个值如果太大，表明这条语句可能使用了一个比较差的索引或者使用了不当的表连接。另外说明一点：大量的逻辑读往往伴随着较高的CPU消耗。所以很多时候我们看到的系统CPU将近100％的时候，很多时候就是SQL语句造成的，这时候我们可以分析一下这里逻辑读大的SQL。可以补充执行下面的top-N分析：
select * from (select sql_text, buffer_gets,executions, buffer_gets/executions "Gets/Exec", hash_value,address from v$sqlarea where buffer_gets > 0 and executions>0 order by buffer_gets desc) where rownum <= 10 ; SQL ordered by GetsSQL ordered by ReadsSQL ordered by Physical Reads (UnOptimized)SQL ordered by ExecutionsSQL ordered by Parse CallsSQL ordered by Sharable MemorySQL ordered by Version CountSQL ordered by Cluster Wait Time- %Total - Cluster Time as a percentage of Total Cluster Wait Time
- %Clu - Cluster Time as a percentage of Elapsed Time
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Only SQL with Cluster Wait Time > .005 seconds is reported
- Total Cluster Wait Time (s): 161,461
- Captured SQL account for 88.0% of Total
| Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | PDB Name | SQL Text |
|---|
| 41,593.49 | 0 | 25.76 | 47,835.25 | 86.95 | 0.74 | 1.33 | a1mcngaa6g04d | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 17,213.41 | 82 | 10.66 | 27,011.67 | 63.73 | 1.37 | 18.42 | 3k1n2xbztndym | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 15,765.95 | 72 | 9.76 | 18,635.76 | 84.60 | 1.98 | 0.56 | 9p3s9zpauapaz | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 15,664.15 | 63 | 9.70 | 18,124.39 | 86.43 | 1.85 | 0.49 | 35897c7tmkw5b | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 8,219.14 | 59 | 5.09 | 9,364.49 | 87.77 | 0.25 | 2.19 | d5q3qysdyx4jh | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 8,184.50 | 79 | 5.07 | 10,523.60 | 77.77 | 3.67 | 1.15 | 8m59bm5u6cn5w | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 6,224.91 | 38 | 3.86 | 10,755.92 | 57.87 | 11.30 | 0.78 | ck10abbs61x2y | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 5,190.78 | 80 | 3.21 | 7,772.12 | 66.79 | 4.97 | 1.56 | 18xa03m9xbknb | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 4,571.39 | 31 | 2.83 | 5,036.57 | 90.76 | 0.04 | 0.72 | 1a4ybm30xx9d5 | DWH_TEST | | SELECT 'G' || tt1.pg_featureva... | | 3,293.21 | 116 | 2.04 | 11,697.84 | 28.15 | 35.84 | 1.96 | g4dzf4ak4rus2 | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 2,508.29 | 79 | 1.55 | 3,371.87 | 74.39 | 3.39 | 1.87 | d5yh78d4tm97t | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 2,387.57 | 114 | 1.48 | 2,731.50 | 87.41 | 1.28 | 2.05 | cx163n0q04xz7 | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 1,923.35 | 107 | 1.19 | 2,244.50 | 85.69 | 2.12 | 3.65 | dvaxhpys7hpdr | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 1,894.58 | 30 | 1.17 | 3,060.27 | 61.91 | 4.70 | 2.25 | 0sffus2ht1c6g | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 1,799.65 | 70 | 1.11 | 2,260.54 | 79.61 | 3.40 | 1.05 | 4rj7qd9v41xwv | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 1,110.21 | 45 | 0.69 | 1,220.48 | 90.97 | 1.00 | 0.10 | 31mpwzx6zagu9 | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 813.01 | 113 | 0.50 | 927.16 | 87.69 | 4.16 | 0.32 | 8sdpvnyhd517x | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 680.39 | 30 | 0.42 | 913.16 | 74.51 | 1.62 | 4.47 | 6cc0h14rg1dhm | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 670.73 | 116 | 0.42 | 775.84 | 86.45 | 4.99 | 0.26 | fvnrcp2jfx8ng | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 607.23 | 79 | 0.38 | 962.02 | 63.12 | 6.49 | 3.37 | 3k94fcrq15bn8 | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 586.71 | 28 | 0.36 | 1,363.52 | 43.03 | 8.64 | 4.52 | 2usz531vcurba | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 526.73 | 110 | 0.33 | 634.42 | 83.03 | 5.36 | 0.75 | amny7vwjss6pp | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 504.61 | 144 | 0.31 | 1,295.01 | 38.97 | 25.75 | 6.14 | 1wfywkvcwm2sp | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 85.95 | 28 | 0.05 | 234.54 | 36.64 | 7.73 | 4.43 | aknqqby70qycf | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 77.87 | 116 | 0.05 | 8,561.11 | 0.91 | 47.77 | 2.53 | gkc6w4zhaysbk | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 31.24 | 1 | 0.02 | 4,800.85 | 0.65 | 1.46 | 0.64 | b6usrg82hwsa3 | DBMS_SCHEDULER | | call dbms_stats.gather_databas... | | 6.65 | 106 | 0.00 | 46.42 | 14.32 | 62.95 | 3.23 | 0mcv88ft7fwdj | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 5.35 | 1 | 0.00 | 5.81 | 92.21 | 7.43 | 2.43 | 8cr243sx13k29 | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 3.72 | 792 | 0.00 | 4.23 | 88.00 | 6.41 | 0.84 | 05d0ckrja68sf | | | insert into wrm$_snapshot_deta... | | 2.03 | 1 | 0.00 | 3.85 | 52.81 | 19.08 | 34.11 | d19rk4sktfua9 | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 1.97 | 1 | 0.00 | 4.19 | 46.97 | 19.92 | 38.97 | 5c6cnq24fd3ky | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 1.64 | 2 | 0.00 | 3.39 | 48.49 | 23.46 | 34.78 | dkkjcm8tkkcn9 | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 1.56 | 1 | 0.00 | 3.19 | 48.75 | 57.02 | 1.87 | 6f6n75f1u5m66 | dbms_stats: gather table stats | | /* SQL Analyze(1) */ select /*... | | 1.24 | 198 | 0.00 | 1.40 | 88.95 | 10.53 | 2.03 | 9mb61uqwwqkpj | | | select spare6 from sys.user$ w... | | 1.21 | 106 | 0.00 | 48.47 | 2.49 | 69.53 | 0.00 | 3697scqj06htr | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 0.97 | 5 | 0.00 | 1.29 | 74.63 | 18.45 | 4.91 | 855yvjgw89nfy | | | insert into WRH$_SYSSTAT (dbid... | | 0.89 | 106 | 0.00 | 48.11 | 1.85 | 69.44 | 0.00 | cpm5u0m6b68k5 | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 0.89 | 2 | 0.00 | 1.14 | 77.76 | 26.55 | 3.00 | 5wxcyhw03vujg | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.85 | 1 | 0.00 | 1.81 | 47.01 | 19.82 | 39.25 | g02hdnrf4vqwu | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.82 | 2 | 0.00 | 1.84 | 44.57 | 22.53 | 39.13 | 03f0xz9suw8y0 | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.80 | 67 | 0.00 | 1.00 | 80.30 | 8.99 | 4.72 | 940z2hvaxsgcf | SQL*Plus | | INSERT INTO AUDSYS.AUD$UNIFIED... | | 0.77 | 5 | 0.00 | 1.01 | 76.31 | 17.77 | 1.78 | 1zb651a37ccgg | | | insert into wrh$_latch (dbid, ... | | 0.77 | 2 | 0.00 | 1.45 | 52.88 | 21.45 | 31.43 | 4z8dvnff7u3a8 | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.74 | 106 | 0.00 | 47.97 | 1.54 | 61.43 | 11.07 | 9wgj8btxt2122 | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 0.65 | 106 | 0.00 | 48.65 | 1.34 | 65.46 | 10.49 | 3gshh31g2s0x8 | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 0.64 | 198 | 0.00 | 1.12 | 57.45 | 23.36 | 0.16 | 8btyg0wy808ch | sqlplus@classroom.example.com (TNS V1-V3) | | update sys.user$ set spare1=sp... | | 0.49 | 110 | 0.00 | 50.11 | 0.98 | 67.81 | 0.00 | 7866641pah2zg | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 0.49 | 106 | 0.00 | 53.01 | 0.92 | 70.17 | 0.00 | 0mw3vsxnp7nus | DWH_TEST | | SELECT /* ORDERED INDEX(t1) US... | | 0.38 | 1 | 0.00 | 1.39 | 27.63 | 20.73 | 55.14 | 5x6gfk5dx6wzx | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.38 | 1 | 0.00 | 0.77 | 48.93 | 18.93 | 38.64 | 64vr0v7tjzd0s | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.37 | 85 | 0.00 | 391.47 | 0.10 | 41.23 | 30.65 | cfpq31sqmf3xt | DWH_TEST | | SELECT 'B' || tt1.ch_featureva... | | 0.36 | 1 | 0.00 | 4.73 | 7.54 | 84.00 | 7.17 | d2wx5xdwznapp | DBMS_SCHEDULER | | MERGE /*+ dynamic_sampling(ST ... | | 0.34 | 1,791 | 0.00 | 2.22 | 15.54 | 77.90 | 4.37 | 4y1y43113gv8f | | | delete from histgrm$ where obj... | | 0.34 | 2 | 0.00 | 0.72 | 47.33 | 22.68 | 36.38 | f2kr8yywhz7ba | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.33 | 1 | 0.00 | 0.82 | 40.83 | 19.82 | 45.18 | d0ks8bd50160r | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.30 | 1 | 0.00 | 1.68 | 17.85 | 41.28 | 41.89 | bf995fzyzbp7a | DBMS_SCHEDULER | | MERGE /*+ dynamic_sampling(4) ... | | 0.28 | 10 | 0.00 | 0.28 | 98.70 | 1.69 | 0.00 | 886z1skgcg92m | sys$cic | | SELECT MULTI_PLANS_BV_SEG_COUN... | | 0.25 | 5 | 0.00 | 0.48 | 52.28 | 30.20 | 13.81 | agw6jz8y9t6qr | | | insert into WRH$_EVENT_HISTOGR... | | 0.25 | 1 | 0.00 | 0.76 | 32.95 | 20.90 | 51.45 | 2z6ntg7bsdxvf | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.25 | 3 | 0.00 | 0.32 | 77.96 | 16.26 | 1.17 | 2z5wq6272zuat | | | insert into wrh$_system_event ... | | 0.25 | 1 | 0.00 | 0.60 | 41.42 | 21.26 | 43.59 | 0a5g1vr22r0zk | dbms_stats: gather index stats | | select /*+ opt_param('_optimiz... | | 0.24 | 62 | 0.00 | 0.34 | 71.73 | 23.78 | 0.20 | dt26ufwkgd2qr | | | insert into UMF$_ATSK_HIST(db... | | 0.24 | 58 | 0.00 | 0.51 | 46.37 | 42.78 | 20.29 | c7fnaqcmbm0b5 | MMON_SLAVE | | SELECT SUM(NUM_MAPPINGS+1) FRO... | | 0.24 | 492 | 0.00 | 8.88 | 2.66 | 16.49 | 0.00 | fhf8upax5cxsz | sys$bsg_timeout | | BEGIN sys.dbms_auto_report_int...
|
|
|
3.5 实例级别的统计信息（供参考就好）（称其为第4部分）： Cloud Control默认只是生成第1个实例的信息。基本可以验证之前的发现。如果要生成其他节点的实例级别AWR报告，请自行执行如下脚本：@$ORACLE_HOME/rdbms/admin/awrrpti.sql。
Instance Activity StatisticsBack to Top
Key Instance Activity Stats- Ordered by statistic name
| Statistic | Total | per Second | per Trans |
|---|
| db block changes | 412,176 | 11.45 | 163.89 | | execute count | 247,595 | 6.88 | 98.45 | | gc cr block receive time | 8,754 | 0.24 | 3.48 | | gc cr blocks received | 32,604 | 0.91 | 12.96 | | gc current block receive time | 179,828 | 4.99 | 71.50 | | gc current blocks received | 2,098 | 0.06 | 0.83 | | logons cumulative | 10,009 | 0.28 | 3.98 | | opened cursors cumulative | 247,205 | 6.87 | 98.29 | | parse count (total) | 80,118 | 2.22 | 31.86 | | parse time elapsed | 990 | 0.03 | 0.39 | | physical reads | 3,350,399 | 93.04 | 1,332.17 | | physical writes | 3,333,904 | 92.59 | 1,325.61 | | redo size | 76,336,156 | 2,119.94 | 30,352.35 | | session cursor cache hits | 192,177 | 5.34 | 76.41 | | session logical reads | 19,984,558,082 | 554,994.59 | 7,946,146.35 | | user calls | 126,629 | 3.52 | 50.35 | | user commits | 2,513 | 0.07 | 1.00 | | user rollbacks | 2 | 0.00 | 0.00 | | workarea executions - onepass | 3,097 | 0.09 | 1.23 | | workarea executions - optimal | 63,140 | 1.75 | 25.11 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats- Ordered by statistic name
| Statistic | Total | per Second | per Trans |
|---|
| ASSM cbk:blocks examined | 3,281 | 0.09 | 1.30 | | ASSM cbk:blocks marked full | 773 | 0.02 | 0.31 | | ASSM gsp:L1 bitmaps examined | 3,041 | 0.08 | 1.21 | | ASSM gsp:L2 bitmap full | 20 | 0.00 | 0.01 | | ASSM gsp:L2 bitmaps examined | 1,212 | 0.03 | 0.48 | | ASSM gsp:Search all | 46 | 0.00 | 0.02 | | ASSM gsp:Search hint | 18 | 0.00 | 0.01 | | ASSM gsp:Search steal | 28 | 0.00 | 0.01 | | ASSM gsp:bump HWM | 28 | 0.00 | 0.01 | | ASSM gsp:get free block | 2,724 | 0.08 | 1.08 | | ASSM gsp:good hint | 1,922 | 0.05 | 0.76 | | ASSM gsp:reject db | 1 | 0.00 | 0.00 | | ASSM rsv:fill reserve | 2 | 0.00 | 0.00 | | ASSM wasted db state change | 116 | 0.00 | 0.05 | | Batched IO (bound) vector count | 62 | 0.00 | 0.02 | | Batched IO (full) vector count | 0 | 0.00 | 0.00 | | Batched IO block miss count | 779 | 0.02 | 0.31 | | Batched IO buffer defrag count | 0 | 0.00 | 0.00 | | Batched IO double miss count | 85 | 0.00 | 0.03 | | Batched IO same unit count | 220 | 0.01 | 0.09 | | Batched IO single block count | 67 | 0.00 | 0.03 | | Batched IO vector block count | 500 | 0.01 | 0.20 | | Batched IO vector read count | 80 | 0.00 | 0.03 | | Block Cleanout Optim referenced | 66 | 0.00 | 0.03 | | CCursor + sql area evicted | 1,470 | 0.04 | 0.58 | | CCursor + sql area evicted - failed | 3,254 | 0.09 | 1.29 | | CPU used by this session | 3,102,956 | 86.17 | 1,233.78 | | CPU used when call started | 3,095,378 | 85.96 | 1,230.77 | | CR blocks created | 28 | 0.00 | 0.01 | | Cached Commit SCN referenced | 5,723,426,005 | 158,946.24 | 2,275,716.11 | | Client Advertised Receive Window | 1,512 | 0.04 | 0.60 | | Client Advertised Send Window | 1,512 | 0.04 | 0.60 | | Client Data Segments In | 71,154 | 1.98 | 28.29 | | Client Data Segments Out | 81,827 | 2.27 | 32.54 | | Client Path Maximum Transmission Unit(MTU) | 324,000 | 9.00 | 128.83 | | Client Send Congestion Window | 2,160 | 0.06 | 0.86 | | Client Time (usec) Busy Sending Data | 190,835,000 | 5,299.71 | 75,878.73 | | Client Time (usec) Round Trip Time | 360,915 | 10.02 | 143.50 | | Client Time (usec) Round Trip Time Variance | 331,403 | 9.20 | 131.77 | | Client Total Bytes Acked | 28,505,007 | 791.62 | 11,334.00 | | Client Total Bytes Received | 31,112,637 | 864.03 | 12,370.83 | | Client Total Number of Retransmitted Packets | 501 | 0.01 | 0.20 | | Commit SCN cached | 116 | 0.00 | 0.05 | | DFO trees parallelized | 50 | 0.00 | 0.02 | | Effective IO time | 858,307 | 23.84 | 341.28 | | HSC Heap Segment Block Changes | 82,778 | 2.30 | 32.91 | | Heap Segment Array Inserts | 1,179 | 0.03 | 0.47 | | Heap Segment Array Updates | 516 | 0.01 | 0.21 | | KTFB alloc req | 43 | 0.00 | 0.02 | | KTFB alloc space (block) | 24,117,248 | 669.76 | 9,589.36 | | KTFB alloc time (ms) | 10,232 | 0.28 | 4.07 | | KTFB apply req | 10 | 0.00 | 0.00 | | KTFB apply time (ms) | 87 | 0.00 | 0.03 | | LOB table id lookup cache misses | 108 | 0.00 | 0.04 | | Number of read IOs issued | 204 | 0.01 | 0.08 | | PX local messages recv'd | 374 | 0.01 | 0.15 | | PX local messages sent | 477 | 0.01 | 0.19 | | PX remote messages recv'd | 19,826 | 0.55 | 7.88 | | PX remote messages sent | 19,972 | 0.55 | 7.94 | | Parallel operations not downgraded | 50 | 0.00 | 0.02 | | Requests to/from client | 66,890 | 1.86 | 26.60 | | SCN increments due to another database | 60,334 | 1.68 | 23.99 | | SQL*Net roundtrips to/from client | 66,812 | 1.86 | 26.57 | | SV Ordered Sequence X gets | 40 | 0.00 | 0.02 | | Session total flash IO requests | 983,654 | 27.32 | 391.11 | | TBS Extension: bytes extended | 10,485,760 | 291.20 | 4,169.29 | | TBS Extension: files extended | 1 | 0.00 | 0.00 | | TBS Extension: tasks created | 11 | 0.00 | 0.00 | | TBS Extension: tasks executed | 11 | 0.00 | 0.00 | | Temp Space Dealloc Extents | 2,604 | 0.07 | 1.04 | | Temp Space Prewarm Extents | 200 | 0.01 | 0.08 | | Temp Space Prewarm Request | 2 | 0.00 | 0.00 | | Temp Space Rebalance Request | 46 | 0.00 | 0.02 | | active txn count during cleanout | 913 | 0.03 | 0.36 | | blocks cleaned out using minact | 2,547 | 0.07 | 1.01 | | branch node splits | 2 | 0.00 | 0.00 | | buffer is not pinned count | 9,996,047,945 | 277,601.96 | 3,974,571.75 | | buffer is pinned count | 24,262,098,306 | 673,786.89 | 9,646,957.58 | | bytes received via SQL*Net from client | 26,078,167 | 724.22 | 10,369.05 | | bytes sent via SQL*Net to client | 29,140,288 | 809.26 | 11,586.60 | | calls to get snapshot scn: kcmgss | 347,569 | 9.65 | 138.20 | | calls to kcmadj | 9,612 | 0.27 | 3.82 | | calls to kcmgas | 7,650 | 0.21 | 3.04 | | calls to kcmgcs | 229,366 | 6.37 | 91.20 | | cell physical IO interconnect bytes | 83,033,006,080 | 2,305,923.84 | 33,015,111.76 | | cell physical read IO requests for temp IO | 445,924 | 12.38 | 177.31 | | change write time | 392 | 0.01 | 0.16 | | cleanout - number of ktugct calls | 5,531 | 0.15 | 2.20 | | cleanouts and rollbacks - consistent read gets | 6 | 0.00 | 0.00 | | cleanouts only - consistent read gets | 4,553 | 0.13 | 1.81 | | cluster key scan block gets | 176,208 | 4.89 | 70.06 | | cluster key scans | 118,380 | 3.29 | 47.07 | | commit batch/immediate performed | 3 | 0.00 | 0.00 | | commit batch/immediate requested | 3 | 0.00 | 0.00 | | commit cleanout failures: block lost | 124 | 0.00 | 0.05 | | commit cleanout failures: callback failure | 117 | 0.00 | 0.05 | | commit cleanout failures: cannot pin | 1 | 0.00 | 0.00 | | commit cleanouts | 20,737 | 0.58 | 8.25 | | commit cleanouts successfully completed | 20,651 | 0.57 | 8.21 | | commit immediate performed | 3 | 0.00 | 0.00 | | commit immediate requested | 3 | 0.00 | 0.00 | | commit txn count during cleanout | 6,610 | 0.18 | 2.63 | | consistent changes | 7,370 | 0.20 | 2.93 | | consistent gets direct | 11,809 | 0.33 | 4.70 | | consistent gets examination (fastpath) | 394,992,354 | 10,969.40 | 157,054.61 | | consistent gets from cache | 19,983,966,705 | 554,978.16 | 7,945,911.21 | | consistent gets pin (fastpath) | 19,588,927,850 | 544,007.47 | 7,788,838.11 | | control file blocks written | 8,904 | 0.25 | 3.54 | | control file cache search for read hit | 235,305 | 6.53 | 93.56 | | control file cache search for read miss | 93 | 0.00 | 0.04 | | control file exclusive latch success | 120 | 0.00 | 0.05 | | control file read req (single-block) | 37,822 | 1.05 | 15.04 | | control file read req (single-block) no enqueue | 38,933 | 1.08 | 15.48 | | cursor authentications | 1,080 | 0.03 | 0.43 | | cursor reload failures | 17 | 0.00 | 0.01 | | data blocks consistent reads - undo records applied | 1,654 | 0.05 | 0.66 | | db block changes | 412,176 | 11.45 | 163.89 | | db block gets | 295,078 | 8.19 | 117.33 | | db block gets direct | 1,320 | 0.04 | 0.52 | | db block gets from cache | 401,404 | 11.15 | 159.60 | | db block gets from cache (fastpath) | 297,720 | 8.27 | 118.38 | | deferred (CURRENT) block cleanout applications | 10,880 | 0.30 | 4.33 | | dirty buffers inspected | 4,263 | 0.12 | 1.70 | | enqueue conversions | 4,638 | 0.13 | 1.84 | | enqueue releases | 74,587 | 2.07 | 29.66 | | enqueue requests | 85,100 | 2.36 | 33.84 | | enqueue timeouts | 963 | 0.03 | 0.38 | | enqueue waits | 20,207 | 0.56 | 8.03 | | execute count | 247,595 | 6.88 | 98.45 | | failed probes on index block reclamation | 1 | 0.00 | 0.00 | | file io service time | 673,724,761 | 18,710.13 | 267,882.61 | | free buffer inspected | 162,143 | 4.50 | 64.47 | | free buffer requested | 160,547 | 4.46 | 63.84 | | gc blocks corrupt | 2 | 0.00 | 0.00 | | gc blocks lost | 4 | 0.00 | 0.00 | | gc cr block read time | 54 | 0.00 | 0.02 | | gc cr block receive time | 8,754 | 0.24 | 3.48 | | gc cr blocks read | 152 | 0.00 | 0.06 | | gc cr blocks received | 32,604 | 0.91 | 12.96 | | gc cr bypass requests | 0 | 0.00 | 0.00 | | gc cr multiblock grant time | 4,510 | 0.13 | 1.79 | | gc cr multiblock grants received | 78,296 | 2.17 | 31.13 | | gc current block receive time | 179,828 | 4.99 | 71.50 | | gc current blocks received | 2,098 | 0.06 | 0.83 | | gc force cr read cr | 76 | 0.00 | 0.03 | | gc force cr read current | 83 | 0.00 | 0.03 | | gc local grants | 23,777 | 0.66 | 9.45 | | gc merge pi fg | 128 | 0.00 | 0.05 | | gc obj ckpt rdma check | 7 | 0.00 | 0.00 | | gc obj ckpt rdma skip | 7 | 0.00 | 0.00 | | gc reader bypass grants | 76 | 0.00 | 0.03 | | gc reader bypass waits | 30 | 0.00 | 0.01 | | gc remote grants | 102,055 | 2.83 | 40.58 | | gc remote lamport failure | 1 | 0.00 | 0.00 | | gc status messages received | 13,862 | 0.38 | 5.51 | | gcs affinity lock grants | 3,041 | 0.08 | 1.21 | | gcs data block access records | 1,404 | 0.04 | 0.56 | | gcs messages sent | 138,576 | 3.85 | 55.10 | | ges messages sent | 133,445 | 3.71 | 53.06 | | global enqueue gets sync | 272,544 | 7.57 | 108.37 | | global enqueue releases | 257,104 | 7.14 | 102.23 | | heap block compress | 1,524 | 0.04 | 0.61 | | hot buffers moved to head of LRU | 54,901 | 1.52 | 21.83 | | immediate (CR) block cleanout applications | 4,559 | 0.13 | 1.81 | | immediate (CURRENT) block cleanout applications | 6,432 | 0.18 | 2.56 | | index crx upgrade (positioned) | 1,873,300,187 | 52,023.74 | 744,850.97 | | index fast full scans (full) | 55 | 0.00 | 0.02 | | index fetch by key | 326,835 | 9.08 | 129.95 | | index range scans | 7,987,195,628 | 221,813.78 | 3,175,823.31 | | index split cancel wait clean | 62 | 0.00 | 0.02 | | index split cancel wait noclean | 310 | 0.01 | 0.12 | | leaf node 90-10 splits | 93 | 0.00 | 0.04 | | leaf node splits | 451 | 0.01 | 0.18 | | lob writes | 974 | 0.03 | 0.39 | | lob writes unaligned | 974 | 0.03 | 0.39 | | logical read bytes from cache | 163,711,938,281,472 | 4,546,472,285.91 | 65,094,210,052.28 | | logons cumulative | 10,009 | 0.28 | 3.98 | | max cf enq hold time | 5,136 | 0.14 | 2.04 | | messages sent | 17,018 | 0.47 | 6.77 | | min active SCN optimization applied on CR | 2 | 0.00 | 0.00 | | no buffer to keep pinned count | 739,259 | 20.53 | 293.94 | | no work - consistent read gets | 17,524,844,319 | 486,685.45 | 6,968,128.95 | | non-idle wait count | 4,037,018 | 112.11 | 1,605.18 | | number of successful DB user logins | 203 | 0.01 | 0.08 | | number of successful DB user logins authenticated by password | 203 | 0.01 | 0.08 | | opened cursors cumulative | 247,205 | 6.87 | 98.29 | | parse count (failures) | 265 | 0.01 | 0.11 | | parse count (hard) | 3,889 | 0.11 | 1.55 | | parse count (total) | 80,118 | 2.22 | 31.86 | | parse time cpu | 769 | 0.02 | 0.31 | | parse time elapsed | 990 | 0.03 | 0.39 | | physical read IO requests | 481,709 | 13.38 | 191.53 | | physical read bytes | 27,446,468,608 | 762,220.58 | 10,913,108.79 | | physical read total IO requests | 522,499 | 14.51 | 207.75 | | physical read total bytes | 28,090,654,720 | 780,110.38 | 11,169,246.41 | | physical read total multi block requests | 4,243 | 0.12 | 1.69 | | physical reads | 3,350,399 | 93.04 | 1,332.17 | | physical reads cache | 115,092 | 3.20 | 45.76 | | physical reads cache prefetch | 83,645 | 2.32 | 33.26 | | physical reads direct | 3,235,307 | 89.85 | 1,286.40 | | physical reads direct temporary tablespace | 3,223,498 | 89.52 | 1,281.71 | | physical reads prefetch warmup | 0 | 0.00 | 0.00 | | physical write IO requests | 460,211 | 12.78 | 182.99 | | physical write bytes | 27,311,341,568 | 758,467.95 | 10,859,380.35 | | physical write total IO requests | 470,620 | 13.07 | 187.13 | | physical write total bytes | 27,471,175,680 | 762,906.73 | 10,922,932.68 | | physical write total multi block requests | 2,620 | 0.07 | 1.04 | | physical writes | 3,333,904 | 92.59 | 1,325.61 | | physical writes direct | 3,333,904 | 92.59 | 1,325.61 | | physical writes direct (lob) | 982 | 0.03 | 0.39 | | physical writes direct temporary tablespace | 3,332,922 | 92.56 | 1,325.22 | | physical writes non checkpoint | 3,333,904 | 92.59 | 1,325.61 | | pinned buffers inspected | 18 | 0.00 | 0.01 | | prefetch warmup blocks aged out before use | 16 | 0.00 | 0.01 | | prefetched blocks aged out before use | 7,836 | 0.22 | 3.12 | | queries parallelized | 7 | 0.00 | 0.00 | | recursive calls | 774,172 | 21.50 | 307.82 | | recursive cpu usage | 11,923 | 0.33 | 4.74 | | redo entries | 214,777 | 5.96 | 85.40 | | redo ordering marks | 49 | 0.00 | 0.02 | | redo scn array scans | 67,384 | 1.87 | 26.79 | | redo size | 76,336,156 | 2,119.94 | 30,352.35 | | redo size for direct writes | 8,005,436 | 222.32 | 3,183.08 | | redo subscn max counts | 4,552 | 0.13 | 1.81 | | redo synch long waits | 1 | 0.00 | 0.00 | | redo synch time | 391 | 0.01 | 0.16 | | redo synch time (usec) | 3,917,155 | 108.78 | 1,557.52 | | redo synch time overhead (usec) | 418,350 | 11.62 | 166.34 | | redo synch time overhead count ( 2ms) | 75 | 0.00 | 0.03 | | redo synch time overhead count ( 8ms) | 32 | 0.00 | 0.01 | | redo synch time overhead count ( 32ms) | 12 | 0.00 | 0.00 | | redo synch time overhead count (128ms) | 1 | 0.00 | 0.00 | | redo synch time overhead count (inf) | 0 | 0.00 | 0.00 | | redo synch writes | 304 | 0.01 | 0.12 | | redo write broadcast ack count | 0 | 0.00 | 0.00 | | redo write broadcast ack time | 0 | 0.00 | 0.00 | | redo write info find | 120 | 0.00 | 0.05 | | redo write info find fail | 0 | 0.00 | 0.00 | | rollback changes - undo records applied | 218 | 0.01 | 0.09 | | rollbacks only - consistent read gets | 22 | 0.00 | 0.01 | | root node splits | 1 | 0.00 | 0.00 | | rows fetched via callback | 72,248 | 2.01 | 28.73 | | securefile alloc all sources | 57 | 0.00 | 0.02 | | securefile allocation bytes | 81,920 | 2.28 | 32.57 | | securefile allocation chunks | 5 | 0.00 | 0.00 | | securefile bytes non-transformed | 71,296 | 1.98 | 28.35 | | securefile direct write bytes | 81,920 | 2.28 | 32.57 | | securefile direct write ops | 5 | 0.00 | 0.00 | | securefile number of cfs added | 3 | 0.00 | 0.00 | | securefile number of non-transformed flushes | 111 | 0.00 | 0.04 | | securefiles dispenser load chunks | 1,139 | 0.03 | 0.45 | | segment cfs allocations | 1 | 0.00 | 0.00 | | segment chunks allocation from dispenser | 4 | 0.00 | 0.00 | | segment dispenser allocations | 4 | 0.00 | 0.00 | | segment dispenser load empty | 1 | 0.00 | 0.00 | | segment dispenser load tasks | 2 | 0.00 | 0.00 | | segment prealloc tasks | 106 | 0.00 | 0.04 | | session cursor cache hits | 192,177 | 5.34 | 76.41 | | session logical reads | 19,984,558,082 | 554,994.59 | 7,946,146.35 | | shared hash latch upgrades - no wait | 141,893 | 3.94 | 56.42 | | shared hash latch upgrades - wait | 0 | 0.00 | 0.00 | | shared io pool buffer get success | 5 | 0.00 | 0.00 | | sorts (disk) | 345 | 0.01 | 0.14 | | sorts (memory) | 44,202 | 1.23 | 17.58 | | sorts (rows) | 49,972,627 | 1,387.80 | 19,869.83 | | sql area evicted | 1,684 | 0.05 | 0.67 | | sql area purged | 283 | 0.01 | 0.11 | | switch current caused by our pin | 3,996 | 0.11 | 1.59 | | switch current to new buffer | 4,195 | 0.12 | 1.67 | | table fetch by rowid | 13,688,867,849 | 380,155.89 | 5,442,889.80 | | table fetch continued row | 2,227 | 0.06 | 0.89 | | table scan blocks gotten | 91,728,201 | 2,547.40 | 36,472.45 | | table scan disk non-IMC rows gotten | 6,076,858,057 | 168,761.47 | 2,416,245.75 | | table scan rows gotten | 6,076,883,089 | 168,762.16 | 2,416,255.70 | | table scans (direct read) | 7 | 0.00 | 0.00 | | table scans (long tables) | 3,202 | 0.09 | 1.27 | | table scans (short tables) | 65,599 | 1.82 | 26.08 | | total cf enq hold time | 59,362 | 1.65 | 23.60 | | total number of cf enq holders | 2,964 | 0.08 | 1.18 | | total number of slots | 0 | 0.00 | 0.00 | | transaction rollbacks | 3 | 0.00 | 0.00 | | undo change vector size | 23,400,420 | 649.86 | 9,304.34 | | user calls | 126,629 | 3.52 | 50.35 | | user commits | 2,513 | 0.07 | 1.00 | | user commits Autonomous | 2,606 | 0.07 | 1.04 | | user commits Commit on Success | 66 | 0.00 | 0.03 | | user commits PL/SQL | 2,527 | 0.07 | 1.00 | | user commits Top Level | 1 | 0.00 | 0.00 | | user logons cumulative | 203 | 0.01 | 0.08 | | user logouts cumulative | 381 | 0.01 | 0.15 | | user rollbacks | 2 | 0.00 | 0.00 | | workarea executions - onepass | 3,097 | 0.09 | 1.23 | | workarea executions - optimal | 63,140 | 1.75 | 25.11 | | write clones created in foreground | 0 | 0.00 | 0.00 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Absolute Values- Statistics with absolute values (should not be diffed)
| Statistic | Begin Value | End Value |
|---|
| session cursor cache count | 15,889 | 32,935 | | session uga memory | 841,274,272 | 1,979,277,608 | | session uga memory max | 3,666,809,432 | 17,513,752,560 | | total number of online undo segments | 11 | 11 | | workarea memory allocated | 184,003 | 27,439 |
|
|
3.6 IO的统计信息（供参考就好） （称其为第5部分）： 可以验证数据库存在大量临时段排序。整个库物理读不多。
IO StatsBack to Top
IOStat by Filetype summary- 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
- Small Read and Large Read are average service times
- Ordered by (Data Read + Write) desc
| Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
|---|
| Data File | 1.1G | 1.36 | .03M | 220M | 0.34 | .006M | 1.53ms | 9.56ms | | TOTAL: | 1.1G | 1.36 | .03M | 220M | 0.34 | .006M | 1.53ms | 9.56ms |
Back to IO Stats
Back to Top
Tablespace IO Stats- ordered by IOs (Reads + Writes) desc
| Tablespace | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | % Opt Reads | Writes | Writes avg/s | Av Writes(ms) | Buffer Waits | Av Buf Wt(ms) | PDB Name |
|---|
| TEMP | 442,937 | 12 | 105.58 | 7.28 | 0 | 10.61 | | 477,146 | 13 | 169.91 | 179,989 | 990.72 | | | SYSAUX | 43,759 | 1 | 1.28 | 2.79 | 1 | 1.06 | 0.00 | 8,735 | 0 | 9.50 | 5 | 12.00 | | | UNDO_8 | 1 | 0 | 0.00 | 1.00 | 0 | 0.00 | 0.00 | 2,023 | 0 | 5.36 | 0 | 0.00 | | | USERS | 1,172 | 0 | 1.50 | 7.92 | 0 | 0.51 | 0.00 | 115 | 0 | 3.91 | 15 | 299.33 | | | UNDOTBS1 | 4 | 0 | 0.00 | 1.00 | 0 | 0.00 | 0.00 | 0 | 0 | 0.00 | 23 | 0.87 | |
Back to IO Stats
Back to Top
File IO Stats- ordered by Tablespace, File
| Tablespace | Filename | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | % Opt Reads | Writes | Writes avg/s | Buffer Waits | Av Buf Wt(ms) | PDB Name |
|---|
| SYSAUX | +DATA/CDB1/3F7F567DBBBFEC23E06315FA19AC6119/DATAFILE/sysaux.304.1212642515 | 43,759 | 1 | 1.28 | 2.79 | 1 | 1.06 | 0.00 | 8,735 | 0 | 5 | 12.00 | | | TEMP | +DATA/CDB1/3F7F567DBBBFEC23E06315FA19AC6119/TEMPFILE/temp.305.1212642635 | 442,937 | 12 | 105.58 | 7.28 | 0 | 10.61 | | 477,146 | 13 | 179,989 | 990.72 | | | UNDOTBS1 | +DATA/CDB1/3F7F567DBBBFEC23E06315FA19AC6119/DATAFILE/undotbs1.290.1212642513 | 4 | 0 | 0.00 | 1.00 | 0 | 0.00 | 0.00 | 0 | 0 | 23 | 0.87 | | | UNDO_8 | +DATA/CDB1/3F7F567DBBBFEC23E06315FA19AC6119/DATAFILE/undo_8.308.1212642681 | 1 | 0 | 0.00 | 1.00 | 0 | 0.00 | 0.00 | 2,023 | 0 | 0 | 0.00 | | | USERS | +DATA/CDB1/3F7F567DBBBFEC23E06315FA19AC6119/DATAFILE/users.311.1212642695 | 1,172 | 0 | 1.50 | 7.92 | 0 | 0.51 | 0.00 | 115 | 0 | 15 | 299.33 | |
|
|
3.7 段头块统计信息（供参考就好）（称其为第6部分）： 说明存在热点块：
Buffer Wait Statistics- ordered by wait time desc, waits desc
| Class | Waits | Total Wait Time (s) | Avg Time (ms) |
|---|
| file header block | 180,060 | 178,352 | 991 | | data block | 29 | 5 | 156 | | undo header | 58 | 0 | 2 | | 2nd level bmb | 4 | 0 | 15 | | 1st level bmb | 1 | 0 | 0 |
|
|
3.8 段的细节统计信息（称其为第7部分）： 本节统计信息用于精确定位调优，用于找到出问题的段（表），根据前面的分析应该先看“Segments by Logical Reads”。使用提高pct_free等手段（用move tablespace生效），来减低热点：
Undo StatisticsBack to Top
Undo Segment Summary- Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
- STO - Snapshot Too Old count, OOS - Out of Space count
- Undo segment block stats:
- uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
- eS - expired Stolen, eR - expired Released, eU - expired reUsed
| Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|
| 7 | 6.45 | 13,519 | 3,344 | 11 | 15/155.3 | 0/0 | 0/0/0/0/0/6144 |
Back to Undo Statistics
Back to Top
Undo Segment Stats- Most recent 35 Undostat rows, ordered by Time desc
| End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|
| 03-10月 18:55 | 2 | 40 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 18:45 | 4 | 50 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 18:35 | 4 | 28 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 18:25 | 8 | 62 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/7 | | 03-10月 18:15 | 6 | 232 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 18:05 | 213 | 102 | 0 | 3 | 15 | 0/0 | 0/0/0/0/0/143 | | 03-10月 17:55 | 16 | 226 | 0 | 2 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 17:45 | 0 | 50 | 0 | 0 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 17:35 | 0 | 18 | 0 | 0 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 17:25 | 14 | 46 | 0 | 3 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 17:15 | 2 | 203 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 17:05 | 228 | 100 | 0 | 3 | 15 | 0/0 | 0/0/0/0/0/256 | | 03-10月 16:55 | 1 | 47 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 16:45 | 1 | 46 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 16:35 | 2 | 14 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 16:25 | 16 | 216 | 0 | 2 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 16:15 | 5 | 185 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 16:05 | 213 | 105 | 0 | 3 | 15 | 0/0 | 0/0/0/0/0/128 | | 03-10月 15:55 | 3 | 50 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 15:45 | 2 | 45 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 15:35 | 0 | 16 | 0 | 0 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 15:25 | 11 | 43 | 0 | 2 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 15:15 | 7 | 214 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 15:05 | 227 | 106 | 0 | 3 | 15 | 0/0 | 0/0/0/0/0/128 | | 03-10月 14:55 | 14 | 191 | 0 | 2 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 14:45 | 1 | 43 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 14:35 | 2 | 17 | 0 | 1 | 15 | 0/0 | 0/0/0/0/0/0 | | 03-10月 14:25 | 699 | 3,093 | 0 | 3 | 15 | 0/0 | 0/0/0/0/0/655 | | 03-10月 14:15 | 1 | 191 | 639 | 1 | 26 | 0/0 | 0/0/0/0/0/0 | | 03-10月 14:05 | 314 | 216 | 1,195 | 11 | 35 | 0/0 | 0/0/0/0/0/543 | | 03-10月 13:55 | 2 | 46 | 892 | 1 | 26 | 0/0 | 0/0/0/0/0/0 | | 03-10月 13:45 | 3 | 60 | 289 | 2 | 34 | 0/0 | 0/0/0/0/0/0 | | 03-10月 13:35 | 2 | 13 | 845 | 1 | 45 | 0/0 | 0/0/0/0/0/0 | | 03-10月 13:25 | 2,402 | 2,825 | 1,505 | 3 | 36 | 0/0 | 0/0/0/0/0/2266 |
Back to Undo Statistics
Back to Top
Undo Tablespace Stats- This section shows the statistics for the Undo Tablespace at the beginning and end of the snapshot.
| Statistic | Begin Value | End Value |
|---|
| Tablespace# | 7 | 7 | | Tablespace Size (MB) | 100 | 100 |
|
|
Segment StatisticsBack to Top
Segments by Logical Reads- Total Logical Reads: 19,984,558,082
- Captured Segments account for 99.7% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Logical Reads | %Total | PDB Name |
|---|
| APPS | USERS | FACT_PD_OUT_ITM_293 | | TABLE | 89653 | 89653 | 7,146,443,424 | 35.76 | | | APPS | USERS | ADM_PG_FEATUREVALUE_IDX2 | | INDEX | 89683 | 89683 | 5,181,710,000 | 25.93 | | | APPS | USERS | FACT_274_PER_IDX | | INDEX | 89791 | 89791 | 3,889,071,872 | 19.46 | | | APPS | USERS | ADM_PG_FEATUREVALUE | | TABLE | 89652 | 89652 | 2,891,860,960 | 14.47 | | | APPS | USERS | FACT_274_ITEM_IDX | | INDEX | 89790 | 89790 | 801,349,664 | 4.01 | |
Back to Segment Statistics
Back to Top
Segments by Physical Reads- Total Physical Reads: 3,350,399
- Captured Segments account for 3.0% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Physical Reads | %Total | PDB Name |
|---|
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | TABLE PARTITION | 72905 | 90947 | 16,900 | 0.50 | | | SYS | SYSAUX | SYS_LOB0000073805C00004$$ | | LOB | 73808 | 73808 | 8,193 | 0.24 | | | SYS | SYSAUX | WRH$_SYSSTAT | WRH$_SYSSTAT_2871972511_52 | TABLE PARTITION | 90559 | 89998 | 7,075 | 0.21 | | | SYS | SYSAUX | WRH$_LATCH | WRH$_LATCH_2871972511_52 | TABLE PARTITION | 90487 | 89926 | 5,943 | 0.18 | | | APPS | USERS | FACT_PD_OUT_ITM_293 | | TABLE | 89653 | 89653 | 5,348 | 0.16 | |
注释：以上物理读与我们的工作负载没有关系。
Back to Segment Statistics
Back to Top
Segments by Physical Read Requests- Total Physical Read Requests: 481,709
- Captured Segments account for 7.1% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Phys Read Requests | %Total | PDB Name |
|---|
| SYS | SYSAUX | SYS_LOB0000073805C00004$$ | | LOB | 73808 | 73808 | 7,142 | 1.48 | | | SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | TABLE PARTITION | 72905 | 90947 | 3,459 | 0.72 | | | SYS | SYSAUX | WRH$_LATCH_PK | WRH$_LATCH_2871972511_26 | INDEX PARTITION | 89928 | 72860 | 2,573 | 0.53 | | | SYS | SYSAUX | WRH$_SYSSTAT_PK | WRH$_SYSSTAT_2871972511_26 | INDEX PARTITION | 90000 | 72888 | 2,463 | 0.51 | | | SYS | SYSAUX | WRH$_EVENT_HISTOGRAM_PK | WRH$_EVENT_HISTOGRAM_2871972511_26 | INDEX PARTITION | 90179 | 72936 | 1,733 | 0.36 | |
Back to Segment Statistics
Back to Top
Segments by UnOptimized Reads- Total UnOptimized Read Requests: 481,709
- Captured Segments account for 7.1% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | UnOptimized Reads | %Total | PDB Name |
|---|
| SYS | SYSAUX | SYS_LOB0000073805C00004$$ | | LOB | 73808 | 73808 | 7,142 | 1.48 | | | SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | TABLE PARTITION | 72905 | 90947 | 3,459 | 0.72 | | | SYS | SYSAUX | WRH$_LATCH_PK | WRH$_LATCH_2871972511_26 | INDEX PARTITION | 89928 | 72860 | 2,573 | 0.53 | | | SYS | SYSAUX | WRH$_SYSSTAT_PK | WRH$_SYSSTAT_2871972511_26 | INDEX PARTITION | 90000 | 72888 | 2,463 | 0.51 | | | SYS | SYSAUX | WRH$_EVENT_HISTOGRAM_PK | WRH$_EVENT_HISTOGRAM_2871972511_26 | INDEX PARTITION | 90179 | 72936 | 1,733 | 0.36 | |
Back to Segment Statistics
Back to Top
Segments by Optimized ReadsNo data exists for this section of the report. Back to Segment Statistics
Back to Top
Segments by Direct Physical Reads- Total Direct Physical Reads: 3,235,307
- Captured Segments account for 0.6% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Direct Reads | %Total | PDB Name |
|---|
| SYS | SYSAUX | SYS_LOB0000073805C00004$$ | | LOB | 73808 | 73808 | 8,192 | 0.25 | | | SYS | SYSAUX | WRH$_SYSSTAT | WRH$_SYSSTAT_2871972511_52 | TABLE PARTITION | 90559 | 89998 | 2,356 | 0.07 | | | SYS | SYSAUX | WRH$_LATCH | WRH$_LATCH_2871972511_52 | TABLE PARTITION | 90487 | 89926 | 1,978 | 0.06 | | | SYS | SYSAUX | WRH$_SYSSTAT | WRH$_SYSSTAT_2871972511_26 | TABLE PARTITION | 89997 | 72885 | 1,960 | 0.06 | | | SYS | SYSAUX | WRH$_LATCH | WRH$_LATCH_2871972511_26 | TABLE PARTITION | 89925 | 72857 | 1,630 | 0.05 | |
Back to Segment Statistics
Back to Top
Segments by Physical Writes- Total Physical Writes: 3,333,904
- Captured Segments account for 0.4% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Physical Writes | %Total | PDB Name |
|---|
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | TABLE PARTITION | 72905 | 90947 | 1,810 | 0.05 | | | SYS | SYSTEM | HISTGRM$ | | TABLE | 66 | 64 | 1,123 | 0.03 | | | SYS | SYSAUX | WRH$_LATCH_PK | WRH$_LATCH_2871972511_52 | INDEX PARTITION | 90490 | 89927 | 863 | 0.03 | | | SYS | SYSAUX | SYS_LOB0000073805C00004$$ | | LOB | 73808 | 73808 | 818 | 0.02 | | | SYS | SYSAUX | WRH$_EVENT_HISTOGRAM_PK | WRH$_EVENT_HISTOGRAM_2871972511_52 | INDEX PARTITION | 90741 | 90178 | 730 | 0.02 | |
Back to Segment Statistics
Back to Top
Segments by Physical Write Requests- Total Physical Write Requests: 460,211
- Captured Segments account for 1.6% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Phys Write Requests | %Total | PDB Name |
|---|
| SYS | SYSAUX | SYS_LOB0000073805C00004$$ | | LOB | 73808 | 73808 | 803 | 0.17 | | | SYS | SYSAUX | WRH$_SYSSTAT_PK | WRH$_SYSSTAT_2871972511_0 | INDEX PARTITION | 90561 | 90561 | 335 | 0.07 | | | SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | TABLE PARTITION | 72905 | 90947 | 297 | 0.06 | | | SYS | SYSAUX | WRH$_LATCH_PK | WRH$_LATCH_2871972511_52 | INDEX PARTITION | 90490 | 89927 | 273 | 0.06 | | | SYS | SYSAUX | I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST | | INDEX | 14874 | 14874 | 260 | 0.06 | |
Back to Segment Statistics
Back to Top
Segments by Direct Physical Writes- Total Direct Physical Writes: 3,333,904
- Captured Segments account for 0.0% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Direct Writes | %Total | PDB Name |
|---|
| SYS | SYSAUX | SYS_LOB0000073805C00004$$ | | LOB | 73808 | 73808 | 774 | 0.02 | | | SYS | SYSAUX | SYS_LOB0000073805C00003$$ | | LOB | 73806 | 73806 | 198 | 0.01 | | | SYS | SYSAUX | SYS_LOB0000073470C00038$$ | SYS_LOB_P722 | LOB PARTITION | 90462 | 90462 | 84 | 0.00 | | | SYS | SYSAUX | SYS_LOB0000009215C00039$$ | | LOB | 9216 | 9216 | 10 | 0.00 | | | SYS | SYSAUX | SYS_LOB0000073461C00004$$ | SYS_LOB_P718 | LOB PARTITION | 90450 | 90450 | 1 | 0.00 | |
Back to Segment Statistics
Back to Top
Segments by Table Scans- Total Table Scans: 3,257
- Captured Segments account for 99.8% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Table Scans | %Total | PDB Name |
|---|
| APPS | USERS | FACT_PD_OUT_ITM_293 | | TABLE | 89653 | 89653 | 3,193 | 98.04 | | | SYS | SYSTEM | I_OBJ1 | | INDEX | 88819 | 88819 | 9 | 0.28 | | | SYS | SYSAUX | WRH$_SQL_PLAN_PK | WRH$_SQL_PLAN_2871972511_MXSN | INDEX PARTITION | 90465 | 90465 | 8 | 0.25 | | | SYS | SYSAUX | WRH$_SQL_PLAN_PK | WRH$_SQL_PLAN_2871972511_76 | INDEX PARTITION | 89904 | 88967 | 6 | 0.18 | | | SYS | SYSAUX | WRH$_SEG_STAT_OBJ_PK | WRH$_SEG_STAT_OBJ_2871972511_MXSN | INDEX PARTITION | 90587 | 90593 | 5 | 0.15 | |
Back to Segment Statistics
Back to Top
Segments by DB Blocks Changes- % of Capture shows % of DB Block Changes for each top segment compared
- with total DB Block Changes for all segments captured by the Snapshot
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | DB Block Changes | % of Capture | PDB Name |
|---|
| SYS | SYSTEM | I_H_OBJ#_COL# | | INDEX | 67 | 67 | 69,408 | 25.59 | | | SYS | SYSTEM | HISTGRM$ | | TABLE | 66 | 64 | 69,136 | 25.49 | | | SYS | SYSAUX | WRH$_SYSSTAT_PK | WRH$_SYSSTAT_2871972511_0 | INDEX PARTITION | 90561 | 90561 | 25,056 | 9.24 | | | SYS | SYSAUX | WRH$_LATCH_PK | WRH$_LATCH_2871972511_0 | INDEX PARTITION | 90489 | 90489 | 11,504 | 4.24 | | | SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | TABLE PARTITION | 72905 | 90947 | 5,520 | 2.04 | |
Back to Segment Statistics
Back to Top
Segments by Row Lock Waits- % of Capture shows % of row lock waits for each top segment compared
- with total row lock waits for all segments captured by the Snapshot
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Row Lock Waits | % of Capture | PDB Name |
|---|
| SYS | SYSAUX | WRH$_SQLSTAT_INDEX | WRH$_SQLSTAT_2871972511_0 | INDEX PARTITION | 90437 | 90437 | 3 | 100.00 | |
Back to Segment Statistics
Back to Top
Segments by ITL Waits- % of Capture shows % of ITL waits for each top segment compared
- with total ITL waits for all segments captured by the Snapshot
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | ITL Waits | % of Capture | PDB Name |
|---|
| SYS | SYSAUX | WRH$_SQLSTAT_PK | WRH$_SQLSTAT_2871972511_0 | INDEX PARTITION | 90439 | 90439 | 2 | 40.00 | | | SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY_PK | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | INDEX PARTITION | 90948 | 90948 | 1 | 20.00 | | | SYS | SYSAUX | WRH$_ENQUEUE_STAT_PK | WRH$_ENQUEUE_STAT_2871972511_MXSN | INDEX PARTITION | 90485 | 90485 | 1 | 20.00 | | | SYS | SYSAUX | WRH$_SEG_STAT_PK | WRH$_SEG_STAT_2871972511_0 | INDEX PARTITION | 90581 | 90581 | 1 | 20.00 | |
Back to Segment Statistics
Back to Top
Segments by Buffer Busy WaitsNo data exists for this section of the report. Back to Segment Statistics
Back to Top
Segments by Global Cache Buffer Busy- % of Capture shows % of GC Buffer Busy for each top segment compared
- with GC Buffer Busy for all segments captured by the Snapshot
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | GC Buffer Busy | % of Capture | PDB Name |
|---|
| APPS | USERS | FACT_PD_OUT_ITM_293 | | TABLE | 89653 | 89653 | 15 | 65.22 | | | SYS | SYSTEM | SEG$ | | TABLE | 14 | 8 | 5 | 21.74 | | | SYS | SYSAUX | SYS_LOB0000009215C00039$$ | | LOB | 9216 | 9216 | 2 | 8.70 | | | SYS | SYSTEM | I_TABPART_BOPART$ | | INDEX | 815 | 815 | 1 | 4.35 | |
Back to Segment Statistics
Back to Top
Segments by CR Blocks Received- Total CR Blocks Received: 32,604
- Captured Segments account for 87.6% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | CR Blocks Received | %Total | PDB Name |
|---|
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | TABLE PARTITION | 72905 | 90947 | 10,671 | 32.73 | | | SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY_PK | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | INDEX PARTITION | 90948 | 90948 | 3,029 | 9.29 | | | SYS | SYSAUX | WRH$_SYSSTAT | WRH$_SYSSTAT_2871972511_0 | TABLE PARTITION | 72885 | 90560 | 1,580 | 4.85 | | | SYS | SYSAUX | WRH$_SYSSTAT_PK | WRH$_SYSSTAT_2871972511_0 | INDEX PARTITION | 90561 | 90561 | 1,357 | 4.16 | | | SYS | SYSAUX | WRH$_LATCH | WRH$_LATCH_2871972511_0 | TABLE PARTITION | 72857 | 90488 | 1,227 | 3.76 | |
Back to Segment Statistics
Back to Top
Segments by Current Blocks Received- Total Current Blocks Received: 2,098
- Captured Segments account for 244.3% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Current Blocks Received | %Total | PDB Name |
|---|
| APPS | USERS | FACT_PD_OUT_ITM_293 | | TABLE | 89653 | 89653 | 389 | 18.54 | | | SYS | SYSAUX | WRH$_SQLSTAT_INDEX | WRH$_SQLSTAT_2871972511_0 | INDEX PARTITION | 90437 | 90437 | 322 | 15.35 | | | SYS | SYSAUX | WRM$_SNAPSHOT_DETAILS_INDEX | WRM$_SNAPSHOT_DETAILS_2871972511_MXSN | INDEX PARTITION | 90832 | 90832 | 295 | 14.06 | | | SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY_PK | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | INDEX PARTITION | 90948 | 90948 | 239 | 11.39 | | | SYS | SYSAUX | SMON_SCN_TIME | | TABLE | 423 | 74075 | 221 | 10.53 | |
Back to Segment Statistics
Back to Top
Segments by Global Cache Remote Grants- Total Global Cache Remote Grants: 102,055
- Captured Segments account for 72.2% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | GC Remote Grants | %Total | PDB Name |
|---|
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_SESSION_HISTORY_2871972511_0 | TABLE PARTITION | 72905 | 90947 | 14,348 | 14.06 | | | APPS | USERS | FACT_PD_OUT_ITM_293 | | TABLE | 89653 | 89653 | 5,190 | 5.09 | | | SYS | SYSAUX | WRH$_SYSSTAT_PK | WRH$_SYSSTAT_2871972511_26 | INDEX PARTITION | 90000 | 72888 | 4,420 | 4.33 | | | SYS | SYSAUX | WRH$_SYSSTAT | WRH$_SYSSTAT_2871972511_52 | TABLE PARTITION | 90559 | 89998 | 3,714 | 3.64 | | | SYS | SYSTEM | HISTGRM$ | | TABLE | 66 | 64 | 3,221 | 3.16 | |
|
|
3.9 数据字典的统计信息（称其为第8部分）： Dictionary Cache StatisticsBack to Top
Dictionary Cache Stats- "Pct Misses" should be very low (< 2% in most cases)
- "Final Usage" is the number of cache entries being used
| Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
|---|
| dc_awr_control | 2,630 | 4.60 | 0 | | 0 | 2 | | dc_column_model_to_tab | 33 | 0.00 | 0 | | 0 | 28 | | dc_constraints | 212 | 0.00 | 0 | | 0 | 4 | | dc_global_oids | 34,842 | 0.04 | 0 | | 0 | 133 | | dc_histogram_data | 63,061 | 6.32 | 0 | | 3,943 | 8,512 | | dc_histogram_defs | 330,432 | 2.90 | 0 | | 3,755 | 16,724 | | dc_object_grants | 62 | 4.84 | 0 | | 0 | 155 | | dc_objects | 1,137,210 | 0.22 | 0 | | 736 | 6,002 | | dc_profiles | 829 | 0.00 | 0 | | 0 | 2 | | dc_props | 16 | 100.00 | 0 | | 0 | 9 | | dc_realtime_colst | 33 | 0.00 | 0 | | 0 | 28 | | dc_realtime_tabst | 228 | 100.00 | 0 | | 0 | 197 | | dc_rollback_segments | 66,079 | 0.01 | 0 | | 0 | 158 | | dc_segments | 4,433 | 39.32 | 0 | | 225 | 1,316 | | dc_sequences | 884 | 32.58 | 0 | | 884 | 7 | | dc_statistics_status | 4 | 100.00 | 0 | | 0 | 4 | | dc_table_scns | 7 | 100.00 | 0 | | 0 | 6 | | dc_tablespace_quotas | 5 | 0.00 | 0 | | 0 | 2 | | dc_tablespaces | 11,481 | 0.03 | 0 | | 0 | 13 | | dc_users | 209,848 | 0.06 | 12,792 | 0.06 | 0 | 397 | | outstanding_alerts | 56 | 100.00 | 0 | | 0 | 6 | | sch_lj_objs | 2 | 50.00 | 0 | | 0 | 1 | | sch_lj_oids | 303 | 6.93 | 0 | | 0 | 34 |
Back to Dictionary Cache Statistics
Back to Top
Dictionary Cache Stats (RAC)| Cache | GES Requests | GES Conflicts | GES Releases |
|---|
| dc_awr_control | 2,630 | | | | dc_column_model_to_tab | 33 | | | | dc_global_oids | 34,842 | | | | dc_histogram_defs | 326,274 | | | | dc_objects | 274,492 | | | | dc_profiles | 829 | | | | dc_props | 16 | | | | dc_realtime_colst | 33 | | | | dc_realtime_tabst | 228 | | | | dc_rollback_segments | 66,079 | | | | dc_segments | 4,430 | | | | dc_sequences | 884 | | | | dc_statistics_status | 4 | | | | dc_table_scns | 7 | | | | dc_tablespace_quotas | 5 | | | | dc_tablespaces | 11,481 | | | | dc_users | 131,266 | | | | outstanding_alerts | 56 | | | | sch_lj_objs | 2 | | | | sch_lj_oids | 303 | | |
Back to Dictionary Cache Statistics
Back to Top
Library Cache StatisticsBack to Top
Library Cache Activity- "Pct Misses" should be very low
| Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
|---|
| ACCOUNT_STATUS | 1,854 | 0.00 | 0 | | 0 | 0 | | APP STATE | 356 | 0.00 | 0 | | 0 | 0 | | AUDIT POLICY | 9,178 | 0.07 | 9,178 | 0.07 | 0 | 0 | | BODY | 3,445 | 0.55 | 24,667 | 0.08 | 0 | 0 | | CLUSTER | 628 | 0.32 | 642 | 0.16 | 0 | 0 | | DBLINK | 2,732 | 0.00 | 0 | | 0 | 0 | | EDITION | 1,203 | 0.00 | 2,406 | 0.00 | 0 | 0 | | FED APP | 70 | 0.00 | 70 | 0.00 | 0 | 0 | | INDEX | 4,691 | 3.52 | 4,364 | 14.57 | 226 | 0 | | OBJECT ID | 103 | 100.00 | 0 | | 0 | 0 | | QUEUE | 252 | 1.59 | 1,420 | 33.24 | 232 | 0 | | SCHEMA | 1,671 | 0.30 | 0 | | 0 | 0 | | SENSITIVE_TABLE | 15 | 100.00 | 0 | | 0 | 0 | | SQL AREA | 130,438 | 3.06 | 583,802 | 1.60 | 820 | 839 | | SQL AREA BUILD | 3,263 | 74.13 | 0 | | 0 | 0 | | SQL AREA STATS | 3,170 | 82.65 | 3,170 | 82.65 | 0 | 0 | | TABLE/PROCEDURE | 25,868 | 3.32 | 248,567 | 1.51 | 1,470 | 0 | | TEMPORARY TABLE | 789 | 18.76 | 789 | 100.00 | 641 | 0 | | TRIGGER | 791 | 2.91 | 780 | 1.54 | 0 | 0 |
Back to Library Cache Statistics
Back to Top
Library Cache Activity (RAC)| Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
|---|
| ACCOUNT_STATUS | 1,854 | 0 | 0 | 0 | 0 | | APP STATE | 356 | 0 | 0 | 0 | 0 | | AUDIT POLICY | 9,178 | 9,178 | 9,178 | 0 | 0 | | BODY | 721 | 22,804 | 22,804 | 0 | 0 | | CLUSTER | 52 | 52 | 52 | 0 | 0 | | DBLINK | 2,732 | 0 | 0 | 0 | 0 | | EDITION | 1,203 | 1,203 | 1,203 | 0 | 0 | | FED APP | 70 | 70 | 70 | 0 | 0 | | INDEX | 4,287 | 4,287 | 4,287 | 0 | 0 | | QUEUE | 472 | 1,652 | 1,652 | 0 | 0 | | SCHEMA | 344 | 0 | 0 | 0 | 0 | | SENSITIVE_TABLE | 15 | 0 | 0 | 0 | 0 | | TABLE/PROCEDURE | 59,114 | 115,182 | 115,182 | 0 | 0 | | TEMPORARY TABLE | 789 | 789 | 789 | 0 | 0 | | TRIGGER | 0 | 780 | 780 | 0 | 0 |
|
|
3.10 其他信息（供参考就好）（称其为第9部分）：
Replication Statistics (GoldenGate, XStream)Back to Top
Replication System Resource UsageNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Replication SGA UsageNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Replication Foreground Wait EventsNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Replication Background Wait EventsNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Replication SQL ordered by Elapsed TimeNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Replication SQL ordered by CPU TimeNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Replication SQL ordered by User I/O Wait TimeNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Replication SQL ordered by ExecutionsNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
GoldenGate Integrated ExtractNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
GoldenGate Integrated ReplicatNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
GoldenGate ReplicatNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
XStreamOUT CaptureNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
XStreamOUT Outbound ServerNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
XStreamINNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Table Statistics by DML OperationsNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Table Statistics by Conflict ResolutionsNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Replication Large Transaction StatisticsNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
XStream Replication Long Running Transaction StatisticsNo data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)
Back to Top
Complete List of SQL Text for Replication StatisticsNo data exists for this section of the report. |
|
Initialization ParametersBack to Top
Parameters modified by this container- This section shows all the modified initialization parameters that were in effect during the entire snapshot interval
- End Value is displayed only if the parameter value was modified within the snapshot interval
| Parameter Name | Begin value | End value (if different) | PDB Name |
|---|
| awr_pdb_autoflush_enabled | TRUE | | | | cursor_sharing | EXACT | | | | plsql_warnings | DISABLE:ALL | | | | sga_target | 0 | | | | spatial_vector_acceleration | TRUE | | | | timezone_version_upgrade_online | FALSE | | |
Back to Initialization Parameters
Back to Top
Parameters modified by other containers- This section shows all the modified initialization parameters that were in effect during the snapshot interval
- End Value is displayed only if the parameter value was changed within the snapshot interval
| Parameter Name | Begin value | End value (if different) | PDB Name |
|---|
| _exadata_feature_on | TRUE | | | | _instance_recovery_bloom_filter_size | 1048576 | | | | audit_file_dest | /u01/app/oracle/admin/cdb1/adump | | | | audit_trail | DB | | | | cdb_cluster | FALSE | | | | cluster_database | TRUE | | | | compatible | 23.0.0 | | | | control_files | +DATA/CDB1/CONTROLFILE/current.268.1212351129, +FRA/CDB1/CONTROLFILE/current.256.1212351129 | | | | db_block_size | 8192 | | | | db_create_file_dest | +DATA | | | | db_name | cdb1 | | | | db_recovery_file_dest | +FRA | | | | db_recovery_file_dest_size | 51141148672 | | | | diagnostic_dest | /u01/app/oracle | | | | dispatchers | (PROTOCOL=TCP) (SERVICE=cdb1XDB) | | | | enable_pluggable_database | TRUE | | | | instance_name | CDB11 | | | | instance_number | 1 | | | | local_listener | | | | | nls_language | AMERICAN | | | | nls_territory | AMERICA | | | | open_cursors | 300 | | | | pga_aggregate_target | 802160640 | | | | processes | 640 | | | | remote_listener | scan.cluster21.lab.example.com:1521 | | | | remote_login_passwordfile | EXCLUSIVE | | |
Back to Initialization Parameters
Back to Top
Multi-Valued Parameters modified by this containerNo data exists for this section of the report. Back to Initialization Parameters
Back to Top
Multi-Valued Parameters modified by other containers- This section only displays parameters that have more than one value
- '(NULL)' indicates a missing parameter value
- A blank in the 'End Snapshot' indicates the same value as the 'Begin Snapshot'
| Parameter Name | Begin value | End value (if different) | PDB Name |
|---|
| control_files | +DATA/CDB1/CONTROLFILE/current.268.1212351129 | | | control_files | +FRA/CDB1/CONTROLFILE/current.256.1212351129 | |
|
|
|
