Database Capture Report For ORCL

DB Name DB Id Release RAC Capture Name Status

ORCL 1166960197 11.1.0.6.0 NO DBR_CAPTURE_100 COMPLETED

DB Name	DB Id	Release	RAC	Capture Name	Status
ORCL	1166960197	11.1.0.6.0	NO	DBR_CAPTURE_100	COMPLETED

Information Capture

Start time: 23-May-08 16:49:35 (SCN = 4164210)

End time: 23-May-08 16:52:05 (SCN = 4166463)

Duration: 2 minutes 30 seconds

Capture size: 105.63 KB

Directory object: DBRCONTROL

Directory path: /home/oracle/DBRControl

Directory shared in RAC: TRUE

Filters used: 2 EXCLUSION filters

Information	Capture
Start time:	23-May-08 16:49:35 (SCN = 4164210)
End time:	23-May-08 16:52:05 (SCN = 4166463)
Duration:	2 minutes 30 seconds
Capture size:	105.63 KB
Directory object:	DBRCONTROL
Directory path:	/home/oracle/DBRControl
Directory shared in RAC:	TRUE
Filters used:	2 EXCLUSION filters

DB Capture Report

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

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)	143.18	68.28
Average Active Sessions	0.95
User calls captured	496	13.30
User calls captured with Errors	0
Session logins	34	70.83
Transactions	467	73.31

Top Events Captured

Event	Event Class	% Event	Avg Active Sessions
CPU + Wait for CPU	CPU	30.43	0.47
buffer deadlock	Other	13.04	0.20
enq: TX - index contention	Concurrency	8.70	0.13
db file sequential read	User I/O	4.35	0.07

Back to Workload Captured
Back to Top

Top Service/Module Captured

Service	Module	% Activity	Action	% Action
BATCH_STD	LoadGenerator	39.13	BuildInvoiceDetail	39.13
BATCH_LOW	LoadGenerator	17.39	BuildInvoiceDetail	13.04
			BuildInvoices	4.35

Back to Workload Captured
Back to Top

Top SQL Captured

SQL ID	% Activity	Event	% Event	SQL Text
4ymp71aaj3bud	26.09	CPU + Wait for CPU	26.09	BEGIN AP.PKG_LOAD_GENERATO...
1bshjy696nrzg	17.39	enq: TX - index contention	8.70	BEGIN AP.PKG_LOAD_GENERATO...
		buffer deadlock	4.35
		db file sequential read	4.35
0wvttswphs2ky	13.04	buffer deadlock	8.70	BEGIN AP.PKG_LOAD_GENERATO...
		CPU + Wait for CPU	4.35

Back to Workload Captured
Back to Top

Top Sessions Captured

'# 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
112, 5	17.39	enq: TX - index contention	8.70	SH	sqlplus@11gR1NF (TNS V1-V3)	2/15 [ 13%]	2
		buffer deadlock	4.35			1/15 [ 7%]	1
		db file sequential read	4.35			1/15 [ 7%]	0
114, 17	17.39	CPU + Wait for CPU	17.39	OE	sqlplus@11gR1NF (TNS V1-V3)	4/15 [ 27%]	4
99, 7	8.70	CPU + Wait for CPU	4.35	OE	sqlplus@11gR1NF (TNS V1-V3)	1/15 [ 7%]	1
		buffer deadlock	4.35			1/15 [ 7%]	1
109, 2	8.70	CPU + Wait for CPU	8.70	OE	sqlplus@11gR1NF (TNS V1-V3)	2/15 [ 13%]	2
116, 28	4.35	buffer deadlock	4.35	OE	sqlplus@11gR1NF (TNS V1-V3)	1/15 [ 7%]	1

Back to Workload Captured
Back to Top

Workload Not Captured - Contains Unreplayable Calls

Top Events containing Unreplayable Calls
Top Service/Module containing Unreplayable Calls
Top SQL containing Unreplayable Calls
Top Sessions containing Unreplayable Calls

Top Events containing Unreplayable Calls

No data exists for this section of the report.

Back to Workload Not Captured - Contains Unreplayable Calls
Back to Top

Top Service/Module containing Unreplayable Calls

No data exists for this section of the report.

Back to Workload Not Captured - Contains Unreplayable Calls
Back to Top

Top SQL containing Unreplayable Calls

No data exists for this section of the report.

Back to Workload Not Captured - Contains Unreplayable Calls
Back to Top

Top Sessions containing Unreplayable Calls

No data exists for this section of the report.

Back to Workload Not Captured - Contains Unreplayable Calls
Back to Top

Workload Not Captured - User Filtered

