ASH Report For DAILY/daily

DB Name DB Id Instance Inst num Release RAC Host

DAILY 3206806247 daily 1 11.2.0.4.0 NO volteyy3

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
DAILY	3206806247	daily	1	11.2.0.4.0	NO	volteyy3

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

40 50,971M (100%) 41,856M (82.1%) 6,144M (12.1%) 80.0M (0.2%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
40	50,971M (100%)	41,856M (82.1%)	6,144M (12.1%)	80.0M (0.2%)

Sample Time Data Source

Analysis Begin Time: 18-Sep-16 13:00:56 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 18-Sep-16 14:00:56 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 60.0 (mins)

Sample Count: 15,414

Average Active Sessions: 4.28

Avg. Active Session per CPU: 0.11

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	18-Sep-16 13:00:56	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	18-Sep-16 14:00:56	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	60.0 (mins)
Sample Count:	15,414
Average Active Sessions:	4.28
Avg. Active Session per CPU:	0.11
Report Target:	None specified

Top Events

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

Top User Events

Event	Event Class	% Event	Avg Active Sessions
buffer busy waits	Concurrency	28.95	1.24
enq: HW - contention	Configuration	27.15	1.16
CPU + Wait for CPU	CPU	17.91	0.77
Disk file operations I/O	User I/O	3.81	0.16
direct path write	User I/O	3.42	0.15

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
db file parallel write	System I/O	9.05	0.39
db file async I/O submit	System I/O	1.02	0.04

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
buffer busy waits	28.95	"9","2","13"	2.32	file#	block#	class#
buffer busy waits	28.94770987414039185156351368885428830933	"8","2","13"	2.26	file#	block#	class#
buffer busy waits	28.94770987414039185156351368885428830933	"7","2","13"	2.23	file#	block#	class#
enq: HW - contention	27.15	"1213661190","20","713087113"	26.43	name\|mode	table space #	block
db file parallel write	9.05	"1","0","2147483647"	9.05	requests	interrupt	timeout
Disk file operations I/O	3.81	"2","9","2"	0.95	FileOperation	fileno	filetype
direct path write	3.42	"7","716537995","1"	0.01	file number	first dba	block cnt

Load Profile

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

Top Service/Module

Service	Module	% Activity	Action	% Action
daily	SQL Loader Direct Path Load	85.66	low_201609181123.0.505173.ctrl	0.04
SYS$BACKGROUND	UNNAMED	11.72	UNNAMED	11.72
daily	sqlldr@volteyy3 (TNS V1-V3)	1.21	UNNAMED	1.21

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	101	78.34	3.35
SELECT	30	5.27	0.23

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution	% Activity	Avg Active Sessions
SQL Execution	27.25	1.17
Connection Management	1.57	0.07
Parse	1.04	0.04

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	% Activity	Event	% Event	Top Row Source	% RwSrc	SQL Text
cn8jf0n1v095v	36.96	enq: HW - contention	26.43	Row Source Not Available	26.43	INSERT /+ SYS_DL_CURSOR / IN...
cn8jf0n1v095v	36.96	CPU + Wait for CPU	4.48	Row Source Not Available	4.48	INSERT /+ SYS_DL_CURSOR / IN...
cn8jf0n1v095v	36.96	buffer busy waits	3.94	Row Source Not Available	3.94	INSERT /+ SYS_DL_CURSOR / IN...
gcgy3asb63thd	12.42	buffer busy waits	6.97	Row Source Not Available	6.97	INSERT /+ SYS_DL_CURSOR / IN...
gcgy3asb63thd	12.42	CPU + Wait for CPU	2.19	Row Source Not Available	2.19	INSERT /+ SYS_DL_CURSOR / IN...
5cnsr7jg6v4w4	3.72	buffer busy waits	2.47	Row Source Not Available	2.47	INSERT /+ SYS_DL_CURSOR / IN...
1dqanhpdrhbb5	2.67	buffer busy waits	1.52	Row Source Not Available	1.52	INSERT /+ SYS_DL_CURSOR / IN...
3au5fdmfz9qhg	2.00	buffer busy waits	1.10	Row Source Not Available	1.10	INSERT /+ SYS_DL_CURSOR / IN...

Top SQL with Top Row Sources

SQL ID	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
cn8jf0n1v095v	36.96	Row Source Not Available	36.96	enq: HW - contention	26.43	INSERT /+ SYS_DL_CURSOR / IN...
gcgy3asb63thd	12.42	Row Source Not Available	12.42	buffer busy waits	6.97	INSERT /+ SYS_DL_CURSOR / IN...
5cnsr7jg6v4w4	3.72	Row Source Not Available	3.72	buffer busy waits	2.47	INSERT /+ SYS_DL_CURSOR / IN...
1dqanhpdrhbb5	2.67	Row Source Not Available	2.67	buffer busy waits	1.52	INSERT /+ SYS_DL_CURSOR / IN...
3au5fdmfz9qhg	2.00	Row Source Not Available	2.00	buffer busy waits	1.10	INSERT /+ SYS_DL_CURSOR / IN...

Top SQL using literals

No data exists for this section of the report.

Top Parsing Module/Action

No data exists for this section of the report.

Complete List of SQL Text

SQL Id SQL Text

1dqanhpdrhbb5 INSERT /*+ SYS_DL_CURSOR */ INTO "DAILY"."MGSIPCTRL_2016091811" ("XDRID", "MS_IMEI", "IMSI", "MSISDN", "CI", "TS", "DIR", "TS_ID", "ENB_IP", "SGW_IP", "SIP", "SPN", "DIP", "DPN", "CALL_ID", "COMMAND", "STATUS", "SEQ", "CAUSE_NUM", "SENDRECV", "SIP_FROM", "SIP_TO") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

3au5fdmfz9qhg INSERT /*+ SYS_DL_CURSOR */ INTO "DAILY"."GXCMCCXDR_2016091811" ("LENGTH", "CITY", "INTERFACE", "XDRID", "RAT", "IMSI", "IMEI", "MSISDN", "PROCEDURETYPE", "TSSTART", "TSEND", "ICID", "SNEIP", "SNEPORT", "DNEIP", "DNEPORT", "PCRF_ID", "GGSN_PGW_ID", "SGSN_SGW_SIG_IP", "GGSN_PGW_SIG_IP", "AF_ID", "AF_APP_ID", "CC_REQUEST_TYPE", "RX_REQUEST_TYPE", "TRANS_TYPE", "TRANS_REQ_TIME_SEC", "TRANS_REQ_TIME_MSEC", "TRANS_RSP_TIME_SEC", "TRANS_RSP_TIME_MSEC", "ABORT_CAUSE", "MEDIA_TYPE", "RESULT_CODE", "EXPERIMENTAL_RESULT_CODE", "SESSION_RELEASE_CAUSE") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

5cnsr7jg6v4w4 INSERT /*+ SYS_DL_CURSOR */ INTO "DAILY"."MWSIPCTRL_2016091811" ("XDRID", "MS_IMEI", "IMSI", "MSISDN", "CI", "TS", "DIR", "TS_ID", "ENB_IP", "SGW_IP", "SIP", "SPN", "DIP", "DPN", "CALL_ID", "COMMAND", "STATUS", "SEQ", "CAUSE_NUM", "SENDRECV", "SIP_FROM", "SIP_TO") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

cn8jf0n1v095v INSERT /*+ SYS_DL_CURSOR */ INTO "DAILY"."GXFLOW_2016091811" ("XDRID", "IMSI", "MSISDN", "PCEF_IP", "PCRF_IP", "PCEF_PORT", "PCRF_PORT", "TS_START", "TS_END", "PROCEDURE_TYPE", "STATUS", "APPLICATION_ID", "RESULT_CODE", "ORIGIN_HOST", "ORIGIN_REALM", "DESTINATION_HOST", "DESTINATION_REALM", "CHARGING_ADDRESS", "REQUEST_TYPE", "LDRA_U_IP", "LDRA_D_IP", "SESSION_ID", "RAT_TYPE", "CI") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

gcgy3asb63thd INSERT /*+ SYS_DL_CURSOR */ INTO "DAILY"."ISCSIPCTRL_2016091811" ("XDRID", "MS_IMEI", "IMSI", "MSISDN", "CI", "TS", "DIR", "TS_ID", "ENB_IP", "SGW_IP", "SIP", "SPN", "DIP", "DPN", "CALL_ID", "COMMAND", "STATUS", "SEQ", "CAUSE_NUM", "SENDRECV", "SIP_FROM", "SIP_TO") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

SQL Id	SQL Text
1dqanhpdrhbb5	INSERT /+ SYS_DL_CURSOR / INTO "DAILY"."MGSIPCTRL_2016091811" ("XDRID", "MS_IMEI", "IMSI", "MSISDN", "CI", "TS", "DIR", "TS_ID", "ENB_IP", "SGW_IP", "SIP", "SPN", "DIP", "DPN", "CALL_ID", "COMMAND", "STATUS", "SEQ", "CAUSE_NUM", "SENDRECV", "SIP_FROM", "SIP_TO") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
3au5fdmfz9qhg	INSERT /+ SYS_DL_CURSOR / INTO "DAILY"."GXCMCCXDR_2016091811" ("LENGTH", "CITY", "INTERFACE", "XDRID", "RAT", "IMSI", "IMEI", "MSISDN", "PROCEDURETYPE", "TSSTART", "TSEND", "ICID", "SNEIP", "SNEPORT", "DNEIP", "DNEPORT", "PCRF_ID", "GGSN_PGW_ID", "SGSN_SGW_SIG_IP", "GGSN_PGW_SIG_IP", "AF_ID", "AF_APP_ID", "CC_REQUEST_TYPE", "RX_REQUEST_TYPE", "TRANS_TYPE", "TRANS_REQ_TIME_SEC", "TRANS_REQ_TIME_MSEC", "TRANS_RSP_TIME_SEC", "TRANS_RSP_TIME_MSEC", "ABORT_CAUSE", "MEDIA_TYPE", "RESULT_CODE", "EXPERIMENTAL_RESULT_CODE", "SESSION_RELEASE_CAUSE") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
5cnsr7jg6v4w4	INSERT /+ SYS_DL_CURSOR / INTO "DAILY"."MWSIPCTRL_2016091811" ("XDRID", "MS_IMEI", "IMSI", "MSISDN", "CI", "TS", "DIR", "TS_ID", "ENB_IP", "SGW_IP", "SIP", "SPN", "DIP", "DPN", "CALL_ID", "COMMAND", "STATUS", "SEQ", "CAUSE_NUM", "SENDRECV", "SIP_FROM", "SIP_TO") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
cn8jf0n1v095v	INSERT /+ SYS_DL_CURSOR / INTO "DAILY"."GXFLOW_2016091811" ("XDRID", "IMSI", "MSISDN", "PCEF_IP", "PCRF_IP", "PCEF_PORT", "PCRF_PORT", "TS_START", "TS_END", "PROCEDURE_TYPE", "STATUS", "APPLICATION_ID", "RESULT_CODE", "ORIGIN_HOST", "ORIGIN_REALM", "DESTINATION_HOST", "DESTINATION_REALM", "CHARGING_ADDRESS", "REQUEST_TYPE", "LDRA_U_IP", "LDRA_D_IP", "SESSION_ID", "RAT_TYPE", "CI") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
gcgy3asb63thd	INSERT /+ SYS_DL_CURSOR / INTO "DAILY"."ISCSIPCTRL_2016091811" ("XDRID", "MS_IMEI", "IMSI", "MSISDN", "CI", "TS", "DIR", "TS_ID", "ENB_IP", "SGW_IP", "SIP", "SPN", "DIP", "DPN", "CALL_ID", "COMMAND", "STATUS", "SEQ", "CAUSE_NUM", "SENDRECV", "SIP_FROM", "SIP_TO") VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

Top PL/SQL Procedures

No data exists for this section of the report.

Top Java Workload

No data exists for this section of the report.

Top Call Types

Call Type	Count	% Activity	Avg Active Sessions
DirPathMiscOps	5,814	37.72	1.62
DirPathPrepare	4,700	30.49	1.31
DirPathLoadStream	1,898	12.31	0.53
V8 Bundled Exec	785	5.09	0.22
OAUTH	216	1.40	0.06

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
571, 1	4.15	db file parallel write	3.54	SYS	oracle@volteyy3 (DBW0)	545/3,600 [ 15%]
685, 1	2.95	db file parallel write	2.58	SYS	oracle@volteyy3 (DBW2)	398/3,600 [ 11%]
742, 1	1.70	db file parallel write	1.50	SYS	oracle@volteyy3 (DBW3)	231/3,600 [ 6%]
799, 1	1.28	db file parallel write	1.17	SYS	oracle@volteyy3 (DBW4)	180/3,600 [ 5%]

Top Blocking Sessions

Blocking session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only
'% Activity' represents the load on the database caused by a particular blocking session
'# Samples Active' shows the number of ASH samples in which the blocking session was found active.
'XIDs' shows the number of distinct transaction IDs sampled in ASH when the blocking session was found active.

Blocking Sid (Inst)	% Activity	Event Caused	% Event	User	Program	# Samples Active	XIDs
856, 1( 1)	2.91	log file sync	2.91	SYS	oracle@volteyy3 (LGWR)	151/3,600 [ 4%]	0

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

No data exists for this section of the report.

Top DB Files

No data exists for this section of the report.

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
13:00:56 (5.1 min)	1,101	buffer busy waits	422	2.74
13:00:56 (5.1 min)	1101	enq: HW - contention	266	1.73
13:00:56 (5.1 min)	1101	CPU + Wait for CPU	226	1.47
13:06:00 (6.0 min)	1,293	enq: HW - contention	339	2.20
13:06:00 (6.0 min)	1293	buffer busy waits	328	2.13
13:06:00 (6.0 min)	1293	CPU + Wait for CPU	233	1.51
13:12:00 (6.0 min)	1,526	enq: HW - contention	510	3.31
13:12:00 (6.0 min)	1526	buffer busy waits	457	2.96
13:12:00 (6.0 min)	1526	CPU + Wait for CPU	248	1.61
13:18:00 (6.0 min)	2,098	enq: HW - contention	800	5.19
13:18:00 (6.0 min)	2098	buffer busy waits	559	3.63
13:18:00 (6.0 min)	2098	CPU + Wait for CPU	269	1.75
13:24:00 (6.0 min)	1,706	enq: HW - contention	697	4.52
13:24:00 (6.0 min)	1706	buffer busy waits	354	2.30
13:24:00 (6.0 min)	1706	CPU + Wait for CPU	275	1.78
13:30:00 (6.0 min)	1,671	enq: HW - contention	579	3.76
13:30:00 (6.0 min)	1671	buffer busy waits	561	3.64
13:30:00 (6.0 min)	1671	CPU + Wait for CPU	292	1.89
13:36:00 (6.0 min)	1,576	enq: HW - contention	381	2.47
13:36:00 (6.0 min)	1576	buffer busy waits	375	2.43
13:36:00 (6.0 min)	1576	CPU + Wait for CPU	276	1.79
13:42:00 (6.0 min)	1,581	buffer busy waits	410	2.66
13:42:00 (6.0 min)	1581	enq: HW - contention	396	2.57
13:42:00 (6.0 min)	1581	CPU + Wait for CPU	292	1.89
13:48:00 (6.0 min)	1,476	buffer busy waits	558	3.62
13:48:00 (6.0 min)	1476	CPU + Wait for CPU	337	2.19
13:48:00 (6.0 min)	1476	enq: HW - contention	143	0.93
13:54:00 (6.0 min)	1,252	buffer busy waits	397	2.58
13:54:00 (6.0 min)	1252	CPU + Wait for CPU	367	2.38
13:54:00 (6.0 min)	1252	db file parallel write	109	0.71
14:00:00 (56 secs)	134	CPU + Wait for CPU	49	0.32
14:00:00 (56 secs)	134	buffer busy waits	41	0.27
14:00:00 (56 secs)	134	Disk file operations I/O	10	0.06

End of Report