ASH Report For JSDB/jsdb

DB Name DB Id Instance Inst num Release RAC Host

JSDB 3066449946 jsdb 1 10.2.0.4.0 NO SXHSDB2

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
JSDB	3066449946	jsdb	1	10.2.0.4.0	NO	SXHSDB2

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

64 32,768M (100%) 29,568M (90.2%) 3,120M (9.5%) 68.0M (0.2%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
64	32,768M (100%)	29,568M (90.2%)	3,120M (9.5%)	68.0M (0.2%)

Sample Time Data Source

Analysis Begin Time: 25-Jul-12 11:30:00 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 25-Jul-12 12:00:00 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 30.0 (mins)

Sample Count: 130,017

Average Active Sessions: 72.23

Avg. Active Session per CPU: 1.13

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	25-Jul-12 11:30:00	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	25-Jul-12 12:00:00	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	30.0 (mins)
Sample Count:	130,017
Average Active Sessions:	72.23
Avg. Active Session per CPU:	1.13
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	86.67	62.60
latch: library cache	Concurrency	9.92	7.16
log file sync	Commit	1.22	0.88
latch: library cache lock	Concurrency	1.13	0.81

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	Parameter 2	Parameter 3
latch: library cache	9.92	"504403192371015728","215","0"	9.92	address	number	tries
log file sync	1.22	"722","0","0"	0.00	buffer#	NOT DEFINED	NOT DEFINED
latch: library cache lock	1.13	"504403192423420680","216","0"	1.13	address	number	tries

Load Profile

Top Service/Module
Top Client IDs
Top SQL Command Types

Top Service/Module

Service	Module	% Activity	Action	% Action
SYS$USERS	UNNAMED	99.21	UNNAMED	99.21

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	97.33	70.30

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	% Activity	Event	% Event	SQL Text
4hbfsfnnydqnh	97.33	CPU + Wait for CPU	86.21	INSERT INTO tbl_ctjs (gsdm, xz...
	97.33	latch: library cache	9.90	INSERT INTO tbl_ctjs (gsdm, xz...
	97.33	latch: library cache lock	1.12	INSERT INTO tbl_ctjs (gsdm, xz...

Top SQL using literals

No data exists for this section of the report.

Complete List of SQL Text

SQL Id SQL Text

4hbfsfnnydqnh INSERT INTO tbl_ctjs (gsdm, xzdm, gappno, bdh, ryxh, datasrc, rowid_from, flag, bbrxb, bdzt, jffs, jfqx, sjjfqx, bxqx, lqfs, lqnl, tbnl, cbrq, ksrq, tzrq, bdztbhrq, xcjfqx, zjqx, cjrq, jfcs, jfl, jfbz, fs, ljjnbf, dqje, yjbf, cbzjf, zhye, swrq, swgfje, dqtbje, sum_dispay, sum_surpay, sum_mq, xsqd, bdjgnf, dnbf, dnpgbf, prem_flag, kqx, sxsjbf, basres, pdres, cv, zbj, sxminus, swzbj, tbzbj, zbjjsbzw, ylwlje, ypwpje, wjzbj, wjzbjbzw, pvpension, initialpay, njjs_flag, dqjnbf, dqjfzrqq, zjjfrq, xbbf, dnjfcs, dnjfbf, ydfy, zjyj, jjyj, glf, fyjsbzw, fy_adjust, fy_adjust_flag, zrswbe, ywswbe, ywscbe, yxbe, bejsbzw, living_p1, death_p1, living_p2, death_p2, living_p3, death_p3, living_fp, living_flag, jfxbe, yqswgf, cfnled, dqyn, yqswjsbzw, lqnx, lpgfrq, dnlqje, int_expect, expect_flag, snwzbj, dqylje, yqswgfcb, sum_sc, sum_medpay, gpolicyno, tb_cv, snmbdztbhrq, bmdm, ibnr, dnlpje, dntbje, dqmqje, dqnjlqje, dqqtje, deptno_cw, kxqydfy, kxqdnpgbf, pgfy, yqscgf, fa_sp, snmbdzt, errortype, estres, recalcflag, div_add, xcjfrq, res0, bdzt0, stopdate, begdate, zjfxrq, reljfqx, xzdm8, grace_bf) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, : 82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132)

SQL Id	SQL Text
4hbfsfnnydqnh	INSERT INTO tbl_ctjs (gsdm, xzdm, gappno, bdh, ryxh, datasrc, rowid_from, flag, bbrxb, bdzt, jffs, jfqx, sjjfqx, bxqx, lqfs, lqnl, tbnl, cbrq, ksrq, tzrq, bdztbhrq, xcjfqx, zjqx, cjrq, jfcs, jfl, jfbz, fs, ljjnbf, dqje, yjbf, cbzjf, zhye, swrq, swgfje, dqtbje, sum_dispay, sum_surpay, sum_mq, xsqd, bdjgnf, dnbf, dnpgbf, prem_flag, kqx, sxsjbf, basres, pdres, cv, zbj, sxminus, swzbj, tbzbj, zbjjsbzw, ylwlje, ypwpje, wjzbj, wjzbjbzw, pvpension, initialpay, njjs_flag, dqjnbf, dqjfzrqq, zjjfrq, xbbf, dnjfcs, dnjfbf, ydfy, zjyj, jjyj, glf, fyjsbzw, fy_adjust, fy_adjust_flag, zrswbe, ywswbe, ywscbe, yxbe, bejsbzw, living_p1, death_p1, living_p2, death_p2, living_p3, death_p3, living_fp, living_flag, jfxbe, yqswgf, cfnled, dqyn, yqswjsbzw, lqnx, lpgfrq, dnlqje, int_expect, expect_flag, snwzbj, dqylje, yqswgfcb, sum_sc, sum_medpay, gpolicyno, tb_cv, snmbdztbhrq, bmdm, ibnr, dnlpje, dntbje, dqmqje, dqnjlqje, dqqtje, deptno_cw, kxqydfy, kxqdnpgbf, pgfy, yqscgf, fa_sp, snmbdzt, errortype, estres, recalcflag, div_add, xcjfrq, res0, bdzt0, stopdate, begdate, zjfxrq, reljfqx, xzdm8, grace_bf) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, : 82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132)

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	# Samples Active	XIDs
1054, 15	1.27	CPU + Wait for CPU	1.02	ACTAPP	1,328/1,800 [ 74%]	4
1057, 2	1.27	CPU + Wait for CPU	1.01	ACTAPP	1,312/1,800 [ 73%]	7
1028, 665	1.27	CPU + Wait for CPU	1.12	ACTAPP	1,452/1,800 [ 81%]	107
1002, 52	1.27	CPU + Wait for CPU	1.14	ACTAPP	1,484/1,800 [ 82%]	119
1035, 2360	1.27	CPU + Wait for CPU	1.13	ACTAPP	1,474/1,800 [ 82%]	106

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
1094, 1	1.22	log file sync	1.22	SYS	oracle@SXHSDB2 (LGWR)	759/1,800 [ 42%]	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

No data exists for this section of the report.

Top DB Files

No data exists for this section of the report.

Top Latches

Latch	% Latch	Blocking Sid	% Activity	Max Sampled Wait secs	# Waits Sampled	# Sampled Wts < 10ms	# Sampled Wts 10ms - 100ms	# Sampled Wts 100ms - 1s	# Sampled Wts > 1s
latch: library cache	9.92	Held Shared	9.92	0.13	12,892	611	12,258	23	0
latch: library cache lock	1.13	Held Shared	1.13	0.14	1,464	124	1,316	24	0

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
11:30:00 (3.0 min)	13,014	CPU + Wait for CPU	11,313	8.70
		latch: library cache	1,258	0.97
		log file sync	147	0.11
11:33:00 (3.0 min)	12,887	CPU + Wait for CPU	11,356	8.73
		latch: library cache	1,092	0.84
		log file sync	154	0.12
11:36:00 (3.0 min)	12,849	CPU + Wait for CPU	11,226	8.63
		latch: library cache	1,197	0.92
		latch: library cache lock	163	0.13
11:39:00 (3.0 min)	12,973	CPU + Wait for CPU	11,232	8.64
		latch: library cache	1,406	1.08
		log file sync	140	0.11
11:42:00 (3.0 min)	13,073	CPU + Wait for CPU	11,428	8.79
		latch: library cache	1,182	0.91
		log file sync	194	0.15
11:45:00 (3.0 min)	12,928	CPU + Wait for CPU	11,219	8.63
		latch: library cache	1,242	0.96
		latch: library cache lock	174	0.13
11:48:00 (3.0 min)	13,064	CPU + Wait for CPU	11,309	8.70
		latch: library cache	1,287	0.99
		latch: library cache lock	181	0.14
11:51:00 (3.0 min)	13,120	CPU + Wait for CPU	11,252	8.65
		latch: library cache	1,475	1.13
		log file sync	185	0.14
11:54:00 (3.0 min)	13,017	CPU + Wait for CPU	11,137	8.57
		latch: library cache	1,428	1.10
		log file sync	171	0.13
11:57:00 (3.0 min)	13,092	CPU + Wait for CPU	11,246	8.65
		latch: library cache	1,326	1.02
		latch: library cache lock	229	0.18

End of Report