Database Capture Report For TEST1020

DB Name DB Id Release RAC Capture Name Status

TEST1020 1510982787 10.2.0.4.0 NO CAPTURE-TEST1020-20080608153343 COMPLETED

DB Name	DB Id	Release	RAC	Capture Name	Status
TEST1020	1510982787	10.2.0.4.0	NO	CAPTURE-TEST1020-20080608153343	COMPLETED

Information Capture

Start time: 08-Jun-08 15:34:38 (SCN = 20877288)

End time: 08-Jun-08 15:39:38 (SCN = 20888971)

Duration: 5 minutes 0 seconds

Capture size: 2.16 MB

Directory object: DATA_PUMP_DIR

Directory path: C:\oracle\product\10.2.0\admin\test1020\dpdump\

Directory shared in RAC: TRUE

Filters used: 2 EXCLUSION filters

Information	Capture
Start time:	08-Jun-08 15:34:38 (SCN = 20877288)
End time:	08-Jun-08 15:39:38 (SCN = 20888971)
Duration:	5 minutes 0 seconds
Capture size:	2.16 MB
Directory object:	DATA_PUMP_DIR
Directory path:	C:\oracle\product\10.2.0\admin\test1020\dpdump\
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)	517.52	86.74
Average Active Sessions	1.73
User calls captured	8782	80.42
User calls captured with Errors	2
Session logins	4	33.33
Transactions	6123	88.69

Top Events Captured

Event	Event Class	% Activity	Avg Active Sessions
log file sync	Commit	25.77	0.75
db file sequential read	User I/O	21.42	0.62
CPU + Wait for CPU	CPU	6.64	0.19
db file scattered read	User I/O	4.93	0.14

Back to Workload Captured
Back to Top

Top Service/Module Captured

Service	Module	% Activity	Action	% Action
TEST1020	UNNAMED	27.38	UNNAMED	27.38
	New Customer	11.91	UNNAMED	11.80
	New Order	9.85	getCustomerDetails	4.70
			UNNAMED	2.75
			getProductDetailsByCategory	2.41
	Browse and Update Orders	4.47	getCustomerDetails	4.24
	Browse Products	4.35	getCustomerDetails	4.01

Back to Workload Captured
Back to Top

Top SQL Captured

SQL ID	% Activity	Event	% Event	SQL Text
75621g9y3xmvd	13.06	db file sequential read	9.97	SELECT CUSTOMER_ID, CUST_FIRS...
		db file scattered read	2.98
0bzhqhhj9mpaa	11.80	db file sequential read	9.97	INSERT INTO CUSTOMERS(CUSTOMER...
		db file scattered read	1.72
dw2zgaapax1sg	2.29	CPU + Wait for CPU	2.29	SELECT PRODUCTS.PRODUCT_ID, P...
0yas01u2p9ch4	1.37	db file sequential read	1.15	INSERT INTO ORDER_ITEMS(ORDER_...

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
158, 1132	29.44	log file sync	12.14	SOE	java.exe	106/300 [ 35%]	0
		db file sequential read	11.34			99/300 [ 33%]	47
		CPU + Wait for CPU	3.21			28/300 [ 9%]	7
139, 1245	28.98	log file sync	13.63	SOE	java.exe	119/300 [ 40%]	0
		db file sequential read	9.97			87/300 [ 29%]	46
		CPU + Wait for CPU	2.86			25/300 [ 8%]	4

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

No data exists for this section of the report.

Back to Workload Not Captured - User Filtered
Back to Top

Top Service/Module Filtered Out

No data exists for this section of the report.

Back to Workload Not Captured - User Filtered
Back to Top

Top SQL Filtered Out

No data exists for this section of the report.

Back to Workload Not Captured - User Filtered
Back to Top

Top Sessions Filtered Out

No data exists for this section of the report.

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	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	17.41	0.51
log file parallel write	System I/O	9.85	0.29
db file parallel write	System I/O	8.59	0.25
control file parallel write	System I/O	1.72	0.05
control file sequential read	System I/O	1.60	0.05

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

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
166, 1	25.09	CPU + Wait for CPU	15.23	SYS	ORACLE.EXE (LGWR)	133/300 [ 44%]
		log file parallel write	9.85			86/300 [ 29%]
167, 1	9.97	db file parallel write	8.59	SYS	ORACLE.EXE (DBW0)	75/300 [ 25%]
		CPU + Wait for CPU	1.15			10/300 [ 3%]
165, 1	3.32	control file parallel write	1.72	SYS	ORACLE.EXE (CKPT)	15/300 [ 5%]
		control file sequential read	1.49			13/300 [ 4%]

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

Complete List of SQL Text

SQL Id SQL Text

0bzhqhhj9mpaa INSERT INTO CUSTOMERS(CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID ) VALUES (:B9 , :B4 , :B3 , :B8 , :B7 , FLOOR(DBMS_RANDOM.VALUE(:B6 , :B5 )), :B4 ||'.'||:B3 ||'@'||'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B2 , :B1 )))

0yas01u2p9ch4 INSERT INTO ORDER_ITEMS(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) VALUES (:B4 , :B3 , :B2 , :B1 , 1)

75621g9y3xmvd SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B1

dw2zgaapax1sg SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B1 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID ORDER BY INVENTORIES.WAREHOUSE_ID

SQL Id	SQL Text
0bzhqhhj9mpaa	INSERT INTO CUSTOMERS(CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID ) VALUES (:B9 , :B4 , :B3 , :B8 , :B7 , FLOOR(DBMS_RANDOM.VALUE(:B6 , :B5 )), :B4 \|\|'.'\|\|:B3 \|\|'@'\|\|'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B2 , :B1 )))
0yas01u2p9ch4	INSERT INTO ORDER_ITEMS(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) VALUES (:B4 , :B3 , :B2 , :B1 , 1)
75621g9y3xmvd	SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B1
dw2zgaapax1sg	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B1 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID ORDER BY INVENTORIES.WAREHOUSE_ID

Workload Filters

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

End of Report