Replay的AWR比较报告以及Replay的Capture和Replay报告

botang · 发表于 2017-7-24 17:30:10

第三阶段New Feature/OCM Exam Preparation（31-33）
Replay的Capture报告：
Database Capture Report For ORCL

DB Name	DB Id	Release	RAC	Capture Name	Status
ORCL	1474621900	11.2.0.1.0	NO	capturegrid1	COMPLETED

Information	Capture
Start time:	22-Jul-17 01:07:25 (SCN = 1111137)
End time:	22-Jul-17 01:15:35 (SCN = 1117832)
Duration:	8 minutes 10 seconds
Capture size:	906.23 KB
Directory object:	DBREPLAY
Directory path:	/home/oracle/solutions/dbreplay
Directory shared in RAC:	TRUE
Filters used:	2 EXCLUSION filters

DB Capture Report

[url=]Capture Statistics[/url]
[url=]Workload Captured[/url]
[url=]Workload Not Captured - Contains Unreplayable Calls[/url]
[url=]Workload Not Captured - User Filtered[/url]
[url=]Workload Not Captured - DB Scheduler Jobs and Background Activity[/url]
[url=]SQL Text[/url]
[url=]Workload Filters[/url]

[url=]Back to Top[/url]

Captured Workload Statistics

'Value' represents the corresponding statistic aggregated across the entire captured database workload.
'% Total' is the percentage of 'Value' over the corresponding system-wide aggregated total.

Statistic Name	Value	% Total
DB time (secs)	5.10	70.83
Average Active Sessions	0.01
User calls captured	4328	65.58
User calls captured with Errors	0
Session logins	13	28.26
Transactions	2100	94.51

[url=]Back to Top[/url]

Workload Captured

[url=]Top Events Captured[/url]
[url=]Top Service/Module Captured[/url]
[url=]Top SQL Captured[/url]
[url=]Top Sessions Captured[/url]

[url=]Back to Top[/url]
Top Events Captured                No data exists for this section of the report.
[url=]Back to Workload Captured[/url]
[url=]Back to Top[/url]

Top Service/Module Captured                No data exists for this section of the report.
[url=]Back to Workload Captured[/url]
[url=]Back to Top[/url]

Top SQL Captured                No data exists for this section of the report.
[url=]Back to Workload Captured[/url]
[url=]Back to Top[/url]

Top Sessions Captured                No data exists for this section of the report.
[url=]Back to Workload Captured[/url]
[url=]Back to Top[/url]

Workload Not Captured - Contains Unreplayable Calls

[url=]Top Events containing Unreplayable Calls[/url]
[url=]Top Service/Module containing Unreplayable Calls[/url]
[url=]Top SQL containing Unreplayable Calls[/url]
[url=]Top Sessions containing Unreplayable Calls[/url]

[url=]Back to Top[/url]
Top Events containing Unreplayable Calls                No data exists for this section of the report.
[url=]Back to Workload Not Captured - Contains Unreplayable Calls[/url]
[url=]Back to Top[/url]

Top Service/Module containing Unreplayable Calls                No data exists for this section of the report.
[url=]Back to Workload Not Captured - Contains Unreplayable Calls[/url]
[url=]Back to Top[/url]

Top SQL containing Unreplayable Calls                No data exists for this section of the report.
[url=]Back to Workload Not Captured - Contains Unreplayable Calls[/url]
[url=]Back to Top[/url]

Top Sessions containing Unreplayable Calls                No data exists for this section of the report.
[url=]Back to Workload Not Captured - Contains Unreplayable Calls[/url]
[url=]Back to Top[/url]

Workload Not Captured - User Filtered

[url=]Top Events Filtered Out[/url]
[url=]Top Service/Module Filtered Out[/url]
[url=]Top SQL Filtered Out[/url]
[url=]Top Sessions Filtered Out[/url]

[url=]Back to Top[/url]
Top Events Filtered Out

Event	Event Class	% Event	Avg Active Sessions
CPU + Wait for CPU	CPU	100.00	0.01

[url=]Back to Workload Not Captured - User Filtered[/url]
[url=]Back to Top[/url]

Top Service/Module Filtered Out

Service	Module	% Activity	Action	% Action
orcl	OEM.SystemPool	75.00	NotificationMgr	75.00
SYS$USERS	emagent_AQMetrics	25.00	DEQ	25.00

[url=]Back to Workload Not Captured - User Filtered[/url]
[url=]Back to Top[/url]

Top SQL Filtered Out