Top Events Filtered Out
Top Service/Module Filtered Out
Top SQL Filtered Out
Top Sessions Filtered Out

Top Events Filtered Out

Event	Event Class	% Event	Avg Active Sessions
log file sync	Commit	13.04	0.20
CPU + Wait for CPU	CPU	4.35	0.07
db file sequential read	User I/O	4.35	0.07

Back to Workload Not Captured - User Filtered
Back to Top

Top Service/Module Filtered Out

Service	Module	% Activity	Action	% Action
orcl.oracle.com	OEM.BoundedPool	8.70	UNNAMED	8.70
	OMS	8.70	UNNAMED	8.70
	OEM.DefaultPool	4.35	/database/instance/sitemap	4.35

Back to Workload Not Captured - User Filtered
Back to Top

Top SQL Filtered Out

SQL ID	% Activity	Event	% Event	SQL Text
4ckzywf6w81bk	4.35	db file sequential read	4.35	SELECT ELEM_TYPE_NAME, ELEM_T...
c69cz0cs2a76y	4.35	CPU + Wait for CPU	4.35	BEGIN EMDW_LOG.set_context(MGM...

Back to Workload Not Captured - User Filtered
Back to Top

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
131, 22	8.70	CPU + Wait for CPU	4.35	SYSMAN	OMS	1/15 [ 7%]	1
		log file sync	4.35			1/15 [ 7%]	0
121, 1	4.35	log file sync	4.35	SYSMAN	OMS	1/15 [ 7%]	0
128, 6	4.35	log file sync	4.35	SYSMAN	OMS	1/15 [ 7%]	0
170, 17	4.35	db file sequential read	4.35	SYSMAN	OMS	1/15 [ 7%]	0

Back to Workload Not Captured - User Filtered
Back to Top

Workload Not Captured - DB Scheduler Jobs and Background Activity

Top Events (Jobs and Background Activity)
Top Service/Module (Jobs and Background Activity)
Top SQL (Jobs and Background Activity)
Top Sessions (Jobs and Background Activity)

Top Events (Jobs and Background Activity)

Event	Event Class	% Event	Avg Active Sessions
log file parallel write	System I/O	13.04	0.20
control file parallel write	System I/O	4.35	0.07
db file sequential read	User I/O	4.35	0.07

Back to Workload Not Captured - DB Scheduler Jobs and Background Activity
Back to Top

Top Service/Module (Jobs and Background Activity)

Service	Module	% Activity	Action	% Action
SYS$BACKGROUND	UNNAMED	17.39	UNNAMED	17.39
SYS$USERS	UNNAMED	4.35	UNNAMED	4.35

Back to Workload Not Captured - DB Scheduler Jobs and Background Activity
Back to Top

Top SQL (Jobs and Background Activity)

No data exists for this section of the report.

Back to Workload Not Captured - DB Scheduler Jobs and Background Activity
Back to Top

Top Sessions (Jobs and Background Activity)

'# 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
162, 1	13.04	log file parallel write	13.04	SYS	oracle@11gR1NF (LGWR)	3/15 [ 20%]	0
129, 4	4.35	db file sequential read	4.35	SYSMAN	oracle@11gR1NF (J001)	1/15 [ 7%]	1
154, 5	4.35	control file parallel write	4.35	SYS	oracle@11gR1NF (RVWR)	1/15 [ 7%]	0

Back to Workload Not Captured - DB Scheduler Jobs and Background Activity
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0wvttswphs2ky BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(250); COMMIT; END;

1bshjy696nrzg BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(375); COMMIT; END;

4ckzywf6w81bk SELECT ELEM_TYPE_NAME, ELEM_TYPE_OWNER FROM ALL_COLL_TYPES WHERE TYPE_NAME='MGMT_INV_TARGET_LIST_OBJ_ARRAY' AND OWNER='SYSMAN'

4ymp71aaj3bud BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(500); COMMIT; END;

c69cz0cs2a76y BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.update_async_op_status(:2, :3, :4); END; EMDW_LOG.set_context; END;

SQL Id	SQL Text
0wvttswphs2ky	BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(250); COMMIT; END;
1bshjy696nrzg	BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(375); COMMIT; END;
4ckzywf6w81bk	SELECT ELEM_TYPE_NAME, ELEM_TYPE_OWNER FROM ALL_COLL_TYPES WHERE TYPE_NAME='MGMT_INV_TARGET_LIST_OBJ_ARRAY' AND OWNER='SYSMAN'
4ymp71aaj3bud	BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(500); COMMIT; END;
c69cz0cs2a76y	BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.update_async_op_status(:2, :3, :4); END; EMDW_LOG.set_context; END;

Workload Filters

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

End of Report