Database Capture Report For OCM11G

DB Name	DB Id	Release	RAC	Capture Name	Status
OCM11G	3371126031	11.1.0.7.0	NO	CAPTURE-ocm11g.yaocm.id.au-20120222114009	COMPLETED

Information	Capture
Start time:	22-Feb-12 11:48:49 (SCN = 1117754)
End time:	22-Feb-12 11:54:30 (SCN = 1118319)
Duration:	5 minutes 41 seconds
Capture size:	77.14 KB
Directory object:	SH_REPLAY
Directory path:	/u00/app/oracle/replay/sh
Directory shared in RAC:	TRUE
Filters used:	1 INCLUSION filter

DB Capture Report

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)	22.82	79.51
Average Active Sessions	0.07
User calls captured	414	34.64
User calls captured with Errors	0
Session logins	19	65.52
Transactions	0	0.00

Workload Captured

Top Events Captured

Event	Event Class	% Event	Avg Active Sessions
read by other session	User I/O	23.33	0.02
db file sequential read	User I/O	20.00	0.02
CPU + Wait for CPU	CPU	3.33	0.00
direct path read	User I/O	3.33	0.00
log file sync	Commit	3.33	0.00

Back to Workload Captured
Back to Top

Top Service/Module Captured

Service	Module	% Activity	Action	% Action
SYS$USERS	SQL*Plus	53.33	UNNAMED	53.33

Back to Workload Captured
Back to Top

Top SQL Captured

SQL ID	% Activity	Event	% Event	SQL Text
dgdfqhj9ua2kv	50.00	read by other session	23.33	SELECT products.prod_categ...
		db file sequential read	20.00
		CPU + Wait for CPU	3.33

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
139, 6696	23.33	db file sequential read	13.33	SH	sqlplus@bankst...u (TNS V1-V3)	4/341 [ 1%]
		read by other session	6.67			2/341 [ 1%]
		direct path read	3.33			1/341 [ 0%]
110, 3738	13.33	db file sequential read	6.67	SH	sqlplus@bankst...u (TNS V1-V3)	2/341 [ 1%]
		read by other session	6.67			2/341 [ 1%]
128, 6777	10.00	read by other session	10.00	SH	sqlplus@bankst...u (TNS V1-V3)	3/341 [ 1%]
139, 6716	3.33	CPU + Wait for CPU	3.33	SH	sqlplus@bankst...u (TNS V1-V3)	1/341 [ 0%]
170, 2308	3.33	log file sync	3.33	SH	sqlplus@bankst...u (TNS V1-V3)	1/341 [ 0%]

Back to Workload Captured
Back to Top

Workload Not Captured - Contains Unreplayable Calls

Top Events containing Unreplayable Calls

Event	Event Class	% Event	Avg Active Sessions
log file sync	Commit	6.67	0.01

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

Top Service/Module containing Unreplayable Calls

Service	Module	% Activity	Action	% Action
SYS$USERS	sqlplus@bankstown.yaocm.id.au (TNS V1-V3)	6.67	UNNAMED	6.67

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

'# 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
110, 3738	3.33	log file sync	3.33	SH	sqlplus@bankst...u (TNS V1-V3)	1/341 [ 0%]	0
128, 6777	3.33	log file sync	3.33	SH	sqlplus@bankst...u (TNS V1-V3)	1/341 [ 0%]	0

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

Workload Not Captured - User Filtered

Top Events Filtered Out

Event	Event Class	% Event	Avg Active Sessions
CPU + Wait for CPU	CPU	3.33	0.00

Back to Workload Not Captured - User Filtered
Back to Top

Top Service/Module Filtered Out

Service	Module	% Activity	Action	% Action
SYS$USERS	emagent_SQL_oracle_database	3.33	all_vpd_policies	3.33

Back to Workload Not Captured - User Filtered
Back to Top

Top SQL Filtered Out

