ASH Report For O102EE1/o102ee1

DB Name DB Id Instance Inst num Release RAC Host
O102EE1 2384218455 o102ee1 1 10.2.0.3.0 NO hpap0601

 

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size
4 256M (100%) 92M (35.9%) 156M (60.9%) 5.1M (2.0%)

 

  Sample Time Data Source
Analysis Begin Time: 06-2月 -07 17:20:18 V$ACTIVE_SESSION_HISTORY
Analysis End Time: 06-2月 -07 17:25:18 V$ACTIVE_SESSION_HISTORY
Elapsed Time: 5.0 (mins)  
Sample Count: 609  
Average Active Sessions: 2.03  
Avg. Active Session per CPU: 0.51  
Report Target: None specified  

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

Event Event Class % Activity Avg Active Sessions
CPU + Wait for CPU CPU 46.31 0.94
read by other session User I/O 41.38 0.84
db file scattered read User I/O 11.49 0.23

Back to Top Events
Back to Top

 

Top Background Events

No data exists for this section of the report.

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event % Event P1 Value, P2 Value, P3 Value % Activity Parameter 1 Parameter 2 Parameter 3
read by other session 41.38 "4","5899","1" 0.66 file# block# class#
db file scattered read 11.49 "4","4619","41" 0.33 file# block# blocks

Back to Top Events
Back to Top

 

Load Profile

Back to Top

Top Service/Module

Service Module % Activity Action % Action
SYS$USERS SQL*Plus 98.03 UNNAMED 98.03

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
SELECT 7 99.01 2.01

Back to Load Profile
Back to Top

 

Top SQL

Back to Top

Top SQL Statements

SQL ID Planhash % Activity Event % Event SQL Text
9a5wbppva8npu 3956160932 98.03 CPU + Wait for CPU 45.16 SELECT ENAME FROM EMP WHERE EM...
      read by other session 41.38  
      db file scattered read 11.49  

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

 

Complete List of SQL Text

SQL Id SQL Text
9a5wbppva8npu SELECT ENAME FROM EMP WHERE EMPNO = :num

Back to Top SQL
Back to Top

 

 

Top PL/SQL Procedures

No data exists for this section of the report.


Back to Top

 

Top Sessions

Back to Top

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
475,17630 49.10 CPU + Wait for CPU 24.14 SCOTT sqlplus@hpap0601 (TNS V1-V3) 147/300 [ 49%] 0
    read by other session 19.54     119/300 [ 40%] 0
    db file scattered read 5.42     33/300 [ 11%] 0
467,32202 48.93 read by other session 21.84 SCOTT sqlplus@hpap0601 (TNS V1-V3) 133/300 [ 44%] 0
    CPU + Wait for CPU 21.02     128/300 [ 43%] 0
    db file scattered read 6.08     37/300 [ 12%] 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

  • With respect to Application, Cluster, User I/O and buffer busy waits only.
Object ID % Activity Event % Event Object Name (Type) Tablespace
16095 52.87 read by other session 41.38 SCOTT.EMP (TABLE) USERS
    db file scattered read 11.49    

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

  • With respect to Cluster and User I/O events only.
File ID % Activity Event % Event File Name Tablespace
4 52.87 read by other session 41.38 /opt/app/oracle/oradata/o102ee1/users01.dbf USERS
    db file scattered read 11.49    

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

  • 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
17:20:18 (42 secs) 82 CPU + Wait for CPU 43 7.06
    read by other session 34 5.58
    db file scattered read 5 0.82
17:21:00 (1.0 min) 126 CPU + Wait for CPU 59 9.69
    read by other session 50 8.21
    db file scattered read 16 2.63
17:22:00 (1.0 min) 121 read by other session 54 8.87
    CPU + Wait for CPU 49 8.05
    db file scattered read 17 2.79
17:23:00 (1.0 min) 123 CPU + Wait for CPU 62 10.18
    read by other session 47 7.72
    db file scattered read 13 2.13
17:24:00 (1.0 min) 122 CPU + Wait for CPU 53 8.70
    read by other session 53 8.70
    db file scattered read 16 2.63
17:25:00 (18 secs) 35 CPU + Wait for CPU 17 2.79
    read by other session 14 2.30
    db file scattered read 3 0.49


Back to Top

 

End of Report