ASH Report For ORCL/orcl

DB Name DB Id Instance Inst num Release RAC Host

ORCL 1437474305 orcl 1 11.2.0.4.0 NO CDMA-INMS-DB01

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORCL	1437474305	orcl	1	11.2.0.4.0	NO	CDMA-INMS-DB01

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

4 12,647M (100%) 3,904M (30.9%) 1,728M (13.7%) 8.0M (0.1%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
4	12,647M (100%)	3,904M (30.9%)	1,728M (13.7%)	8.0M (0.1%)

Sample Time Data Source

Analysis Begin Time: 10-Aug-16 16:16:44 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 10-Aug-16 16:31:49 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 15.1 (mins)

Sample Count: 757

Average Active Sessions: 0.84

Avg. Active Session per CPU: 0.21

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	10-Aug-16 16:16:44	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	10-Aug-16 16:31:49	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	15.1 (mins)
Sample Count:	757
Average Active Sessions:	0.84
Avg. Active Session per CPU:	0.21
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
CPU + Wait for CPU	CPU	97.09	0.81

Top Background Events

No data exists for this section of the report.

Top Event P1/P2/P3 Values

No data exists for this section of the report.

Load Profile

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

Top Service/Module

Service	Module	% Activity	Action	% Action
SYS$USERS	sqlplus@CDMA-INMS-DB01 (TNS V1-V3)	93.00	UNNAMED	93.00
orcl	PL/SQL Developer	3.70	SQL Window - New	2.51
orcl	PL/SQL Developer	3.69881109643328929986789960369881109643	Command Window - New	1.19
SYS$BACKGROUND	UNNAMED	1.98	UNNAMED	1.98
SYS$USERS	JDBC Thin Client	1.32	UNNAMED	1.32

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
SELECT	14	96.70	0.81

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution	% Activity	Avg Active Sessions
SQL Execution	96.96	0.81
PLSQL Execution	1.06	0.01

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
6y377cz3r7t39	4075299578	2	91.68	CPU + Wait for CPU	91.68	TABLE ACCESS - BY INDEX ROWID	61.03	select 1 from (select SYS_INT_...
ctsvd7vazxpx0	4075299578	1	2.51	CPU + Wait for CPU	2.51	TABLE ACCESS - BY INDEX ROWID	1.85	/*insert into zjdxlte.tmp_cm_d...
572fbaj0fdw2b	1648993636	1	1.06	CPU + Wait for CPU	0.92	SELECT STATEMENT	0.92	select output from table(dbms_...

Top SQL with Top Row Sources

SQL ID	PlanHash	Sampled # of Executions	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
6y377cz3r7t39	4075299578	2	91.68	TABLE ACCESS - BY INDEX ROWID	61.03	CPU + Wait for CPU	61.03	select 1 from (select SYS_INT_...
6y377cz3r7t39	4075299578	2	91.67767503302509907529722589167767503303	INDEX - RANGE SCAN	30.52	CPU + Wait for CPU	30.52
ctsvd7vazxpx0	4075299578	1	2.51	TABLE ACCESS - BY INDEX ROWID	1.85	CPU + Wait for CPU	1.85	/*insert into zjdxlte.tmp_cm_d...
572fbaj0fdw2b	1648993636	1	1.06	SELECT STATEMENT	0.92	CPU + Wait for CPU	0.92	select output from table(dbms_...

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

572fbaj0fdw2b select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))

6y377cz3r7t39 select 1 from (select SYS_INT_ID, NE_DN from zjdxlte.tmp_cm_disc_subnet_info where type_dn = 'SUBNETWORK' and view_name = 'OMC' and invoke_id = 20065) tmp, (select SM_COLLECTOR_DEPLOY.SYS_INT_ID "ID", SM_COLLECTOR_DEPLOY.NE_DN "KEY" from zjdxlte.SM_COLLECTOR_DEPLOY, zjdxlte.OBJECTS_EXS where (SM_COLLECTOR_DEPLOY.SYS_INT_ID = OBJECTS_EXS.SYS_INT_ID) and (SM_COLLECTOR_DEPLOY.NE_DN = OBJECTS_EXS.NE_DN) and OBJECTS_EXS.NE_CLASS = 6) "subnetwork", (select C_LTE_ANT_INFO.NE_DN "KEY", C_LTE_ANT_INFO.SYS_INT_ID "ID", C_LTE_ANT_INFO.SUBNET_ID "SUBNET_ID", C_LTE_ANT_INFO.NE_NAME "NAME" from zjdxlte.C_LTE_ANT_INFO, zjdxlte.OBJECTS_EXS where (C_LTE_ANT_INFO.SYS_INT_ID = OBJECTS_EXS.SYS_INT_ID) and (C_LTE_ANT_INFO.NE_DN = OBJECTS_EXS.NE_DN) and C_LTE_ANT_INFO.NE_CLASS = 355) "ant" where tmp.SYS_INT_ID = "subnetwork".ID and "subnetwork".ID = "ant".SUBNET_ID

ctsvd7vazxpx0 /*insert into zjdxlte.tmp_cm_disc_subnet_info (VIEW_NAME, LAYER, TYPE_DN, SYS_INT_ID, PARENT_INT_ID, OBJECT_NAME, NAME, NE_DN, INVOKE_ID, TASK_ID)*/ select 1 from (select SYS_INT_ID, NE_DN from zjdxlte.tmp_cm_disc_subnet_info where type_dn = 'SUBNETWORK' and view_name = 'OMC' and invoke_id = 20065) tmp, (select SM_COLLECTOR_DEPLOY.SYS_INT_ID "ID", SM_COLLECTOR_DEPLOY.NE_DN "KEY" from zjdxlte.SM_COLLECTOR_DEPLOY, zjdxlte.OBJECTS_EXS where (SM_COLLECTOR_DEPLOY.SYS_INT_ID = OBJECTS_EXS.SYS_INT_ID) and (SM_COLLECTOR_DEPLOY.NE_DN = OBJECTS_EXS.NE_DN) and OBJECTS_EXS.NE_CLASS = 6) "subnetwork", (select C_LTE_ANT_INFO.NE_DN "KEY", C_LTE_ANT_INFO.SYS_INT_ID "ID", C_LTE_ANT_INFO.SUBNET_ID "SUBNET_ID", C_LTE_ANT_INFO.NE_NAME "NAME" from zjdxlte.C_LTE_ANT_INFO, zjdxlte.OBJECTS_EXS where (C_LTE_ANT_INFO.SYS_INT_ID = OBJECTS_EXS.SYS_INT_ID) and (C_LTE_ANT_INFO.NE_DN = OBJECTS_EXS.NE_DN) and C_LTE_ANT_INFO.NE_CLA SS = 355) "ant" where tmp.SYS_INT_ID = "subnetwork".ID and "subnetwork".ID = "ant".SUBNET_ID

SQL Id	SQL Text
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
6y377cz3r7t39	select 1 from (select SYS_INT_ID, NE_DN from zjdxlte.tmp_cm_disc_subnet_info where type_dn = 'SUBNETWORK' and view_name = 'OMC' and invoke_id = 20065) tmp, (select SM_COLLECTOR_DEPLOY.SYS_INT_ID "ID", SM_COLLECTOR_DEPLOY.NE_DN "KEY" from zjdxlte.SM_COLLECTOR_DEPLOY, zjdxlte.OBJECTS_EXS where (SM_COLLECTOR_DEPLOY.SYS_INT_ID = OBJECTS_EXS.SYS_INT_ID) and (SM_COLLECTOR_DEPLOY.NE_DN = OBJECTS_EXS.NE_DN) and OBJECTS_EXS.NE_CLASS = 6) "subnetwork", (select C_LTE_ANT_INFO.NE_DN "KEY", C_LTE_ANT_INFO.SYS_INT_ID "ID", C_LTE_ANT_INFO.SUBNET_ID "SUBNET_ID", C_LTE_ANT_INFO.NE_NAME "NAME" from zjdxlte.C_LTE_ANT_INFO, zjdxlte.OBJECTS_EXS where (C_LTE_ANT_INFO.SYS_INT_ID = OBJECTS_EXS.SYS_INT_ID) and (C_LTE_ANT_INFO.NE_DN = OBJECTS_EXS.NE_DN) and C_LTE_ANT_INFO.NE_CLASS = 355) "ant" where tmp.SYS_INT_ID = "subnetwork".ID and "subnetwork".ID = "ant".SUBNET_ID
ctsvd7vazxpx0	/insert into zjdxlte.tmp_cm_disc_subnet_info (VIEW_NAME, LAYER, TYPE_DN, SYS_INT_ID, PARENT_INT_ID, OBJECT_NAME, NAME, NE_DN, INVOKE_ID, TASK_ID)/ select 1 from (select SYS_INT_ID, NE_DN from zjdxlte.tmp_cm_disc_subnet_info where type_dn = 'SUBNETWORK' and view_name = 'OMC' and invoke_id = 20065) tmp, (select SM_COLLECTOR_DEPLOY.SYS_INT_ID "ID", SM_COLLECTOR_DEPLOY.NE_DN "KEY" from zjdxlte.SM_COLLECTOR_DEPLOY, zjdxlte.OBJECTS_EXS where (SM_COLLECTOR_DEPLOY.SYS_INT_ID = OBJECTS_EXS.SYS_INT_ID) and (SM_COLLECTOR_DEPLOY.NE_DN = OBJECTS_EXS.NE_DN) and OBJECTS_EXS.NE_CLASS = 6) "subnetwork", (select C_LTE_ANT_INFO.NE_DN "KEY", C_LTE_ANT_INFO.SYS_INT_ID "ID", C_LTE_ANT_INFO.SUBNET_ID "SUBNET_ID", C_LTE_ANT_INFO.NE_NAME "NAME" from zjdxlte.C_LTE_ANT_INFO, zjdxlte.OBJECTS_EXS where (C_LTE_ANT_INFO.SYS_INT_ID = OBJECTS_EXS.SYS_INT_ID) and (C_LTE_ANT_INFO.NE_DN = OBJECTS_EXS.NE_DN) and C_LTE_ANT_INFO.NE_CLA SS = 355) "ant" where tmp.SYS_INT_ID = "subnetwork".ID and "subnetwork".ID = "ant".SUBNET_ID

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
SYS.DBMS_STATS.GATHER_TABLE_STATS	1.19	SQL	1.06
SYS.DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML	1.06	SYS.DBMS_SWRF_REPORT_INTERNAL.AWR_REPORT_MAIN	0.92

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	737	97.36	0.81

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
483,32621	91.68	CPU + Wait for CPU	91.68	SYS	sqlplus@CDMA-I...1 (TNS V1-V3)	694/905 [ 77%]
484,21449	2.51	CPU + Wait for CPU	2.51	SYS	plsqldev.exe	19/905 [ 2%]
256,38585	1.19	CPU + Wait for CPU	1.19	SYS	plsqldev.exe	9/905 [ 1%]
476,21693	1.19	CPU + Wait for CPU	1.06	SYS	sqlplus@CDMA-I...1 (TNS V1-V3)	8/905 [ 1%]

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

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
16:16:44 (1.3 min)	77	CPU + Wait for CPU	77	10.17
16:18:00 (2.0 min)	127	CPU + Wait for CPU	124	16.38
16:18:00 (2.0 min)	127	log file parallel write	1	0.13
16:18:00 (2.0 min)	127	log file sync	1	0.13
16:20:00 (2.0 min)	69	CPU + Wait for CPU	67	8.85
16:20:00 (2.0 min)	69	db file async I/O submit	2	0.26
16:22:00 (2.0 min)	28	CPU + Wait for CPU	28	3.70
16:24:00 (2.0 min)	89	CPU + Wait for CPU	89	11.76
16:26:00 (2.0 min)	121	CPU + Wait for CPU	120	15.85
16:26:00 (2.0 min)	121	db file async I/O submit	1	0.13
16:28:00 (2.0 min)	120	CPU + Wait for CPU	120	15.85
16:30:00 (1.8 min)	126	CPU + Wait for CPU	117	15.46
16:30:00 (1.8 min)	126	log file sync	5	0.66
16:30:00 (1.8 min)	126	log file parallel write	3	0.40

End of Report