Database Capture Report For PRISMA

DB Name DB Id Release RAC Capture Name Status

PRISMA 3673847771 11.2.0.1.0 NO YJAQUIER capture COMPLETED

DB Name	DB Id	Release	RAC	Capture Name	Status
PRISMA	3673847771	11.2.0.1.0	NO	YJAQUIER capture	COMPLETED

Information Capture

Start time: 24-Jan-12 15:32:56 (SCN = 9324626169178)

End time: 24-Jan-12 15:55:37 (SCN = 9324626188655)

Duration: 22 minutes 41 seconds

Capture size: 157.46 KB

Directory object: DBCAPTURE

Directory path: /home/orapris/yannick/dbcapture

Directory shared in RAC: TRUE

Filters used: 1 INCLUSION filter

Error code:

Error message: Load test over

Information	Capture
Start time:	24-Jan-12 15:32:56 (SCN = 9324626169178)
End time:	24-Jan-12 15:55:37 (SCN = 9324626188655)
Duration:	22 minutes 41 seconds
Capture size:	157.46 KB
Directory object:	DBCAPTURE
Directory path:	/home/orapris/yannick/dbcapture
Directory shared in RAC:	TRUE
Filters used:	1 INCLUSION filter
Error code:
Error message:	Load test over

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)	205.85	9.01
Average Active Sessions	0.15
User calls captured	56	0.01
User calls captured with Errors	4
Session logins	128	97.71
Transactions	2	0.00

Top Events Captured

Event	Event Class	% Event	Avg Active Sessions
db file scattered read	User I/O	4.33	0.09
CPU + Wait for CPU	CPU	1.83	0.04
direct path read	User I/O	1.12	0.02

Back to Workload Captured
Back to Top

Top Service/Module Captured

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

Back to Workload Captured
Back to Top

Top SQL Captured

SQL ID	% Activity	Event	% Event	SQL Text
5xn7rdr417bmk	5.08	db file scattered read	3.33	DECLARE i NUMBER; random_id NU...
		CPU + Wait for CPU	1.31
4c40ph2v0v3cq	1.23	db file scattered read	1.01	UPDATE test1 SET id=15702806 w...

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
349,32262	7.44	db file scattered read	4.33	YJAQUIER	sqlplus@server1 (TNS V1-V3)	116/1,361 [ 9%]	1
		CPU + Wait for CPU	1.83			49/1,361 [ 4%]	1
		direct path read	1.12			30/1,361 [ 2%]	0

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
db file scattered read	User I/O	21.11	0.42
CPU + Wait for CPU	CPU	19.36	0.38
db file sequential read	User I/O	19.28	0.38
enq: TX - row lock contention	Application	13.45	0.26
direct path read	User I/O	1.83	0.04

Back to Workload Not Captured - User Filtered
Back to Top

Top Service/Module Filtered Out

Service	Module	% Activity	Action	% Action
SYS$USERS	JDBC Thin Client	76.72	UNNAMED	76.72

Back to Workload Not Captured - User Filtered
Back to Top

Top SQL Filtered Out

SQL ID	% Activity	Event	% Event	SQL Text
6mnzzcs9barwq	13.45	enq: TX - row lock contention	13.45	INSERT INTO org_cust_mapping C...
81c1xvnmsyr64	10.13	db file scattered read	6.24	UPDATE mn_ht_contract_li_ver S...
		db file sequential read	2.77
		CPU + Wait for CPU	1.12
23snaz93bxuk6	9.57	db file scattered read	5.12	UPDATE mn_ht_contract_li_ver S...
		db file sequential read	2.99
		CPU + Wait for CPU	1.46
8aukpq4gxcrf9	8.67	db file scattered read	4.52	UPDATE mn_ht_contract_li_ver S...
		db file sequential read	2.58
		CPU + Wait for CPU	1.57
br73cuz2mqx4c	8.18	db file scattered read	4.97	UPDATE mn_ht_contract_li_ver S...
		db file sequential read	2.09
		CPU + Wait for CPU	1.12

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
174, 688	32.40	enq: TX - row lock contention	13.45	DATALOAD	JDBC Thin Client	360/1,361 [ 26%]	1
		db file scattered read	10.46			280/1,361 [ 21%]	1
		db file sequential read	5.75			154/1,361 [ 11%]	1
