ASH Report For UPRR/uprr

DB Name DB Id Instance Inst num Release RAC Host

UPRR 1058789863 uprr 1 11.2.0.3.0 NO cnuctdb130

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
UPRR	1058789863	uprr	1	11.2.0.3.0	NO	cnuctdb130

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

16 16,311M (100%) 5,600M (34.3%) 1,024M (6.3%) 32.0M (0.2%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
16	16,311M (100%)	5,600M (34.3%)	1,024M (6.3%)	32.0M (0.2%)

Sample Time Data Source

Analysis Begin Time: 24-Apr-13 15:29:41 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 24-Apr-13 15:59:41 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 30.0 (mins)

Sample Count: 3,900

Average Active Sessions: 2.17

Avg. Active Session per CPU: 0.14

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	24-Apr-13 15:29:41	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	24-Apr-13 15:59:41	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	30.0 (mins)
Sample Count:	3,900
Average Active Sessions:	2.17
Avg. Active Session per CPU:	0.14
Report Target:	None specified

Top Events

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

Top User Events

Event	Event Class	% Event	Avg Active Sessions
CPU + Wait for CPU	CPU	35.56	0.77
log file sequential read	System I/O	16.18	0.35
Disk file operations I/O	User I/O	1.67	0.04

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
row cache lock	Concurrency	45.97	1.00

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
row cache lock	45.97	"2","0","3"	45.97	cache id	mode	request
log file sequential read	16.18	"0","391168","2048"	0.18	log#	block#	blocks
Disk file operations I/O	1.69	"2","0","3"	1.49	FileOperation	fileno	filetype

Load Profile

Top Service/Module
Top Client IDs
Top SQL Command Types
Top Phases of Execution

Top Service/Module

Service	Module	% Activity	Action	% Action
SYS$USERS	JDBC Thin Client	50.03	UNNAMED	50.03
SYS$BACKGROUND	UNNAMED	46.51	UNNAMED	46.51
uprr	PL/SQL Developer	3.44	SQL 窗口 - 新建	3.38

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	3	46.95	1.02
SELECT	75	6.41	0.14

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution	% Activity	Avg Active Sessions
SQL Execution	53.10	1.15

Back to Load Profile
Back to Top

Top SQL

Top SQL with Top Events
Top SQL with Top Row Sources
Top SQL using literals
Top Parsing Module/Action
Complete List of SQL Text

Top SQL with Top Events

SQL ID	Planhash	Sampled # of Executions	% Activity	Event	% Event	Top Row Source	% RwSrc	SQL Text
3g3k82x8rr54f	1397102654	166	45.67	CPU + Wait for CPU	27.95	Row Source Not Available	27.95	insert into DF2_GL_BALANCE_QUE...
3g3k82x8rr54f	1397102654	166	45.66666666666666666666666666666666666667	log file sequential read	16.05	Row Source Not Available	16.05
3g3k82x8rr54f	1397102654	166	45.66666666666666666666666666666666666667	Disk file operations I/O	1.64	Row Source Not Available	1.64
gb3kwkhf2yrhp	3618362180	1	1.74	CPU + Wait for CPU	1.74	FIXED TABLE - FIXED INDEX	1.69	select * from v$access t where...

Top SQL with Top Row Sources

SQL ID	PlanHash	Sampled # of Executions	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
3g3k82x8rr54f	1397102654	166	45.67	Row Source Not Available	45.67	CPU + Wait for CPU	27.95	insert into DF2_GL_BALANCE_QUE...
gb3kwkhf2yrhp	3618362180	1	1.74	FIXED TABLE - FIXED INDEX	1.69	CPU + Wait for CPU	1.69	select * from v$access t where...

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

3g3k82x8rr54f insert into DF2_GL_BALANCE_QUERY( Account, Account_Desc, Dept_ID, Dept_ID_Desc, Oper_Unit, Oper_Unit_Desc, Product, Product_Desc, C_Class, C_Class_Desc, Affiliate, Affiliate_Desc, Project_ID, Project_ID_Desc, Tran_Ccy, Tran_Amt, Base_Ccy, Base_Amt, branch, DATA_DATE) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 )

gb3kwkhf2yrhp select * from v$access t where t.TYPE = 'TABLE' AND T.OBJECT='DF2_GL_BALANCE_QUERY'

SQL Id	SQL Text
3g3k82x8rr54f	insert into DF2_GL_BALANCE_QUERY( Account, Account_Desc, Dept_ID, Dept_ID_Desc, Oper_Unit, Oper_Unit_Desc, Product, Product_Desc, C_Class, C_Class_Desc, Affiliate, Affiliate_Desc, Project_ID, Project_ID_Desc, Tran_Ccy, Tran_Amt, Base_Ccy, Base_Amt, branch, DATA_DATE) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 )
gb3kwkhf2yrhp	select * from v$access t where t.TYPE = 'TABLE' AND T.OBJECT='DF2_GL_BALANCE_QUERY'

