ASH Report For SKINSTG/SKINSTG1

DB NameDB IdInstanceInst numReleaseRACHost
SKINSTG1860772457SKINSTG1110.2.0.4.0YESstage-rac01

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
41,536M (100%)848M (55.2%)560M (36.5%)8.0M (0.5%)

Sample TimeData Source
Analysis Begin Time:26-Mar-11 00:01:59V$ACTIVE_SESSION_HISTORY
Analysis End Time:27-Mar-11 23:59:59V$ACTIVE_SESSION_HISTORY
Elapsed Time: 2,878.0 (mins)  
Sample Count: 6,767 
Average Active Sessions: 0.04 
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% ActivityAvg Active Sessions
CPU + Wait for CPU CPU 4.97 0.00

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
control file sequential read System I/O 27.50 0.01
control file parallel write System I/O 18.94 0.01
Streams AQ: qmn coordinator waiting for slave to start Other 13.74 0.01
CPU + Wait for CPU CPU 13.70 0.01
reliable message Other 10.17 0.00

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 read 27.87 "0","35","1" 13.65 file# block# blocks
    "0","4","1" 6.80      
    "1","1","1" 1.92      
control file parallel write 19.00 "3","3","3" 18.94 files block# requests
reliable message 10.20 "2264808368","4753080968","2216368696" 1.15 channel context channel handle broadcast message
    "2264808368","4753080968","2216369680" 1.11      
    "2264808368","4753080968","2216370992" 1.11      
log file parallel write 1.54 "1","2","1" 0.52 files blocks requests
db file parallel write 1.43 "1","0","2147483647" 1.43 requests interrupt timeout

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$BACKGROUND UNNAMED 87.51 UNNAMED 87.51
  MMON_SLAVE 2.60 Auto-Flush Slave Action 1.37
      Remote-Flush Slave Action 1.17
SYS$USERS emagent@stage-rac01 (TNS V1-V3) 2.23 UNNAMED 2.23
  backup incr datafile 1.46 0000045 STARTED16 1.42
  DBMS_SCHEDULER 1.37 GATHER_STATS_JOB 0.86

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

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT 58 1.54 0.00

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
4gd6b1r53yt88   11.50 reliable message 9.93 ** SQL Text Not Available **

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 IdSQL Text
4gd6b1r53yt88** SQL Text Not Available **

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE#10 2.07 SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE#10 2.07


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
550, 1 22.96 control file sequential read 20.45 SYS oracle@stage-rac01 (LMON) 1,384/173K [ 1%] 0
    CPU + Wait for CPU 2.29     155/173K [ 0%] 0
544, 1 21.55 control file parallel write 18.94 SYS oracle@stage-rac01 (CKPT) 1,282/173K [ 1%] 0
    CPU + Wait for CPU 1.30     88/173K [ 0%] 0
    control file sequential read 1.27     86/173K [ 0%] 0
532, 9 13.95 Streams AQ: qmn coordinator waiting for slave to start 13.74 SYS oracle@stage-rac01 (QMNC) 930/173K [ 1%] 0
540, 1 11.50 reliable message 9.93 SYS oracle@stage-rac01 (MMON) 672/173K [ 0%] 0
1098, 5 4.06 control file sequential read 3.96 SYS oracle@stage-rac01 (ARC1) 268/173K [ 0%] 0

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
1102, 1 1.61 gcs log flush sync 0.84 SYS oracle@stage-rac01 (LGWR) 123/173K [ 0%] 0

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

File ID% ActivityEvent% EventFile NameTablespace
3 1.36 gc cr block busy 0.50 +DATA/skinstg/sysaux01.dbf SYSAUX

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 CountEventEvent Count% Event
00:01:59 (286.0 min) 801 control file sequential read 225 3.32
    CPU + Wait for CPU 166 2.45
    control file parallel write 101 1.49
04:48:00 (288.0 min) 843 control file sequential read 249 3.68
    control file parallel write 187 2.76
    CPU + Wait for CPU 118 1.74
09:36:00 (288.0 min) 629 control file sequential read 164 2.42
    control file parallel write 141 2.08
    CPU + Wait for CPU 121 1.79
14:24:00 (288.0 min) 622 control file sequential read 171 2.53
    control file parallel write 111 1.64
    reliable message 102 1.51
19:12:00 (288.0 min) 616 control file sequential read 153 2.26
    CPU + Wait for CPU 124 1.83
    control file parallel write 101 1.49
00:00:00 (288.0 min) 817 CPU + Wait for CPU 212 3.13
    control file sequential read 208 3.07
    control file parallel write 125 1.85
04:48:00 (288.0 min) 720 control file sequential read 232 3.43
    control file parallel write 187 2.76
    Streams AQ: qmn coordinator waiting for slave to start 92 1.36
09:36:00 (288.0 min) 569 control file sequential read 155 2.29
    control file parallel write 105 1.55
    CPU + Wait for CPU 104 1.54
14:24:00 (288.0 min) 523 control file sequential read 160 2.36
    control file parallel write 107 1.58
    Streams AQ: qmn coordinator waiting for slave to start 85 1.26
19:12:00 (288.0 min) 627 control file sequential read 169 2.50
    CPU + Wait for CPU 157 2.32
    control file parallel write 121 1.79


Back to Top

End of Report