ASH Report For PORTALDB/portaldb1

DB Name DB Id Instance Inst num Release RAC Host

PORTALDB 663718102 portaldb1 1 11.2.0.3.0 YES ptdb1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PORTALDB	663718102	portaldb1	1	11.2.0.3.0	YES	ptdb1

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

64 96,338M (100%) 78,592M (81.6%) 15,872M (16.5%) 128.0M (0.1%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
64	96,338M (100%)	78,592M (81.6%)	15,872M (16.5%)	128.0M (0.1%)

Sample Time Data Source

Analysis Begin Time: 18-Jul-14 08:00:00 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 18-Jul-14 09:00:00 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 60.0 (mins)

Sample Count: 56,779

Average Active Sessions: 15.77

Avg. Active Session per CPU: 0.25

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	18-Jul-14 08:00:00	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	18-Jul-14 09:00:00	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	60.0 (mins)
Sample Count:	56,779
Average Active Sessions:	15.77
Avg. Active Session per CPU:	0.25
Report Target:	None specified

Top Events

Top User Events
Top Background Events
Top Cluster Events
Top Event P1/P2/P3 Values

Top User Events

Event	Event Class	% Event	Avg Active Sessions
CPU + Wait for CPU	CPU	47.35	7.47
db file sequential read	User I/O	35.86	5.66

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
db file parallel write	System I/O	7.78	1.23
CPU + Wait for CPU	CPU	1.63	0.26

Top Cluster Events

No data exists for this section of the report.

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
db file sequential read	35.86	"3","33435","1"	0.00	file#	block#	blocks
db file parallel write	7.78	"1","0","2147483647"	1.72	requests	interrupt	timeout
db file parallel write	7.7845682382571020976065094489159724546	"2","0","2147483647"	1.03	requests	interrupt	timeout

Load Profile

Top Service/Module
Top Client IDs
Top SQL Command Types
Top Phases of Execution
Top Remote Instances

Top Service/Module

Service	Module	% Activity	Action	% Action
portaldb	JDBC Thin Client	88.18	UNNAMED	88.18
SYS$BACKGROUND	UNNAMED	11.72	UNNAMED	11.72

Back to Load Profile
Back to Top

Top Client IDs

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL Command Types

'Distinct SQLIDs' is the count of the distinct number of SQLIDs with the given SQL Command Type found over all the ASH samples in the analysis period

SQL Command Type	Distinct SQLIDs	% Activity	Avg Active Sessions
INSERT	120	66.04	10.42
SELECT	4,267	13.28	2.09
UPSERT	24	2.57	0.41
UPDATE	220	1.77	0.28

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution	% Activity	Avg Active Sessions
SQL Execution	83.33	13.14
Parse	4.23	0.67
Hard Parse	3.83	0.60

Back to Load Profile
Back to Top

Top Remote Instances

Wait Class	% Wait Class	Remote Instance#	% Activity
Cluster	1.63	2	1.61

Back to Load Profile
Back to Top

Top SQL

Top SQL with Top Events
Top SQL with Top Row Sources
Top SQL using literals
Top Parsing Module/Action
Complete List of SQL Text

Top SQL with Top Events

SQL ID	Planhash	Sampled # of Executions	% Activity	Event	% Event	Top Row Source	% RwSrc	SQL Text
09gnpt5k762zc	4141772303	48	63.32	CPU + Wait for CPU	31.73	LOAD TABLE CONVENTIONAL	19.25	INSERT INTO RP_SALE001 (ID, AD...
09gnpt5k762zc	4141772303	48	63.32270733898096127089240740414589901196	db file sequential read	29.86	INSERT STATEMENT	29.80
gfk81xzjhn0x8	595925626	56	1.11	db file parallel read	0.58	TABLE ACCESS - BY INDEX ROWID	0.56	MERGE INTO RP_DAILYBALANCE G U...

Top SQL with Top Row Sources

SQL ID	PlanHash	Sampled # of Executions	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
09gnpt5k762zc	4141772303	48	63.32	INSERT STATEMENT	40.99	db file sequential read	29.80	INSERT INTO RP_SALE001 (ID, AD...
09gnpt5k762zc	4141772303	48	63.32270733898096127089240740414589901196	LOAD TABLE CONVENTIONAL	19.30	CPU + Wait for CPU	19.25
09gnpt5k762zc	4141772303	48	63.32270733898096127089240740414589901196	HASH JOIN	1.57	CPU + Wait for CPU	1.57
gfk81xzjhn0x8	595925626	56	1.11	TABLE ACCESS - BY INDEX ROWID	0.88	db file parallel read	0.56	MERGE INTO RP_DAILYBALANCE G U...

Top SQL using literals

No data exists for this section of the report.

Top Parsing Module/Action

Module	Action	% Activity	Event	% Event
JDBC Thin Client		4.23	CPU + Wait for CPU	4.13

Complete List of SQL Text

SQL Id SQL Text

09gnpt5k762zc INSERT INTO RP_SALE001 (ID, AD_CLIENT_ID, SALEBILLTYPE, BILLDATE, DOCNO, DOCTYPE, B_SO_ID, C_CUSTOMERUP_ID, C_STORE_ID, C_CUSTOMER_ID, C_DEST_ID, DESCRIPTION, M_PRODUCT_ID, M_ATTRIBUTESETINSTANCE_ID, AMTSO, QTYORDERED, QTYSALE, QTYSALEOUT, QTYRETSALE, QTYRETSALEIN, PRICELIST, AMTLISTSALE, AMTLISTSALEOUT, AMTLISTRETSALE, AMTLISTRETSALEIN, PRICEACTUAL, AMTSALE, AMTSALEOUT, AMTRETSALE, AMTRETSALEIN, DISCOUNTSALE, DISCOUNTRETSALE, OUTERID, INERID, M_PRODUCT_ALIAS_ID, C_SALEDISTYPE_ID, AD_PI_ID, MXREMARK, C_SALETYPE_ID, PICKERID, C_RETSALETYPE_ID) SELECT 1, 37, A.SALEBILLTYPE, A.DATEOUT AS BILLDATE, A.DOCNO, A.DOCTYPE, A.B_SO_ID, A.C_CUSTOMERUP_ID, A.C_STORE_ID, A.C_CUSTOMER_ID, A.C_DEST_ID, A.DESCRIPTION, B.M_PRODUCT_ID, B.M_ATTRIBUTESETINSTANCE_ID, 0 AS AMTSO, 0 AS QTYORDERED, B.QTY AS QTYSALE, B.QTYOUT AS QTYSALEOUT, 0 AS QTYRETSALE, 0 AS QTYRETSALEIN, B.PRICELIST, B.TOT_AMT_LIST AS AMTLISTSALE, B.TOT_AMTOUT_LIST AS AMTLISTSALEOUT, 0 AS AMTLISTRETSALE, 0 AS AMTLISTRETSALEIN, B.PRICEACTUAL, B.TOT_AMT_ACTUAL AS AMTSALE, B.TOT_AMTOUT_ACTUAL AS AMTSALEOUT, 0 AS AMTRETSALE, 0 AS AMTRETSALEIN, B.DISCOUNT AS DISCOUNTSALE, 0 AS DISCOUNTRETSALE, A.OUTERID, NULL AS INERID, B.M_PRODUCTALIAS_ID AS M_PRODUCT_ALIAS_ID, A.C_SALEDISTYPE_ID, :B8 , B.DESCRIPTION, A.C_SALETYPE_ID, A.PICKERID, NULL FROM M_SALE A, M_SALEITEM B, M_PRODUCT_ALIAS N, TABLE(:B1 ) RSD, TABLE(:B2 ) RS, TABLE(:B3 ) RD, TABLE(:B4 ) RC, TABLE(:B5 ) RP WHERE A.ID = B.M_SALE_ID AND A.C_SALEDISTYPE_ID = RSD.ID AND A.C_STORE_ID = RS.ID AND A.C_DEST_ID = RD.ID AND A.C_CUSTOMER_ID = RC.ID AND B.M_PRODUCT_ID = RP.ID AND B.QTYOUT != 0 AND A.STATUS = 2 AND A.OUT_STATUS = 2 AND A.DATEOUT BETWEEN :B7 AND :B6 UNION ALL SELECT 1, 37, NULL AS SALEBILLTYPE, A.DATEIN AS BILLDATE, A.DOCNO, A.DOCTYPE, NULL AS B_SO_ID, A.C_CUSTOMERUP_ID, A.C_STORE_ID, A.C_CUSTOMER_ID, A.C_ORIG_ID AS C_DEST_ID, A.DESCRIPTION, B.M_PRODUCT_ID, B.M_ATTRIBUTESETINSTANCE_ID, 0 AS AMTSO, 0 AS QTYORDERED, 0 AS QTYSALE, 0 AS QTYSALEOUT, B.QTY AS QTYRETSALE, B.QTYIN AS QTYRETSALEIN, B.PRICELIST, 0 AS AMTLISTSALE, 0 AS AMTLISTSALEOUT, B.TOT_AMT_LIST AS AMTLISTRETSALE, B.TOT_AMTIN_LIST AS AMTLISTRETSALEIN, B.PRICEACTUAL, 0 AS AMTSALE, 0 AS AMTSALEOUT, B.TOT_AMT_ACTUAL AS AMTRETSALE, B.TOT_AMTIN_ACTUAL AS AMTRETSALEIN, 0 AS DISCOUNTSALE, B.DISCOUNT AS DISCOUNTRETSALE, NULL AS OUTERID, A.INERID, B.M_PRODUCTALIAS_ID AS M_PRODUCT_ALIAS_ID, A.C_SALEDISTYPE_ID, :B8 , B.DESCRIPTION, NULL, A.PICKERID, A.C_RET_SALETYPE_ID FROM M_RET_SALE A, M_RET_SALEITEM B, TABLE(:B1 ) RSD, TABLE(:B2 ) RS, TABLE(:B3 ) RD, TABLE(:B4 ) RC, TABLE(:B5 ) RP WHERE A.ID = B.M_RET_SALE_ID AND A.C_SALEDISTYPE_ID = RSD.ID AND A.C_STORE_ID = RS.ID AND A.C_ORIG_ID = RD.ID AND A.C_CUSTOMER_ID = RC.ID AND B.M_PRODUCT_ID = RP.ID AND B.QTYOUT != 0 AND A.STATUS = 2 AND A.IN_STATUS = 2 AND A.DATEIN BETWEEN :B7 AND :B6

gfk81xzjhn0x8 MERGE INTO RP_DAILYBALANCE G USING (SELECT T.AD_CLIENT_ID, T.AD_ORG_ID, T.C_STORE_ID, T.M_PRODUCT_ID, T.M_ATTRIBUTESETINSTANCE_ID, T.M_PRODUCTALIAS_ID, SUM(T.QTYCHANGE) AS SUMQTY FROM TABLE(:B1 ) RS, FA_STORAGE_FTP T, TABLE(:B2 ) RP WHERE RS.ID = T.C_STORE_ID AND T.M_PRODUCT_ID = RP.ID AND T.CHANGEDATE > RS.BILLDATE AND T.CHANGEDATE < :B3 GROUP BY T.AD_CLIENT_ID, T.AD_ORG_ID, T.C_STORE_ID, T.M_PRODUCT_ID, T.M_ATTRIBUTESETINSTANCE_ID, T.M_PRODUCTALIAS_ID HAVING SUM(T.QTYCHANGE) <> 0) W ON (G.C_STORE_ID = W.C_STORE_ID AND G.M_PRODUCT_ID = W.M_PRODUCT_ID AND G.M_ATTRIBUTESETINSTANCE_ID = W.M_ATTRIBUTESETINSTANCE_ID AND G.AD_PI_ID = :B4 ) WHEN MATCHED THEN UPDATE SET G.QTYBEGIN = G.QTYBEGIN + W.SUMQTY WHEN NOT MATCHED THEN INSERT (G.ID, G.AD_CLIENT_ID, G.AD_ORG_ID, G.ISACTIVE, G.CREATIONDATE, G.MODIFIEDDATE, G.OWNERID, G.MODIFIERID, G.AD_PI_ID, G.C_STORE_ID, G.M_PRODUCT_ID, G.M_ATTRIBUTESETINSTANCE_ID, M_PRODUCT_ALIAS_ID, G.QTYBEGIN) VALUES (1, W.AD_CLIENT_ID, W.AD_ORG_ID, 'Y', SYSDATE, SYSDATE, :B5 , :B5 , :B4 , W.C_STORE_ID, W.M_PRODUCT_ID, W.M_ATTRIBUTESETINSTANCE_ID, W.M_PRODUCTALIAS_ID, W.SUMQTY)

SQL Id	SQL Text
09gnpt5k762zc	INSERT INTO RP_SALE001 (ID, AD_CLIENT_ID, SALEBILLTYPE, BILLDATE, DOCNO, DOCTYPE, B_SO_ID, C_CUSTOMERUP_ID, C_STORE_ID, C_CUSTOMER_ID, C_DEST_ID, DESCRIPTION, M_PRODUCT_ID, M_ATTRIBUTESETINSTANCE_ID, AMTSO, QTYORDERED, QTYSALE, QTYSALEOUT, QTYRETSALE, QTYRETSALEIN, PRICELIST, AMTLISTSALE, AMTLISTSALEOUT, AMTLISTRETSALE, AMTLISTRETSALEIN, PRICEACTUAL, AMTSALE, AMTSALEOUT, AMTRETSALE, AMTRETSALEIN, DISCOUNTSALE, DISCOUNTRETSALE, OUTERID, INERID, M_PRODUCT_ALIAS_ID, C_SALEDISTYPE_ID, AD_PI_ID, MXREMARK, C_SALETYPE_ID, PICKERID, C_RETSALETYPE_ID) SELECT 1, 37, A.SALEBILLTYPE, A.DATEOUT AS BILLDATE, A.DOCNO, A.DOCTYPE, A.B_SO_ID, A.C_CUSTOMERUP_ID, A.C_STORE_ID, A.C_CUSTOMER_ID, A.C_DEST_ID, A.DESCRIPTION, B.M_PRODUCT_ID, B.M_ATTRIBUTESETINSTANCE_ID, 0 AS AMTSO, 0 AS QTYORDERED, B.QTY AS QTYSALE, B.QTYOUT AS QTYSALEOUT, 0 AS QTYRETSALE, 0 AS QTYRETSALEIN, B.PRICELIST, B.TOT_AMT_LIST AS AMTLISTSALE, B.TOT_AMTOUT_LIST AS AMTLISTSALEOUT, 0 AS AMTLISTRETSALE, 0 AS AMTLISTRETSALEIN, B.PRICEACTUAL, B.TOT_AMT_ACTUAL AS AMTSALE, B.TOT_AMTOUT_ACTUAL AS AMTSALEOUT, 0 AS AMTRETSALE, 0 AS AMTRETSALEIN, B.DISCOUNT AS DISCOUNTSALE, 0 AS DISCOUNTRETSALE, A.OUTERID, NULL AS INERID, B.M_PRODUCTALIAS_ID AS M_PRODUCT_ALIAS_ID, A.C_SALEDISTYPE_ID, :B8 , B.DESCRIPTION, A.C_SALETYPE_ID, A.PICKERID, NULL FROM M_SALE A, M_SALEITEM B, M_PRODUCT_ALIAS N, TABLE(:B1 ) RSD, TABLE(:B2 ) RS, TABLE(:B3 ) RD, TABLE(:B4 ) RC, TABLE(:B5 ) RP WHERE A.ID = B.M_SALE_ID AND A.C_SALEDISTYPE_ID = RSD.ID AND A.C_STORE_ID = RS.ID AND A.C_DEST_ID = RD.ID AND A.C_CUSTOMER_ID = RC.ID AND B.M_PRODUCT_ID = RP.ID AND B.QTYOUT != 0 AND A.STATUS = 2 AND A.OUT_STATUS = 2 AND A.DATEOUT BETWEEN :B7 AND :B6 UNION ALL SELECT 1, 37, NULL AS SALEBILLTYPE, A.DATEIN AS BILLDATE, A.DOCNO, A.DOCTYPE, NULL AS B_SO_ID, A.C_CUSTOMERUP_ID, A.C_STORE_ID, A.C_CUSTOMER_ID, A.C_ORIG_ID AS C_DEST_ID, A.DESCRIPTION, B.M_PRODUCT_ID, B.M_ATTRIBUTESETINSTANCE_ID, 0 AS AMTSO, 0 AS QTYORDERED, 0 AS QTYSALE, 0 AS QTYSALEOUT, B.QTY AS QTYRETSALE, B.QTYIN AS QTYRETSALEIN, B.PRICELIST, 0 AS AMTLISTSALE, 0 AS AMTLISTSALEOUT, B.TOT_AMT_LIST AS AMTLISTRETSALE, B.TOT_AMTIN_LIST AS AMTLISTRETSALEIN, B.PRICEACTUAL, 0 AS AMTSALE, 0 AS AMTSALEOUT, B.TOT_AMT_ACTUAL AS AMTRETSALE, B.TOT_AMTIN_ACTUAL AS AMTRETSALEIN, 0 AS DISCOUNTSALE, B.DISCOUNT AS DISCOUNTRETSALE, NULL AS OUTERID, A.INERID, B.M_PRODUCTALIAS_ID AS M_PRODUCT_ALIAS_ID, A.C_SALEDISTYPE_ID, :B8 , B.DESCRIPTION, NULL, A.PICKERID, A.C_RET_SALETYPE_ID FROM M_RET_SALE A, M_RET_SALEITEM B, TABLE(:B1 ) RSD, TABLE(:B2 ) RS, TABLE(:B3 ) RD, TABLE(:B4 ) RC, TABLE(:B5 ) RP WHERE A.ID = B.M_RET_SALE_ID AND A.C_SALEDISTYPE_ID = RSD.ID AND A.C_STORE_ID = RS.ID AND A.C_ORIG_ID = RD.ID AND A.C_CUSTOMER_ID = RC.ID AND B.M_PRODUCT_ID = RP.ID AND B.QTYOUT != 0 AND A.STATUS = 2 AND A.IN_STATUS = 2 AND A.DATEIN BETWEEN :B7 AND :B6
gfk81xzjhn0x8	MERGE INTO RP_DAILYBALANCE G USING (SELECT T.AD_CLIENT_ID, T.AD_ORG_ID, T.C_STORE_ID, T.M_PRODUCT_ID, T.M_ATTRIBUTESETINSTANCE_ID, T.M_PRODUCTALIAS_ID, SUM(T.QTYCHANGE) AS SUMQTY FROM TABLE(:B1 ) RS, FA_STORAGE_FTP T, TABLE(:B2 ) RP WHERE RS.ID = T.C_STORE_ID AND T.M_PRODUCT_ID = RP.ID AND T.CHANGEDATE > RS.BILLDATE AND T.CHANGEDATE < :B3 GROUP BY T.AD_CLIENT_ID, T.AD_ORG_ID, T.C_STORE_ID, T.M_PRODUCT_ID, T.M_ATTRIBUTESETINSTANCE_ID, T.M_PRODUCTALIAS_ID HAVING SUM(T.QTYCHANGE) <> 0) W ON (G.C_STORE_ID = W.C_STORE_ID AND G.M_PRODUCT_ID = W.M_PRODUCT_ID AND G.M_ATTRIBUTESETINSTANCE_ID = W.M_ATTRIBUTESETINSTANCE_ID AND G.AD_PI_ID = :B4 ) WHEN MATCHED THEN UPDATE SET G.QTYBEGIN = G.QTYBEGIN + W.SUMQTY WHEN NOT MATCHED THEN INSERT (G.ID, G.AD_CLIENT_ID, G.AD_ORG_ID, G.ISACTIVE, G.CREATIONDATE, G.MODIFIEDDATE, G.OWNERID, G.MODIFIERID, G.AD_PI_ID, G.C_STORE_ID, G.M_PRODUCT_ID, G.M_ATTRIBUTESETINSTANCE_ID, M_PRODUCT_ALIAS_ID, G.QTYBEGIN) VALUES (1, W.AD_CLIENT_ID, W.AD_ORG_ID, 'Y', SYSDATE, SYSDATE, :B5 , :B5 , :B4 , W.C_STORE_ID, W.M_PRODUCT_ID, W.M_ATTRIBUTESETINSTANCE_ID, W.M_PRODUCTALIAS_ID, W.SUMQTY)

Top PL/SQL Procedures

'PL/SQL entry subprogram' represents the application's top-level entry-point(procedure, function, trigger, package initialization or RPC call) into PL/SQL.
'PL/SQL current subprogram' is the pl/sql subprogram being executed at the point of sampling . If the value is 'SQL', it represents the percentage of time spent executing SQL for the particular plsql entry subprogram

PLSQL Entry Subprogram	% Activity	PLSQL Current Subprogram	% Current
NEANDS3.RP_SALE001_GENERATE	66.75	SQL	66.73
NEANDS3.M_INVENTORY_AC	1.99	SQL	1.98
NEANDS3.RP_DAILYBALANCE_GENERATE	1.04	SQL	1.02

Top Java Workload

No data exists for this section of the report.

Top Call Types

Call Type	Count	% Activity	Avg Active Sessions
V8 Bundled Exec	45,725	80.53	12.70
FETCH	4,080	7.19	1.13

Top Sessions

Top Sessions
Top Blocking Sessions
Top Sessions running PQs

Top Sessions

'# 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
939,11543	5.53	CPU + Wait for CPU	2.78	NEANDS3	JDBC Thin Client	1,577/3,600 [ 44%]	1
939,11543	5.5284524207893763539336726606667958224	db file sequential read	2.74	NEANDS3	JDBC Thin Client	1,553/3,600 [ 43%]	1
1150,56477	5.36	db file sequential read	2.70	NEANDS3	JDBC Thin Client	1,533/3,600 [ 43%]	1
1150,56477	5.3628982546363972595501858081332887159	CPU + Wait for CPU	2.65	NEANDS3	JDBC Thin Client	1,502/3,600 [ 42%]	1
926,51899	5.17	db file sequential read	2.72	NEANDS3	JDBC Thin Client	1,542/3,600 [ 43%]	1
926,51899	5.1691646559467408725056799168706740168	CPU + Wait for CPU	2.43	NEANDS3	JDBC Thin Client	1,382/3,600 [ 38%]	1
4119, 309	4.99	db file sequential read	2.81	NEANDS3	JDBC Thin Client	1,593/3,600 [ 44%]	1
4119, 309	4.99304320259250779337431092481375156308	CPU + Wait for CPU	2.17	NEANDS3	JDBC Thin Client	1,233/3,600 [ 34%]	2
320, 183	4.95	db file sequential read	3.25	NEANDS3	JDBC Thin Client	1,846/3,600 [ 51%]	1
320, 183	4.95253526832103418517409605664065939872	CPU + Wait for CPU	1.70	NEANDS3	JDBC Thin Client	964/3,600 [ 27%]	4

Top Blocking Sessions

No data exists for this section of the report.

Top Sessions running PQs

No data exists for this section of the report.

Top Objects/Files/Latches

Top DB Objects
Top DB Files
Top Latches

Top DB Objects

With respect to Application, Cluster, User I/O and buffer busy waits only.

Object ID	% Activity	Event	% Event	Object Name (Type)	Tablespace
160379	1.43	db file parallel read	0.77	NEANDS3.FA_STORAGE_FTP (TABLE)	NEANDS
161122	1.18	db file sequential read	0.95	NEANDS3.M_INVENTORYITEM (TABLE)	NEANDS

Top DB Files

With respect to Cluster and User I/O events only.

File ID	% Activity	Event	% Event	File Name	Tablespace
3	10.78	db file sequential read	10.78	+ORADATA/portaldb/datafile/undotbs1.262.816976735	UNDOTBS1

Top Latches

No data exists for this section of the report.

Activity Over Time

Analysis period is divided into smaller time slots
Top 3 events are reported in each of those slots
'Slot Count' shows the number of ASH samples in that slot
'Event Count' shows the number of ASH samples waiting for that event in that slot
'% Event' is 'Event Count' over all ASH samples in the analysis period

Slot Time (Duration)	Slot Count	Event	Event Count	% Event
08:00:00 (0 secs)	1	CPU + Wait for CPU	1	0.00
08:00:00 (6.0 min)	244	CPU + Wait for CPU	227	0.40
08:00:00 (6.0 min)	244	Streams AQ: qmn coordinator waiting for slave to start	5	0.01
08:00:00 (6.0 min)	244	gc cr block 2-way	3	0.01
08:06:00 (6.0 min)	897	CPU + Wait for CPU	866	1.53
08:06:00 (6.0 min)	897	log file parallel write	9	0.02
08:06:00 (6.0 min)	897	db file parallel write	7	0.01
08:12:00 (6.0 min)	4,264	CPU + Wait for CPU	3,195	5.63
08:12:00 (6.0 min)	4264	db file parallel write	853	1.50
08:12:00 (6.0 min)	4264	log file parallel write	62	0.11
08:18:00 (6.0 min)	7,356	CPU + Wait for CPU	4,503	7.93
08:18:00 (6.0 min)	7356	db file parallel write	2,263	3.99
08:18:00 (6.0 min)	7356	db file sequential read	197	0.35
08:24:00 (6.0 min)	8,218	CPU + Wait for CPU	5,604	9.87
08:24:00 (6.0 min)	8218	db file sequential read	1,036	1.82
08:24:00 (6.0 min)	8218	db file parallel write	639	1.13
08:30:00 (6.0 min)	7,000	db file sequential read	4,076	7.18
08:30:00 (6.0 min)	7000	CPU + Wait for CPU	2,391	4.21
08:30:00 (6.0 min)	7000	gc current block busy	141	0.25
08:36:00 (6.0 min)	6,385	db file sequential read	3,938	6.94
08:36:00 (6.0 min)	6385	CPU + Wait for CPU	2,047	3.61
08:36:00 (6.0 min)	6385	gc current block busy	90	0.16
08:42:00 (6.0 min)	6,783	db file sequential read	3,720	6.55
08:42:00 (6.0 min)	6783	CPU + Wait for CPU	2,700	4.76
08:42:00 (6.0 min)	6783	db file parallel write	122	0.21
08:48:00 (6.0 min)	6,722	db file sequential read	3,697	6.51
08:48:00 (6.0 min)	6722	CPU + Wait for CPU	2,501	4.40
08:48:00 (6.0 min)	6722	gc buffer busy acquire	67	0.12
08:54:00 (6.0 min)	8,909	CPU + Wait for CPU	3,775	6.65
08:54:00 (6.0 min)	8909	db file sequential read	3,652	6.43
08:54:00 (6.0 min)	8909	db file parallel write	306	0.54

End of Report