153,28933	19.84	db file scattered read	10.58	DATALOAD	JDBC Thin Client	283/1,361 [ 21%]	1
		db file sequential read	5.98			160/1,361 [ 12%]	1
		CPU + Wait for CPU	3.29			88/1,361 [ 6%]	2
1162, 193	2.65	db file sequential read	1.64	DATALOAD	JDBC Thin Client	44/1,361 [ 3%]	18
392,18698	2.17	db file sequential read	2.06	DATALOAD	JDBC Thin Client	55/1,361 [ 4%]	0
1334, 209	1.94	direct path read	1.05	DATALOAD	JDBC Thin Client	28/1,361 [ 2%]	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
db file parallel write	System I/O	12.52	0.25
log file parallel write	System I/O	1.64	0.03

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	15.10	UNNAMED	15.10

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
431, 1	3.44	db file parallel write	3.44	SYS	oracle@server1 (DBW0)	92/1,361 [ 7%]
560, 1	3.21	db file parallel write	3.21	SYS	oracle@server1 (DBW3)	86/1,361 [ 6%]
517, 1	2.99	db file parallel write	2.99	SYS	oracle@server1 (DBW2)	80/1,361 [ 6%]
474, 1	2.88	db file parallel write	2.88	SYS	oracle@server1 (DBW1)	77/1,361 [ 6%]
603, 1	1.64	log file parallel write	1.64	SYS	oracle@server1 (LGWR)	44/1,361 [ 3%]

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

Complete List of SQL Text

SQL Id SQL Text

23snaz93bxuk6 UPDATE mn_ht_contract_li_ver SET program_id = 138943 WHERE program_id = 139052

4c40ph2v0v3cq UPDATE test1 SET id=15702806 where id=15702806

5xn7rdr417bmk DECLARE i NUMBER; random_id NUMBER; maxid NUMBER; stmt VARCHAR2(100); BEGIN SELECT NVL(MAX(id), 0) INTO maxid FROM test1; FOR i IN 1..10 LOOP random_id:=round(dbms_random.value(1, maxid)); stmt:='UPDATE test1 SET id=' || random_id || ' WHERE id=' || random_id; dbms_output.put_line(stmt); execute immediate stmt; END LOOP; COMMIT; END;

6mnzzcs9barwq INSERT INTO org_cust_mapping COLUMNS (org_oid, customer_oid, is_primary, is_rep_terminated) VALUES(:1 , :2 , :3 , 0)

81c1xvnmsyr64 UPDATE mn_ht_contract_li_ver SET program_id = 74745 WHERE program_id = 138956

8aukpq4gxcrf9 UPDATE mn_ht_contract_li_ver SET assembly_id = 85025 WHERE assembly_id = 152746

br73cuz2mqx4c UPDATE mn_ht_contract_li_ver SET assembly_id = 152732 WHERE assembly_id = 152847

SQL Id	SQL Text
23snaz93bxuk6	UPDATE mn_ht_contract_li_ver SET program_id = 138943 WHERE program_id = 139052
4c40ph2v0v3cq	UPDATE test1 SET id=15702806 where id=15702806
5xn7rdr417bmk	DECLARE i NUMBER; random_id NUMBER; maxid NUMBER; stmt VARCHAR2(100); BEGIN SELECT NVL(MAX(id), 0) INTO maxid FROM test1; FOR i IN 1..10 LOOP random_id:=round(dbms_random.value(1, maxid)); stmt:='UPDATE test1 SET id=' \|\| random_id \|\| ' WHERE id=' \|\| random_id; dbms_output.put_line(stmt); execute immediate stmt; END LOOP; COMMIT; END;
6mnzzcs9barwq	INSERT INTO org_cust_mapping COLUMNS (org_oid, customer_oid, is_primary, is_rep_terminated) VALUES(:1 , :2 , :3 , 0)
81c1xvnmsyr64	UPDATE mn_ht_contract_li_ver SET program_id = 74745 WHERE program_id = 138956
8aukpq4gxcrf9	UPDATE mn_ht_contract_li_ver SET assembly_id = 85025 WHERE assembly_id = 152746
br73cuz2mqx4c	UPDATE mn_ht_contract_li_ver SET assembly_id = 152732 WHERE assembly_id = 152847

Workload Filters

#	Filter Name	Type	Attribute	Value
1	YJAQUIER USER	INCLUDE	USER	YJAQUIER

End of Report