Top PL/SQL Procedures

No data exists for this section of the report.

Top Java Workload

No data exists for this section of the report.

Top Call Types

Call Type	Count	% Activity	Avg Active Sessions
V8 Bundled Exec	1,947	49.92	1.08
FETCH	136	3.49	0.08

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
926, 1	45.97	row cache lock	45.97	SYS	oracle@cnuctdb130 (SMON)	1,793/1,800 [100%]	0
1168,23869	40.00	CPU + Wait for CPU	24.26	DATACORE	JDBC Thin Client	946/1,800 [ 53%]	0
1168,23869	40	log file sequential read	14.28	DATACORE	JDBC Thin Client	557/1,800 [ 31%]	0
1168,23869	40	Disk file operations I/O	1.44	DATACORE	JDBC Thin Client	56/1,800 [ 3%]	0
1009, 283	5.97	CPU + Wait for CPU	3.85	DATACORE	JDBC Thin Client	150/1,800 [ 8%]	0
1009, 283	5.97435897435897435897435897435897435897	log file sequential read	1.90	DATACORE	JDBC Thin Client	74/1,800 [ 4%]	0
315,54271	3.31	CPU + Wait for CPU	3.31	DATACORE	plsqldev.exe	129/1,800 [ 7%]	0
1009, 287	1.21	CPU + Wait for CPU	1.18	DATACORE	JDBC Thin Client	46/1,800 [ 3%]	1

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 (Inst)	% Activity	Event Caused	% Event	User	Program	# Samples Active	XIDs
1168,23869( 1)	40.00	row cache lock	40.00	DATACORE	JDBC Thin Client	1,560/1,800 [ 87%]	0
1009, 283( 1)	5.97	row cache lock	5.97	DATACORE	JDBC Thin Client	233/1,800 [ 13%]	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

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
15:29:41 (19 secs)	43	row cache lock	20	0.51
15:29:41 (19 secs)	43	CPU + Wait for CPU	18	0.46
15:29:41 (19 secs)	43	log file sequential read	4	0.10
15:30:00 (3.0 min)	381	row cache lock	178	4.56
15:30:00 (3.0 min)	381	CPU + Wait for CPU	133	3.41
15:30:00 (3.0 min)	381	log file sequential read	63	1.62
15:33:00 (3.0 min)	374	row cache lock	177	4.54
15:33:00 (3.0 min)	374	CPU + Wait for CPU	131	3.36
15:33:00 (3.0 min)	374	log file sequential read	56	1.44
15:36:00 (3.0 min)	367	row cache lock	181	4.64
15:36:00 (3.0 min)	367	CPU + Wait for CPU	116	2.97
15:36:00 (3.0 min)	367	log file sequential read	65	1.67
15:39:00 (3.0 min)	449	CPU + Wait for CPU	197	5.05
15:39:00 (3.0 min)	449	row cache lock	179	4.59
15:39:00 (3.0 min)	449	log file sequential read	64	1.64
15:42:00 (3.0 min)	428	row cache lock	180	4.62
15:42:00 (3.0 min)	428	CPU + Wait for CPU	178	4.56
15:42:00 (3.0 min)	428	log file sequential read	61	1.56
15:45:00 (3.0 min)	371	row cache lock	180	4.62
15:45:00 (3.0 min)	371	CPU + Wait for CPU	120	3.08
15:45:00 (3.0 min)	371	log file sequential read	64	1.64
15:48:00 (3.0 min)	411	row cache lock	179	4.59
15:48:00 (3.0 min)	411	CPU + Wait for CPU	162	4.15
15:48:00 (3.0 min)	411	log file sequential read	62	1.59
15:51:00 (3.0 min)	365	row cache lock	180	4.62
15:51:00 (3.0 min)	365	CPU + Wait for CPU	114	2.92
15:51:00 (3.0 min)	365	log file sequential read	62	1.59
15:54:00 (3.0 min)	383	row cache lock	181	4.64
15:54:00 (3.0 min)	383	CPU + Wait for CPU	135	3.46
15:54:00 (3.0 min)	383	log file sequential read	60	1.54
15:57:00 (2.7 min)	328	row cache lock	158	4.05
15:57:00 (2.7 min)	328	CPU + Wait for CPU	95	2.44
15:57:00 (2.7 min)	328	log file sequential read	70	1.79

End of Report