ASH Report For OCM11G/ocm11g

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
OCM11G	3370287304	ocm11g	1	11.1.0.6.0	NO	bankstown.yaocm.id.au

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
1	307M (100%)	104M (33.8%)	144M (46.9%)	2.0M (0.7%)

	Sample Time	Data Source
Analysis Begin Time:	27-Jan-12 03:10:59	DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 96
Analysis End Time:	27-Jan-12 03:50:59	DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 96
Elapsed Time:	40.0 (mins)
Sample Count:	844
Average Active Sessions:	3.52
Avg. Active Session per CPU:	3.52
Report Target:	None specified

ASH Report

Top Events

Top User Events

Event	Event Class	% Event	Avg Active Sessions
resmgr:cpu quantum	Scheduler	99.05	3.48

Top Background 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
resmgr:cpu quantum	99.05	"2","0","0"	57.82	location
		"1","0","0"	24.88
		"3","0","0"	16.35

Load Profile

Top Service/Module

Service	Module	% Activity	Action	% Action
SYS$USERS	emagent_SQL_oracle_database	29.15	service	10.19
			streams_processes_count	10.19
			ha_flashrecovery	8.53
	perl@bankstown.yaocm.id.au (TNS V1-V3)	18.25	UNNAMED	18.25
	emagent@bankstown.yaocm.id.au (TNS V1-V3)	17.77	UNNAMED	17.77
	emagent_AQMetrics	10.31	DEQ	10.31
	UNNAMED	9.83	UNNAMED	9.83

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	3	8.77	0.31
PL/SQL EXECUTE	1	5.81	0.20

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution	% Activity	Avg Active Sessions
Connection Management	27.49	0.97
SQL Execution	16.59	0.58

Back to Load Profile
Back to Top

Top SQL

Top SQL with Top Events

SQL ID	Planhash	Sampled # of Executions	% Activity	Event	% Event	Top Row Source	% RwSrc	SQL Text
22zy9092puhcu	1128103955	1	8.53	resmgr:cpu quantum	8.53	FIXED TABLE - FULL	8.53	SELECT VALUE FROM V$PARAMETER ...
0rz2zzy1qw5x3		1	5.81	resmgr:cpu quantum	5.81	Row Source Not Available	5.81	BEGIN DBMS_RESOURCE_MANAGER....

Top SQL with Top Row Sources

SQL ID	PlanHash	Sampled # of Executions	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
22zy9092puhcu	1128103955	1	8.53	FIXED TABLE - FULL	8.53	resmgr:cpu quantum	8.53	SELECT VALUE FROM V$PARAMETER ...
0rz2zzy1qw5x3		1	5.81	Row Source Not Available	5.81	resmgr:cpu quantum	5.81	BEGIN DBMS_RESOURCE_MANAGER....

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
0rz2zzy1qw5x3	BEGIN DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA; DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE ( plan => 'MIXED_WORKLOAD_PLAN', group_or_subplan => 'INTERACTIVE_GROUP', new_switch_time => 5, new_switch_group => 'KILL_SESSION'); DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA; DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA; END;
22zy9092puhcu	SELECT VALUE FROM V$PARAMETER WHERE NAME='db_recovery_file_dest'

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_RESOURCE_MANAGER.VALIDATE_PENDING_AREA	5.81	SYS.DBMS_RMIN.RM$_VLDPAREA	5.81

Top Java Workload

No data exists for this section of the report.

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
153, 8	10.43	resmgr:cpu quantum	10.19	DBSNMP	emagent@bankst...u (TNS V1-V3)	86/240 [ 36%]
127, 45	10.31	resmgr:cpu quantum	10.31	DBSNMP	emagent@bankst...u (TNS V1-V3)	87/240 [ 36%]
137, 6601	10.31	resmgr:cpu quantum	10.31	DBSNMP	perl@bankstown...u (TNS V1-V3)	87/240 [ 36%]
126, 189	10.19	resmgr:cpu quantum	10.19	DBSNMP	emagent@bankst...u (TNS V1-V3)	86/240 [ 36%]
170, 1348	9.24	resmgr:cpu quantum	9.24	DBSNMP	emagent@bankst...u (TNS V1-V3)	78/240 [ 33%]

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

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
03:10:59 (4.0 min)	1	db file sequential read	1	0.12
03:15:00 (5.0 min)	5	control file sequential read	3	0.36
		log file parallel write	1	0.12
		log file sync	1	0.12
03:20:00 (5.0 min)	1	db file sequential read	1	0.12
03:25:00 (5.0 min)	1	log file parallel write	1	0.12
03:35:00 (5.0 min)	120	resmgr:cpu quantum	120	14.22
03:40:00 (5.0 min)	303	resmgr:cpu quantum	303	35.90
03:45:00 (5.0 min)	341	resmgr:cpu quantum	341	40.40
03:50:00 (59 secs)	72	resmgr:cpu quantum	72	8.53

End of Report