SQL ID	% Activity	Event	% Event	SQL Text
cgyvau8fub4rq	3.33	CPU + Wait for CPU	3.33	/* OracleOEM */ SELECT P.OBJ...

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
127, 1983	3.33	CPU + Wait for CPU	3.33	DBSNMP	emagent@bankst...u (TNS V1-V3)	1/341 [ 0%]	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)

Event	Event Class	% Event	Avg Active Sessions
log file parallel write	System I/O	26.67	0.02
CPU + Wait for CPU	CPU	3.33	0.00
control file parallel write	System I/O	3.33	0.00
log file sync	Commit	3.33	0.00

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	33.33	UNNAMED	33.33
SYS$USERS	DBMS_SCHEDULER	3.33	RLM$EVTCLEANUP	3.33

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
161, 1	26.67	log file parallel write	26.67	SYS	oracle@banksto....id.au (LGWR)	8/341 [ 2%]
160, 1	3.33	control file parallel write	3.33	SYS	oracle@banksto....id.au (CKPT)	1/341 [ 0%]
162, 1	3.33	CPU + Wait for CPU	3.33	SYS	oracle@banksto....id.au (DBW0)	1/341 [ 0%]
170, 2297	3.33	log file sync	3.33	SYS	oracle@banksto....id.au (J000)	1/341 [ 0%]

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

Complete List of SQL Text

SQL Id	SQL Text
cgyvau8fub4rq	/* OracleOEM */ SELECT P.OBJECT_NAME, O.OBJECT_TYPE, P.OBJECT_OWNER, P.POLICY_NAME, P.POLICY_GROUP, P.ENABLE FROM DBA_POLICIES P, DBA_OBJECTS O WHERE P.OBJECT_NAME=O.OBJECT_NAME
dgdfqhj9ua2kv	SELECT products.prod_category, products.prod_subcategory, times.calendar_year, SUM( sales.quantity_sold ) AS total_quantity_sold, SUM( sales.amount_sold ) AS total_amount_sold FROM sales INNER JOIN products USING( prod_id ) INNER JOIN customers USING( cust_id ) INNER JOIN countries USING( country_id ) INNER JOIN channels USING( channel_id ) INNER JOIN times USING( time_id ) WHERE products.prod_valid = 'A' AND channels.channel_class = 'Direct' AND customers.cust_valid = 'A' AND countries.country_name = 'Australia' GROUP BY products.prod_category, products.prod_subcategory, times.calendar_year ORDER BY products.prod_category, products.prod_subcategory, times.calendar_year

SQL Id

SQL Text

cgyvau8fub4rq

/* OracleOEM */ SELECT P.OBJECT_NAME, O.OBJECT_TYPE, P.OBJECT_OWNER, P.POLICY_NAME, P.POLICY_GROUP, P.ENABLE FROM DBA_POLICIES P, DBA_OBJECTS O WHERE P.OBJECT_NAME=O.OBJECT_NAME

dgdfqhj9ua2kv

SELECT products.prod_category, products.prod_subcategory, times.calendar_year, SUM( sales.quantity_sold ) AS total_quantity_sold, SUM( sales.amount_sold ) AS total_amount_sold FROM sales INNER JOIN products USING( prod_id ) INNER JOIN customers USING( cust_id ) INNER JOIN countries USING( country_id ) INNER JOIN channels USING( channel_id ) INNER JOIN times USING( time_id ) WHERE products.prod_valid = 'A' AND channels.channel_class = 'Direct' AND customers.cust_valid = 'A' AND countries.country_name = 'Australia' GROUP BY products.prod_category, products.prod_subcategory, times.calendar_year ORDER BY products.prod_category, products.prod_subcategory, times.calendar_year

Workload Filters

#	Filter Name	Type	Attribute	Value
1	SH_USER	INCLUDE	USER	SH

End of Report

Servlet error: Internal Error has occured. Check the log file for details.