SQL ID	% Activity	Event	% Event	SQL Text
[url=]2b064ybzkwf1y[/url]	75.00	CPU + Wait for CPU	75.00	BEGIN EMD_NOTIFICATION.QUEUE_R...
[url=]3972rvxu3knn3[/url]	25.00	CPU + Wait for CPU	25.00	delete from sdo_geor_ddl__tabl...

[url=]Back to Workload Not Captured - User Filtered[/url]
[url=]Back to Top[/url]

Top Sessions Filtered Out

'# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity.
'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event
For sessions running Parallel Queries, this section will NOT aggregate the PQ slave activity into the session issuing the PQ. Refer to the 'Top Sessions running PQs' section for such statistics.

Sid, Serial#	% Activity	Event	% Event	User	Program	# Samples Active	XIDs
135, 8	75.00	CPU + Wait for CPU	75.00	SYSMAN	OMS	3/490 [ 1%]	0
8, 14	25.00	CPU + Wait for CPU	25.00	DBSNMP	emagent@statio...m (TNS V1-V3)	1/490 [ 0%]	0

[url=]Back to Workload Not Captured - User Filtered[/url]
[url=]Back to Top[/url]

Workload Not Captured - DB Scheduler Jobs and Background Activity

[url=]Top Events (Jobs and Background Activity)[/url]
[url=]Top Service/Module (Jobs and Background Activity)[/url]
[url=]Top SQL (Jobs and Background Activity)[/url]
[url=]Top Sessions (Jobs and Background Activity)[/url]

[url=]Back to Top[/url]
Top Events (Jobs and Background Activity)                No data exists for this section of the report.
[url=]Back to Workload Not Captured - DB Scheduler Jobs and Background Activity[/url]
[url=]Back to Top[/url]

Top Service/Module (Jobs and Background Activity)                No data exists for this section of the report.
[url=]Back to Workload Not Captured - DB Scheduler Jobs and Background Activity[/url]
[url=]Back to Top[/url]

Top SQL (Jobs and Background Activity)                No data exists for this section of the report.
[url=]Back to Workload Not Captured - DB Scheduler Jobs and Background Activity[/url]
[url=]Back to Top[/url]

Top Sessions (Jobs and Background Activity)                No data exists for this section of the report.
[url=]Back to Workload Not Captured - DB Scheduler Jobs and Background Activity[/url]
[url=]Back to Top[/url]

Complete List of SQL Text

SQL Id	SQL Text
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
3972rvxu3knn3	delete from sdo_geor_ddl__table$$

[url=]Back to Top[/url]

Workload Filters

#	Filter Name	Type	Attribute	Value
1	ORACLE MANAGEMENT AGENT (DEFAULT)	EXCLUDE	PROGRAM	emagent%
2	ORACLE MANAGEMENT SERVICE (DEFAULT)	EXCLUDE	PROGRAM	OMS

[url=]Back to Top[/url]

End of Report

Replay报告：

DB Replay Report for replay_capturegrid1

DB Name	DB Id	Release	RAC	Replay Name	Replay Status
ORCL	1474621900	11.2.0.1.0	NO	replay_capturegrid1	COMPLETED

   Replay Information

Information	Replay	Capture
Name	replay_capturegrid1	capturegrid1
Status	COMPLETED	COMPLETED
Database Name	ORCL	ORCL
Database Version	11.2.0.1.0	11.2.0.1.0
Start Time	22-07-17 02:20:51	22-07-17 01:07:25
End Time	22-07-17 02:25:54	22-07-17 01:15:35
Duration	5 minutes 3 seconds	8 minutes 10 seconds
Directory Object	DBREPLAY	DBREPLAY
Directory Path	/home/oracle/solutions/dbreplay	/home/oracle/solutions/dbreplay

   Replay Options

Option Name	Value
Synchronization	SCN
Connect Time	100%
Think Time	10%
Think Time Auto Correct	TRUE
Number of WRC Clients	2 (2 Completed, 0 Running )

   Replay Statistics

Statistic	Replay	Capture
DB Time	4.596 seconds	5.099 seconds
Average Active Sessions	.02	.01
User calls	4328	4328
Network Time	27.728 seconds	.
Think Time	18.502 seconds	.

   Replay Divergence Summary

Divergence Type	Count	% Total
Session Failures During Replay	0	0.00
Errors No Longer Seen During Replay	0	0.00
New Errors Seen During Replay	0	0.00
Errors Mutated During Replay	0	0.00
DMLs with Different Number of Rows Modified	0	0.00
SELECTs with Different Number of Rows Fetched	0	0.00

            Workload Profile
            Top Events
                                                                     (-) Hide