ASH Report For ASM10G/asm10g1

DB Name DB Id Instance Inst num Release RAC Host

ASM10G 88190031 asm10g1 1 10.2.0.5.0 YES node1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ASM10G	88190031	asm10g1	1	10.2.0.5.0	YES	node1

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

4 3,072M (100%) 2,512M (81.8%) 512M (16.7%) 8.0M (0.3%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
4	3,072M (100%)	2,512M (81.8%)	512M (16.7%)	8.0M (0.3%)

Sample Time Data Source

Analysis Begin Time: 31-5月 -12 10:25:51 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 31-5月 -12 10:50:52 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 25.0 (mins)

Sample Count: 7,456

Average Active Sessions: 4.97

Avg. Active Session per CPU: 1.24

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	31-5月 -12 10:25:51	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	31-5月 -12 10:50:52	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	25.0 (mins)
Sample Count:	7,456
Average Active Sessions:	4.97
Avg. Active Session per CPU:	1.24
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
log file sync	Commit	46.08	2.29
db file sequential read	User I/O	6.99	0.35

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
log file parallel write	System I/O	19.90	0.99
CPU + Wait for CPU	CPU	17.48	0.87
gcs log flush sync	Other	3.02	0.15
control file sequential read	System I/O	2.58	0.13

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
log file sync	46.08	"23","1103173842","0"	0.01	buffer#	sync scn	NOT DEFINED
log file parallel write	19.90	"2","10","2"	3.53	files	blocks	requests
		"2","2","2"	1.92
		"2","14","2"	1.69
db file sequential read	6.99	"6","335098","1"	0.03	file#	block#	blocks
gcs log flush sync	3.02	"24","0","110"	3.02	waittime	poll	event
control file sequential read	2.60	"0","35","1"	1.46	file#	block#	blocks

Load Profile

Top Service/Module
Top Client IDs
Top SQL Command Types

Top Service/Module

Service	Module	% Activity	Action	% Action
asm10g	UNNAMED	55.91	UNNAMED	55.91
SYS$BACKGROUND	UNNAMED	44.07	UNNAMED	44.07

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	5	6.16	0.31
UPDATE	2	2.27	0.11
SELECT	5	1.54	0.08

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
86npw1qz2apqk	1082328868	3.46	db file sequential read	3.27	INSERT INTO UNIMAS_PERSON (XM,...
8j0rv03df7kv9	1082328868	2.19	db file sequential read	2.09	UPDATE UNIMAS_PERSON SET XM = ...
86npw1qz2apqk		1.57	db file sequential read	1.42	INSERT INTO UNIMAS_PERSON (XM,...
0ugz0mw317ap2	1677275186	1.42	gc current block busy	0.84	SELECT SEQ_五要素_人物.nextval FROM...

Top SQL using literals

No data exists for this section of the report.

Complete List of SQL Text

SQL Id SQL Text

0ugz0mw317ap2 SELECT SEQ_五要素_人物.nextval FROM dual

86npw1qz2apqk INSERT INTO UNIMAS_PERSON (XM, XB, MZ, XXLY, PID, CSNY, ZJLX, ZJHM, GJ, ZZ, ZP) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)

8j0rv03df7kv9 UPDATE UNIMAS_PERSON SET XM = :1 , XB = :2 , MZ = :3 , XXLY = :4 , CSNY = :5 , ZJLX = :6 , ZJHM = :7 , GJ = :8 , ZZ = :9 , ZP = :10 WHERE ZJLX = :11 AND ZJHM = :12

SQL Id	SQL Text
0ugz0mw317ap2	SELECT SEQ_五要素_人物.nextval FROM dual
86npw1qz2apqk	INSERT INTO UNIMAS_PERSON (XM, XB, MZ, XXLY, PID, CSNY, ZJLX, ZJHM, GJ, ZZ, ZP) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
8j0rv03df7kv9	UPDATE UNIMAS_PERSON SET XM = :1 , XB = :2 , MZ = :3 , XXLY = :4 , CSNY = :5 , ZJLX = :6 , ZJHM = :7 , GJ = :8 , ZZ = :9 , ZP = :10 WHERE ZJLX = :11 AND ZJHM = :12

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	XIDs
546, 1	20.10	log file parallel write	19.90	SYS	oracle@node1 (LGWR)	1,484/1,501 [ 99%]	0
471,56669	19.78	log file sync	19.26	POLICE		1,436/1,501 [ 96%]	1,216
493, 732	19.69	log file sync	19.26	POLICE		1,436/1,501 [ 96%]	590
547, 1	17.13	CPU + Wait for CPU	17.13	SYS	oracle@node1 (DBW0)	1,277/1,501 [ 85%]	0
503, 1239	11.90	db file sequential read	6.79	POLICE		506/1,501 [ 34%]	499
		log file sync	4.73			353/1,501 [ 24%]	55

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	% Activity	Event Caused	% Event	User	Program	# Samples Active	XIDs
546, 1	49.25	log file sync	46.08	SYS	oracle@node1 (LGWR)	1,499/1,501 [100%]	0
		gcs log flush sync	3.02

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

With respect to Application, Cluster, User I/O and buffer busy waits only.

Object ID	% Activity	Event	% Event	Object Name (Type)	Tablespace
52385	6.80	db file sequential read	6.68	POLICE.SYS_LOB0000052382C00011$$ (LOB)	PERSON

Top DB Files

With respect to Cluster and User I/O events only.

File ID	% Activity	Event	% Event	File Name	Tablespace
6	6.96	db file sequential read	6.85	+DATA/asm10g/datafile/person.272.778592983	PERSON

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
10:25:51 (1.2 min)	353	log file sync	160	2.15
		CPU + Wait for CPU	69	0.93
		log file parallel write	68	0.91
10:27:00 (3.0 min)	902	log file sync	394	5.28
		log file parallel write	178	2.39
		CPU + Wait for CPU	159	2.13
10:30:00 (3.0 min)	906	log file sync	429	5.75
		log file parallel write	180	2.41
		CPU + Wait for CPU	160	2.15
10:33:00 (3.0 min)	905	log file sync	417	5.59
		log file parallel write	177	2.37
		CPU + Wait for CPU	166	2.23
10:36:00 (3.0 min)	869	log file sync	407	5.46
		log file parallel write	177	2.37
		CPU + Wait for CPU	157	2.11
10:39:00 (3.0 min)	918	log file sync	422	5.66
		log file parallel write	179	2.40
		CPU + Wait for CPU	163	2.19
10:42:00 (3.0 min)	882	log file sync	417	5.59
		log file parallel write	178	2.39
		CPU + Wait for CPU	160	2.15
10:45:00 (3.0 min)	876	log file sync	400	5.36
		log file parallel write	176	2.36
		CPU + Wait for CPU	165	2.21
10:48:00 (2.9 min)	845	log file sync	390	5.23
		log file parallel write	171	2.29
		CPU + Wait for CPU	159	2.13

End of Report