SQL> SELECT * FROM TABLE(dbms_workload_repository.ash_report_html(1824802046, 1, SYSDATE-30/1440, SYSDATE-1/1440)); ASH Report - From 06-Sep-11 22:17:36 To 06-Sep-11 22:46:36

ASH Report For ORABASE/orabase

DB Name DB Id Instance Inst num Release RAC Host

ORABASE 1824802046 orabase 1 11.2.0.2.0 NO PERRITO3

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORABASE	1824802046	orabase	1	11.2.0.2.0	NO	PERRITO3

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

2 734M (100%) 224M (30.5%) 432M (58.8%) 4.0M (0.5%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
2	734M (100%)	224M (30.5%)	432M (58.8%)	4.0M (0.5%)

Sample Time Data Source

Analysis Begin Time: 06-Sep-11 22:17:36 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 06-Sep-11 22:46:36 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 29.0 (mins)

Sample Count: 51

Average Active Sessions: 0.03 < /td>

Avg. Active Session per CPU: 0.01

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	06-Sep-11 22:17:36	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	06-Sep-11 22:46:36	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	29.0 (mins)
Sample Count:	51
Average Active Sessions:	0.03	< /td>
Avg. Active Session per CPU:	0.01
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	29.41	0.01

Top Background Events

< td align="right" class='awrc'>0.00

Event	Event Class	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	39.22	0.01
control file sequential read	System I/O	1 5.69	0.00
os thread startup	Concurrency	7.84	0.00
control file parallel write	System I/O	3. 92	0.00
db file parallel write	System I/O	3.92

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
control file sequential read	15.69	"0","1","1"	13.73	file#	block#	blocks
		"0" ,"202","1"	1.96
control file parallel write	3.92	"2","3","2"	3.92	files	block#	requests
db file parallel write	3.92	"1","0","2147483647"	3.92	requests	interrupt	timeout

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$BACKGROUND	UNNAMED	66.67	UNNAMED	66.67
SYS$USERS	sqlplusw.exe	27.45	UNNAMED	27.45
SYS$BACKGROUND	KTSJ	1.96	KTSJ Coordinator	1.96
	MMON_SLAVE	1.96	Monitor FRA Space	1.96
SYS$USERS	UNNAMED	1.96	UNNAMED	1.96

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 fo und over all the ASH samples in the analysis period

< td align="right" class='awrnc'>0.00

SQL Command Type	Distinct SQLIDs	% Ac tivity	Avg Active Sessions
SELECT	3	29.41	0.01
PL/SQL EXECUTE	1	1.96

Back to Load Profile
Back to Top

Top Phases of Execution

< /tr>

Phase of Execution	% Activity	Avg Act ive Sessions
SQL Execution	29.41	0.01

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 Executio ns	% Activity	Event	% Event	Top R ow Source	% RwSrc	SQL Text
1687znp3338rv	3177164637	1	25.49	CPU + Wait for CPU	25.49	FIXED TABLE - FIXED IND EX	25.49	select distinct a.sql_id from ...
4f9wwn89rak2c	3529078339	1	1.96	CPU + Wait for CPU	1.96	HASH JOIN - OUTER	1.96	select table_name from dba_tab...
6gvch1xu9ca3g		1	1.96	CPU + Wait for CPU	1.96	Row Source Not Availa ble	1.96	DECLARE job BINARY_INTEGER := ...
c3zfy3qrwwdum	1614006686	1	1.96	control file sequential read	1.96	FIXED TABLE - FULL	1.96	SELECT COUNT(DISTINCT SET_COUN...

Top SQL with Top Row Sources

SQL ID	PlanHash	Sampled # of Executio ns	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
1687znp3338rv	3177164637	1	25.49	FIXED TABLE - FIXED INDEX	25.49	CPU + Wait for C PU	25.49	select distinct a.sql_id from ...
4f9wwn89rak2c	3529078339	1	1.96	HASH JOIN - OUTER	1.96	CPU + Wait for CPU	1.96	select table_name from dba_tab...
6gvch1xu9ca3g		1	1.96	Row Source Not Available	1.96	CPU + Wait f or CPU	1.96	DECLARE job BINARY_INTEGER := ...
c3zfy3qrwwdum	1614006686	1	1.96	FIXED TABLE - FULL	1.96	control file sequenti al read	1.96	SELECT COUNT(DISTINCT SET_COUN...

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

1687znp3338rv select distinct a.sql_id from v$sql_plan a, v$sql_plan b where a.sql_id = b.sql_id and a.plan_hash_value <> b.plan_hash_value

4f9wwn89rak2c select table_name from dba_tables where table_name like 'W%ACTIVE%'

6gvch1xu9ca3g DECLARE job BINARY_INTEGE R := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydat e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

c3zfy3qrwwdum SELECT COUNT(DISTINCT S ET_COUNT) FROM V$BACKUP_PIECE WHERE STATUS != 'D'

SQL Id	SQL Text
1687znp3338rv	select distinct a.sql_id from v$sql_plan a, v$sql_plan b where a.sql_id = b.sql_id and a.plan_hash_value <> b.plan_hash_value
4f9wwn89rak2c	select table_name from dba_tables where table_name like 'W%ACTIVE%'
6gvch1xu9ca3g	DECLARE job BINARY_INTEGE R := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydat e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
c3zfy3qrwwdum	SELECT COUNT(DISTINCT S ET_COUNT) FROM V$BACKUP_PIECE WHERE STATUS != 'D'

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 entr y subprogram

PLSQL Entry Subprogram	% Activity	PLS QL Current Subprogram	% Current
SYS.DBMS_RCVMAN.#package_initialization	1.96	SQL	1.96
SYSMAN.EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS	1.96	SQL	1.96

Top Java Workload

No data exists for this section of the report.

Top Call Types

< td align="right" class='awrc'>0.01

Call Type	Count	% Activity	Avg Active Sessions
V8 Bundled Exec	14	27.45

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 tha t 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 f or 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
126, 1	25.49	CPU + Wait for CPU	25.49	SYS	ORACLE.EXE (PSP0)	13/1,740 [ 1%]
154, 1057	25.49	CPU + Wait for CPU	25.49	SYS	sqlplusw.exe	13/1,740 [ 1%]
6, 1	19.61	control file seq uential read	13.73	SYS	ORACLE.EXE (CKPT)	7/1,740 [ 0%]
		control file parallel write	3.92			2/1,740 [ 0%]
		CPU + Wait for C PU	1.96			1/1,740 [ 0%]
4, 1	9.80	CPU + Wait for CPU	9.80	SYS	ORACLE.EXE (DIA0)	5/1,740 [ 0%]
5, 1	3.92	db file parallel write	3.92	SYS	ORACLE.EXE (DBW0)	2/1,740 [ 0%]

Top Blocking Sessions

No data exists for this section of the report.

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
22:18:00 (3.0 min)	4	CPU + W ait for CPU	3	5.88
		os thread sta rtup	1	1.96
22:21:00 (3.0 min)	1	CPU + W ait for CPU	1	1.96
22:24:00 (3.0 min)	4	CPU + Wait for CPU	4	7.84
22:27:00 (3.0 min)	16	CPU + Wait for CPU	14	27.45
		control file parallel write	1	1.96
		control file seq uential read	1	1.96
22:30:00 (3.0 min)	3	CPU + Wait for CPU	3	5.88
22:33:00 (3.0 min)	5	CPU + W ait for CPU	2	3.92
		os thread sta rtup	2	3.92
		control file seq uential read	1	1.96
22:36:00 (3.0 min)	2	CPU + Wait for CPU	2	3.92
22:39:00 (3.0 min)	4	CPU + W ait for CPU	2	3.92
		control file parallel write	1	1.96
		os thread startu p	1	1.96
22:42:00 (3.0 min)	10	con trol file sequential read	6	11.76
		CPU + Wait for C PU	2	3.92
		db file paral lel write	2	3.92
22:45:00 (1.6 min)	2	CPU + W ait for CPU	2	3.92

End of Report 409 rows selected. SQL> spool off