ASH Report For ODSDB/odsdb1

DB Name DB Id Instance Inst num Release RAC Host

ODSDB 3367537179 odsdb1 1 10.2.0.4.0 YES cwgkdb1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ODSDB	3367537179	odsdb1	1	10.2.0.4.0	YES	cwgkdb1

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

8 13,312M (100%) 8,992M (67.5%) 3,841M (28.9%) M (%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
8	13,312M (100%)	8,992M (67.5%)	3,841M (28.9%)	M (%)

Sample Time Data Source

Analysis Begin Time: 02-3月 -12 03:00:00 DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 12890

Analysis End Time: 02-3月 -12 04:00:00 DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 12891
+ V$ACTIVE_SESSION_HISTORY

Elapsed Time: 60.0 (mins)

Sample Count: 9,711

Average Active Sessions: 26.98

Avg. Active Session per CPU: 3.37

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	02-3月 -12 03:00:00	DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 12890
Analysis End Time:	02-3月 -12 04:00:00	DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 12891 + V$ACTIVE_SESSION_HISTORY
Elapsed Time:	60.0 (mins)
Sample Count:	9,711
Average Active Sessions:	26.98
Avg. Active Session per CPU:	3.37
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
library cache lock	Concurrency	63.01	17.00
library cache load lock	Concurrency	24.14	6.51
enq: SQ - contention	Configuration	2.18	0.59
DFS lock handle	Other	1.65	0.44
rdbms ipc reply	Other	1.64	0.44

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
DFS lock handle	Other	3.19	0.86
enq: CF - contention	Other	1.64	0.44
enq: DR - contention	Other	1.23	0.33
library cache lock	Concurrency	1.04	0.28

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
library cache lock	64.05	"504403171599741072","504403171522266296","351"	0.72	handle address	lock address	100*mode+namespace
library cache load lock	24.14	"504403170095954888","504403171623150072","918"	0.40	object address	lock address	100*mask+namespace
DFS lock handle	4.84	"1128857605","30","5"	1.65	type\|mode	id1	id2
		"1128857605","30","1"	1.05
enq: SQ - contention	2.18	"1397817350","12193","0"	2.12	name\|mode	object #	0
enq: CF - contention	1.64	"1128660996","0","0"	1.24	name\|mode	0	operation

Load Profile

Top Service/Module
Top Client IDs
Top SQL Command Types

Top Service/Module

Service	Module	% Activity	Action	% Action
SYS$USERS	UNNAMED	75.46	UNNAMED	75.46
	JDBC Thin Client	16.49	UNNAMED	16.49
SYS$BACKGROUND	UNNAMED	6.38	UNNAMED	6.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
PL/SQL EXECUTE	5	53.90	14.54
SELECT	4	2.29	0.62

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
a16hu5wzwq421		53.14	library cache lock	53.14	BEGIN vPD_PKG.SET_CONTEXT_COMP...
6aasuxzxky1gh	2362351035	2.12	enq: SQ - contention	2.12	SELECT HZ_SEQ.NEXTVAL SEQVALUE...
4gd6b1r53yt88		1.80	DFS lock handle	1.78	SQL Text Not Available

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 **

6aasuxzxky1gh SELECT HZ_SEQ.NEXTVAL SEQVALUE FROM DUAL

a16hu5wzwq421 BEGIN vPD_PKG.SET_CONTEXT_COMPID('0400'); END;

SQL Id	SQL Text
4gd6b1r53yt88	SQL Text Not Available
6aasuxzxky1gh	SELECT HZ_SEQ.NEXTVAL SEQVALUE FROM DUAL
a16hu5wzwq421	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0400'); 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
FMIS0400.VPD_PKG.SET_CONTEXT_COMPID	53.87	SYS.DBMS_SESSION.SET_CONTEXT	53.87

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
430, 1	1.80	DFS lock handle	1.78	SYS	oracle@cwgkdb1 (MMON)	173/360 [ 48%]
432, 1	1.23	enq: DR - contention	1.23	SYS	oracle@cwgkdb1 (RECO)	119/360 [ 33%]
93,58725	1.16	DFS lock handle	0.82	FMIS0400		80/360 [ 22%]
199,10447	1.07	enq: SQ - contention	0.75	FMIS0400		73/360 [ 20%]

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
270,43903	24.14	library cache load lock	24.14	FMIS0400		39/360 [ 11%]	0
93,58725	2.12	enq: SQ - contention	2.12	FMIS0400		113/360 [ 31%]	1

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
03:20:00 (5.0 min)	2,179	library cache lock	1,215	12.51
		library cache load lock	808	8.32
		DFS lock handle	75	0.77
03:25:00 (5.0 min)	3,794	library cache lock	1,961	20.19
		library cache load lock	1,536	15.82
		DFS lock handle	128	1.32
03:30:00 (5.0 min)	56	DFS lock handle	43	0.44
		enq: SQ - contention	6	0.06
		CPU + Wait for CPU	3	0.03
03:35:00 (5.0 min)	129	enq: SQ - contention	65	0.67
		DFS lock handle	60	0.62
		enq: DR - contention	2	0.02
03:40:00 (5.0 min)	200	enq: SQ - contention	107	1.10
		DFS lock handle	60	0.62
		enq: DR - contention	30	0.31
03:45:00 (5.0 min)	1,983	library cache lock	1,849	19.04
		DFS lock handle	41	0.42
		enq: DR - contention	30	0.31
03:50:00 (5.0 min)	1,313	library cache lock	1,193	12.29
		DFS lock handle	36	0.37
		enq: DR - contention	30	0.31
03:55:00 (5.0 min)	57	DFS lock handle	27	0.28
		enq: DR - contention	27	0.28
		library cache lock	2	0.02

End of Report