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 NameDB IdInstanceInst numReleaseRACHost
ORABASE1824802046orabase111.2.0.2.0NOPERRITO3

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
2734M (100%)224M (30.5%)432M (58.8%)4.0M (0.5%)

Sample TimeData Source
Analysis Begin Time:06-Sep-11 22:17:36V$ACTIVE_SESSION_HISTORY
Analysis End Time:06-Sep-11 22:46:36V$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 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
CPU + Wait for CPUCPU29.410.01

Back to Top Events
Back to Top

Top Background Events

< td align="right" class='awrc'>0.00
EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPUCPU39.220.01
control file sequential readSystem I/O1 5.690.00
os thread startupConcurrency7.840.00
control file parallel writeSystem I/O3. 920.00
db file parallel writeSystem I/O3.92

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
control file sequential read15.69"0","1","1"13.73 file#block#blocks
  "0" ,"202","1"1.96    
control file parallel write3.92"2","3","2"3.92 filesblock#requests
db file parallel write3.92"1","0","2147483647"3.92 requestsinterrupttimeout

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$BACKGROUNDUNNAMED66.67UNNAMED66.67
SYS$USERSsqlplusw.exe27.45UNNAMED27.45
SYS$BACKGROUNDKTSJ1.96KTSJ Coordinator1.96
 MMON_SLAVE1.96Monitor FRA Space1.96
SYS$USERSUNNAMED1.96 UNNAMED1.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

< td align="right" class='awrnc'>0.00
SQL Command TypeDistinct SQLIDs% Ac tivityAvg Active Sessions
SELECT329.410.01
PL/SQL EXECUTE11.96

Back to Load Profile
Back to Top

Top Phases of Execution

< /tr>
Phase of Execution% ActivityAvg Act ive Sessions
SQL Execution29.410.01

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL with Top Events

SQL IDPlanhashSampled # of Executio ns% ActivityEvent% EventTop R ow Source% RwSrcSQL Text
1687znp3338rv3177164637125.49 CPU + Wait for CPU25.49FIXED TABLE - FIXED IND EX25.49 select distinct a.sql_id from ...
4f9wwn89rak2c352907833911.96 CPU + Wait for CPU1.96HASH JOIN - OUTER1.96 select table_name from dba_tab...
6gvch1xu9ca3g 11.96 CPU + Wait for CPU1.96** Row Source Not Availa ble **1.96 DECLARE job BINARY_INTEGER := ...
c3zfy3qrwwdum161400668611.96 control file sequential read1.96FIXED TABLE - FULL1.96 SELECT COUNT(DISTINCT SET_COUN...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executio ns% ActivityRow Source% RwSrc Top Event% EventSQL Text
1687znp3338rv3177164637125.49 FIXED TABLE - FIXED INDEX25.49CPU + Wait for C PU25.49 select distinct a.sql_id from ...
4f9wwn89rak2c352907833911.96 HASH JOIN - OUTER1.96CPU + Wait for CPU1.96 select table_name from dba_tab...
6gvch1xu9ca3g 11.96 ** Row Source Not Available **1.96CPU + Wait f or CPU1.96 DECLARE job BINARY_INTEGER := ...
c3zfy3qrwwdum161400668611.96 FIXED TABLE - FULL1.96control file sequenti al read1.96 SELECT COUNT(DISTINCT SET_COUN...

Back to Top SQL
Back to Top

Top SQL using literals

No data exists for this section of the report.

Back to Top SQL
Back to Top

Top Parsing Module/Action

No data exists for this section of the report.

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
1687znp3338rvselect 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
4f9wwn89rak2cselect table_name from dba_tables where table_name like 'W%ACTIVE%'
6gvch1xu9ca3gDECLARE 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;
c3zfy3qrwwdumSELECT COUNT(DISTINCT S ET_COUNT) FROM V$BACKUP_PIECE WHERE STATUS != 'D'

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLS QL Current Subprogram% Current
SYS.DBMS_RCVMAN.#package_initialization1.96 SQL1.96
SYSMAN.EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS1.96 SQL1.96


Back to Top

Top Java Workload

No data exists for this section of the report.


Back to Top

Top Call Types

< td align="right" class='awrc'>0.01
Call TypeCount% ActivityAvg Active Sessions
V8 Bundled Exec1427.45


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
126, 125.49CPU + Wait for CPU25.49 SYSORACLE.EXE (PSP0)13/1,740 [ 1%]0
154, 105725.49CPU + Wait for CPU25.49 SYSsqlplusw.exe13/1,740 [ 1%]0
6, 119.61control file seq uential read13.73 SYSORACLE.EXE (CKPT)7/1,740 [ 0%]0
  control file parallel write3.92   2/1,740 [ 0%]0
  CPU + Wait for C PU1.96   1/1,740 [ 0%]0
4, 19.80CPU + Wait for CPU9.80 SYSORACLE.EXE (DIA0)5/1,740 [ 0%]0
5, 13.92db file parallel write3.92 SYSORACLE.EXE (DBW0)2/1,740 [ 0%]0

Back to Top Sessions
Back to Top

Top Blocking Sessions

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Sessions running PQs

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Objects/Files/Latches

Back to Top

Top DB Objects

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top Latches

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEvent Event Count% Event
22:18:00 (3.0 min)4CPU + W ait for CPU35.88
  os thread sta rtup11.96
22:21:00 (3.0 min)1CPU + W ait for CPU11.96
22:24:00 (3.0 min)4CPU + Wait for CPU47.84
22:27:00 (3.0 min)16CPU + Wait for CPU1427.45
  control file parallel write11.96
  control file seq uential read11.96
22:30:00 (3.0 min)3CPU + Wait for CPU35.88
22:33:00 (3.0 min)5CPU + W ait for CPU23.92
  os thread sta rtup23.92
  control file seq uential read11.96
22:36:00 (3.0 min)2CPU + Wait for CPU23.92
22:39:00 (3.0 min)4CPU + W ait for CPU23.92
  control file parallel write11.96
  os thread startu p11.96
22:42:00 (3.0 min)10con trol file sequential read611.76
  CPU + Wait for C PU23.92
  db file paral lel write23.92
22:45:00 (1.6 min)2CPU + W ait for CPU23.92


Back to Top

End of Report 409 rows selected. SQL> spool off