ASH Report For DB122/db122

DB Name DB Id Instance Inst num Release RAC Host

DB122 872342268 db122 1 12.2.0.1.0 NO XPS13

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
DB122	872342268	db122	1	12.2.0.1.0	NO	XPS13

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size In-memory Area Size

4 6,144M (100%) 4,704M (76.6%) 1,008M (16.4%) 8.0M (0.1%) 0.0M (0.0%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size	In-memory Area Size
4	6,144M (100%)	4,704M (76.6%)	1,008M (16.4%)	8.0M (0.1%)	0.0M (0.0%)

Sample Time Data Source

Analysis Begin Time: 02-Feb-18 09:23:02 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 02-Feb-18 09:26:03 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 3.0 (mins)

Sample Count: 170

Average Active Sessions: 0.94

Avg. Active Session per CPU: 0.23

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	02-Feb-18 09:23:02	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	02-Feb-18 09:26:03	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	3.0 (mins)
Sample Count:	170
Average Active Sessions:	0.94
Avg. Active Session per CPU:	0.23
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	93.53	0.88

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	5.29	0.05

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	SQL*Plus	93.53	UNNAMED	93.53
SYS$BACKGROUND	UNNAMED	5.88	UNNAMED	5.88

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	13	93.53	0.88

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution	% Activity	Avg Active Sessions
SQL Execution	93.53	0.88
Hard Parse	6.47	0.06
Parse	6.47	0.06

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	FullPlanhash	Planhash	Sampled # of Executions	% Activity	Event	% Event	Top Row Source	% RwSrc	SQL Text
8zzafn2w3dbm1	3070635601	836244420	1	86.47	CPU + Wait for CPU	86.47	SORT - JOIN	86.47	select count(*) from xxtst, y ...

Top SQL with Top Row Sources

SQL ID	FullPlanHash	PlanHash	Sampled # of Executions	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
8zzafn2w3dbm1	3070635601	836244420	1	86.47	SORT - JOIN	86.47	CPU + Wait for CPU	86.47	select count(*) from xxtst, y ...

Top SQL using literals

FORCE_MATCHING_SIGNATURE is used to identify SQL statements that are identical except for their use of literals.
Please refer to the Oracle Database Reference to understand how the FORCE_MATCHING_SIGNATURE is derived.

FORCE_MATCHING_SIGNATURE	% Activity	# of Sampled SQL Versions	Example SQL 1	Example SQL TEXT 1	Example SQL 2	Example SQL TEXT 2
2659510243639665732	6.47	11

Top Parsing Module/Action

Module	Action	% Activity	Event	% Event
SQL*Plus		6.47	CPU + Wait for CPU	6.47

Complete List of SQL Text

SQL Id SQL Text

8zzafn2w3dbm1 select count(*) from xxtst, y where i < y_id

SQL Id	SQL Text
8zzafn2w3dbm1	select count(*) from xxtst, y where i < y_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_WORKLOAD_REPOSITORY.ASH_REPORT_TEXT	6.47	SQL	6.47

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	148	87.06	0.82
LOB/FILE operations	12	7.06	0.07

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
275, 6107	86.47	CPU + Wait for CPU	86.47	MCDONAC	sqlplus.exe	147/181 [ 81%]
25,35750	6.47	CPU + Wait for CPU	6.47	MCDONAC	sqlplus.exe	11/181 [ 6%]
255,41505	2.35	CPU + Wait for CPU	2.35	SYS	ORACLE.EXE (GEN0)	4/181 [ 2%]
1,51057	1.18	CPU + Wait for CPU	1.18	SYS	ORACLE.EXE (PSP0)	2/181 [ 1%]
382, 7806	1.18	CPU + Wait for CPU	1.18	SYS	ORACLE.EXE (DBRM)	2/181 [ 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
09:23:02 (58 secs)	32	CPU + Wait for CPU	31	18.24
09:23:02 (58 secs)	32	control file sequential read	1	0.59
09:24:00 (1.0 min)	74	CPU + Wait for CPU	73	42.94
09:24:00 (1.0 min)	74	oracle thread bootstrap	1	0.59
09:25:00 (1.0 min)	61	CPU + Wait for CPU	61	35.88
09:26:00 (3 secs)	3	CPU + Wait for CPU	3	1.76

End of Report