ASH Report For GPSRAC/gpsrac1

DB Name DB Id Instance Inst num Release RAC Host

GPSRAC 88403155 gpsrac1 1 10.2.0.5.0 YES dwptdb1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
GPSRAC	88403155	gpsrac1	1	10.2.0.5.0	YES	dwptdb1

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

16 8,000M (100%) 5,936M (74.2%) 2,058M (25.7%) 29.0M (0.4%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
16	8,000M (100%)	5,936M (74.2%)	2,058M (25.7%)	29.0M (0.4%)

Sample Time Data Source

Analysis Begin Time: 30-Dec-13 13:31:22 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 30-Dec-13 13:56:23 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 25.0 (mins)

Sample Count: 4,099

Average Active Sessions: 2.73

Avg. Active Session per CPU: 0.17

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	30-Dec-13 13:31:22	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	30-Dec-13 13:56:23	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	25.0 (mins)
Sample Count:	4,099
Average Active Sessions:	2.73
Avg. Active Session per CPU:	0.17
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	65.87	1.80
db file sequential read	User I/O	7.05	0.19
library cache lock	Concurrency	5.03	0.14
log file sync	Commit	2.71	0.07

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	9.81	0.27
log file parallel write	System I/O	4.24	0.12
wait for scn ack	Other	1.29	0.04
control file sequential read	System I/O	1.07	0.03

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
db file sequential read	7.05	"6","724799","1"	0.02	file#	block#	blocks
library cache lock	5.03	"9029570680","9480598648","301"	0.07	handle address	lock address	100*mode+namespace
log file parallel write	4.24	"1","4","1"	1.29	files	blocks	requests
log file sync	2.71	"199","168963367","0"	0.02	buffer#	sync scn	NOT DEFINED
wait for scn ack	1.29	"1","34","167361028"	0.02	pending_nd	scnwrp	scnbas

Load Profile

Top Service/Module
Top Client IDs
Top SQL Command Types

Top Service/Module

Service	Module	% Activity	Action	% Action
gpsrac	WriteLog2.exe	29.86	UNNAMED	29.86
	WriteLog.exe	19.35	UNNAMED	19.35
SYS$BACKGROUND	UNNAMED	16.98	UNNAMED	16.98
gpsrac	WriteLog1.exe	16.69	UNNAMED	16.69
	WriteLog_Pro1.exe	11.49	UNNAMED	11.49

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	1,294	33.11	0.90
SELECT	136	18.20	0.50
PL/SQL EXECUTE	4	15.61	0.43
UPDATE	22	6.76	0.18

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
dpv463nz97byz		14.91	CPU + Wait for CPU	14.78	BEGIN SP_INSERT_TRCK_LOG_PRO(:...
6phc1ku32n2nv	3303958488	13.34	CPU + Wait for CPU	13.34	SELECT B.CAR_ID, B.SIM_PHONE_N...
bb8csfdg2csnw	370053094	4.83	CPU + Wait for CPU	3.88	UPDATE GK_T_CARINFO SET LAST_L...

Top SQL using literals

Plan Hash	% Activity	# of Sampled SQL Versions	Example SQL 1	Example SQL TEXT 1	Example SQL 2	Example SQL TEXT 2
3303958488	27.27	1118	6phc1ku32n2nv	SELECT B.CAR_ID, B.SIM_PHONE_N...	6phc1ku32n2nv

Complete List of SQL Text

SQL Id SQL Text

6phc1ku32n2nv SELECT B.CAR_ID, B.SIM_PHONE_NO, A.MDT_ID, B.LAST_REPORT_TIME, B.LAST_LONGITUDE, B.LAST_LATITUDE, B.RECEIVE_TIME, B.FIRST_BACK, B.SERVICE_DATE, B.MILEAGE, B.LAST_ALARM_ID, C.MIDDLE_NO, B.LAST_SPEED FROM GK_T_MDTINFO A, GK_T_CARINFO B, GK_T_MIDDLE_PART C WHERE A.MDT_NO = :B1 AND C.MIDDLE_ID = A.MIDDLE_ID AND A.MDT_ID = B.MDT_ID AND B.DELETE_FLAG = '0' AND ROWNUM = 1

bb8csfdg2csnw UPDATE GK_T_CARINFO SET LAST_LONGITUDE = :B11 , LAST_LATITUDE = :B10 , LAST_REPORT_TIME = :B1 , LAST_SPEED = :B9 , HEIGH = :B8 , LAST_DIRCTION = :B7 , LAST_STATUS_ID = :B6 , LAST_ALARM_ID = :B5 , RECEIVE_TIME = :B4 , MILEAGE = :B3 , ACC_OPEN_TIME = :B1 WHERE CAR_ID = :B2 AND ((LAST_REPORT_TIME IS NULL) OR (LAST_REPORT_TIME < :B1 ))

dpv463nz97byz BEGIN SP_INSERT_TRCK_LOG_PRO(:1, :2, :3); END;

SQL Id	SQL Text
6phc1ku32n2nv	SELECT B.CAR_ID, B.SIM_PHONE_NO, A.MDT_ID, B.LAST_REPORT_TIME, B.LAST_LONGITUDE, B.LAST_LATITUDE, B.RECEIVE_TIME, B.FIRST_BACK, B.SERVICE_DATE, B.MILEAGE, B.LAST_ALARM_ID, C.MIDDLE_NO, B.LAST_SPEED FROM GK_T_MDTINFO A, GK_T_CARINFO B, GK_T_MIDDLE_PART C WHERE A.MDT_NO = :B1 AND C.MIDDLE_ID = A.MIDDLE_ID AND A.MDT_ID = B.MDT_ID AND B.DELETE_FLAG = '0' AND ROWNUM = 1
bb8csfdg2csnw	UPDATE GK_T_CARINFO SET LAST_LONGITUDE = :B11 , LAST_LATITUDE = :B10 , LAST_REPORT_TIME = :B1 , LAST_SPEED = :B9 , HEIGH = :B8 , LAST_DIRCTION = :B7 , LAST_STATUS_ID = :B6 , LAST_ALARM_ID = :B5 , RECEIVE_TIME = :B4 , MILEAGE = :B3 , ACC_OPEN_TIME = :B1 WHERE CAR_ID = :B2 AND ((LAST_REPORT_TIME IS NULL) OR (LAST_REPORT_TIME < :B1 ))
dpv463nz97byz	BEGIN SP_INSERT_TRCK_LOG_PRO(:1, :2, :3); END;

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
FJDXGPS.SP_INSERT_TRCK_LOG_PRO	71.87	SQL	56.72
		FJDXGPS.SP_INSERT_TRCK_LOG_PRO	13.86
		SYS.STANDARD.ACOS#1	1.29
FJDXGPS.SP_INSERT_EXTRA_LOG	1.24	SQL	0.76

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
651,30570	29.86	CPU + Wait for CPU	24.79	FJDXGPS	WriteLog2.exe	1,016/1,501 [ 68%]	415
		db file sequential read	2.34			96/1,501 [ 6%]	94
		library cache lock	1.54			63/1,501 [ 4%]	63
849, 5822	11.49	CPU + Wait for CPU	8.90	FJDXGPS	WriteLog_Pro1.exe	365/1,501 [ 24%]	218
		db file sequential read	1.02			42/1,501 [ 3%]	39
873, 1	10.08	CPU + Wait for CPU	4.49	SYS	oracle@dwptdb1 (LGWR)	184/1,501 [ 12%]	0
		log file parallel write	4.24			174/1,501 [ 12%]	0
		wait for scn ack	1.29			53/1,501 [ 4%]	0
838,12838	9.54	CPU + Wait for CPU	6.98	FJDXGPS	WriteLog1.exe	286/1,501 [ 19%]	148
713, 4194	8.17	CPU + Wait for CPU	6.51	FJDXGPS	WriteLog.exe	267/1,501 [ 18%]	123

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
873, 1	2.71	log file sync	2.68	SYS	oracle@dwptdb1 (LGWR)	413/1,501 [ 28%]	0

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
20273	1.24	gc current grant busy	0.68	FJDXGPS.GK_T_CARINFO (TABLE)	FJSATCOMNOR

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
13:31:22 (1.6 min)	293	CPU + Wait for CPU	234	5.71
		db file sequential read	23	0.56
		library cache lock	12	0.29
13:33:00 (3.0 min)	519	CPU + Wait for CPU	388	9.47
		db file sequential read	45	1.10
		log file parallel write	25	0.61
13:36:00 (3.0 min)	563	CPU + Wait for CPU	418	10.20
		db file sequential read	41	1.00
		log file parallel write	28	0.68
13:39:00 (3.0 min)	517	CPU + Wait for CPU	401	9.78
		db file sequential read	34	0.83
		library cache lock	24	0.59
13:42:00 (3.0 min)	484	CPU + Wait for CPU	358	8.73
		db file sequential read	41	1.00
		log file parallel write	25	0.61
13:45:00 (3.0 min)	514	CPU + Wait for CPU	375	9.15
		library cache lock	39	0.95
		db file sequential read	37	0.90
13:48:00 (3.0 min)	451	CPU + Wait for CPU	368	8.98
		db file sequential read	26	0.63
		library cache lock	19	0.46
13:51:00 (3.0 min)	407	CPU + Wait for CPU	301	7.34
		db file sequential read	22	0.54
		library cache lock	22	0.54
13:54:00 (2.4 min)	351	CPU + Wait for CPU	259	6.32
		library cache lock	24	0.59
		db file sequential read	20	0.49

End of Report Report written to ashrpt_1_1230_1356.html SQL>