ASH Report For SKINSTG/SKINSTG1

DB Name DB Id Instance Inst num Release RAC Host

SKINSTG 1860772457 SKINSTG1 1 10.2.0.4.0 YES stage-rac01

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
SKINSTG	1860772457	SKINSTG1	1	10.2.0.4.0	YES	stage-rac01

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

4 1,536M (100%) 848M (55.2%) 560M (36.5%) 8.0M (0.5%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
4	1,536M (100%)	848M (55.2%)	560M (36.5%)	8.0M (0.5%)

Sample Time Data Source

Analysis Begin Time: 28-Mar-11 08:32:23 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 28-Mar-11 08:37:23 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 5.0 (mins)

Sample Count: 20

Average Active Sessions: 0.07

Avg. Active Session per CPU: 0.02

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	28-Mar-11 08:32:23	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	28-Mar-11 08:37:23	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	5.0 (mins)
Sample Count:	20
Average Active Sessions:	0.07
Avg. Active Session per CPU:	0.02
Report Target:	None specified

Top Events

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

Top User Events

Event	Event Class	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	15.00	0.01
row cache lock	Concurrency	5.00	0.00

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
control file sequential read	System I/O	30.00	0.02
Streams AQ: qmn coordinator waiting for slave to start	Other	25.00	0.02
reliable message	Other	15.00	0.01
control file parallel write	System I/O	10.00	0.01

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
control file sequential read	30.00	"0","35","1"	15.00	file#	block#	blocks
		"0","1","1"	5.00
		"0","4","1"	5.00
reliable message	15.00	"2264808368","4753080968","2216370336"	15.00	channel context	channel handle	broadcast message
control file parallel write	10.00	"3","3","3"	10.00	files	block#	requests
row cache lock	5.00	"8","0","3"	5.00	cache id	mode	request

Load Profile

Top Service/Module
Top Client IDs
Top SQL Command Types

Top Service/Module

Service	Module	% Activity	Action	% Action
SYS$BACKGROUND	UNNAMED	80.00	UNNAMED	80.00
SYS$USERS	OEM	20.00	UNNAMED	20.00

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	2	20.00	0.01

Back to Load Profile
Back to Top

Top SQL

Top SQL Statements
Top SQL using literals
Complete List of SQL Text

Top SQL Statements

SQL ID	Planhash	% Activity	Event	% Event	SQL Text
4gd6b1r53yt88		15.00	reliable message	15.00	SQL Text Not Available
b058ymxj1rvkg	903671040	15.00	CPU + Wait for CPU	15.00	SELECT sql_id, sql_text from v...
5k69yxwhk0211	3125220660	5.00	row cache lock	5.00	SELECT name, owner, descript...

Top SQL using literals

No data exists for this section of the report.

Complete List of SQL Text

SQL Id SQL Text

4gd6b1r53yt88 ** SQL Text Not Available **

5k69yxwhk0211 SELECT name, owner, description, created, last_modified, id from dba_sqlset_definitions

b058ymxj1rvkg SELECT sql_id, sql_text from v$sql WHERE sql_id in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)

SQL Id	SQL Text
4gd6b1r53yt88	SQL Text Not Available
5k69yxwhk0211	SELECT name, owner, description, created, last_modified, id from dba_sqlset_definitions
b058ymxj1rvkg	SELECT sql_id, sql_text from v$sql WHERE sql_id in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)

Top PL/SQL Procedures

No data exists for this section of the report.

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
532, 9	25.00	Streams AQ: qmn coordinator waiting for slave to start	25.00	SYS	oracle@stage-rac01 (QMNC)	5/300 [ 2%]
515,44209	20.00	CPU + Wait for CPU	15.00	SYSTEM	OMS	3/300 [ 1%]
		row cache lock	5.00			1/300 [ 0%]
550, 1	20.00	control file sequential read	20.00	SYS	oracle@stage-rac01 (LMON)	4/300 [ 1%]
540, 1	15.00	reliable message	15.00	SYS	oracle@stage-rac01 (MMON)	3/300 [ 1%]
544, 1	10.00	control file parallel write	10.00	SYS	oracle@stage-rac01 (CKPT)	2/300 [ 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
08:32:23 (37 secs)	1	control file sequential read	1	5.00
08:33:00 (1.0 min)	2	control file parallel write	1	5.00
		row cache lock	1	5.00
08:34:00 (1.0 min)	1	control file sequential read	1	5.00
08:35:00 (1.0 min)	3	control file sequential read	2	10.00
		control file parallel write	1	5.00
08:36:00 (1.0 min)	12	Streams AQ: qmn coordinator waiting for slave to start	5	25.00
		reliable message	3	15.00
		CPU + Wait for CPU	2	10.00
08:37:00 (23 secs)	1	CPU + Wait for CPU	1	5.00

End of Report