ASH Report For SUSASTG/SUSASTG1

DB NameDB IdInstanceInst numReleaseRACHost
SUSASTG2407826999SUSASTG1111.1.0.7.0YESstage-rac01

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
42,039M (100%)432M (21.2%)784M (38.5%)8.0M (0.4%)

Sample TimeData Source
Analysis Begin Time:03-Dec-10 05:00:32V$ACTIVE_SESSION_HISTORY
Analysis End Time:03-Dec-10 07:00:32V$ACTIVE_SESSION_HISTORY
Elapsed Time: 120.0 (mins)  
Sample Count: 669 
Average Active Sessions: 0.09 
Avg. Active Session per CPU: 0.02 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
PX Deq: Slave Session StatsOther14.950.01
reliable messageOther9.120.01
CPU + Wait for CPUCPU3.590.00
control file sequential readSystem I/O2.690.00
log file syncCommit2.390.00

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPUCPU31.240.03
control file sequential readSystem I/O14.200.01
control file parallel writeSystem I/O9.870.01
RMAN backup & recovery I/OSystem I/O2.390.00
log file parallel writeSystem I/O2.390.00

Back to Top Events
Back to Top

Top Cluster Events

No data exists for this section of the report.

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 read16.89"0","35","1"6.58 file#block#blocks
  "0","4","1"3.89    
  "0","1","1"2.09    
PX Deq: Slave Session Stats14.95"268566527","1","0"6.73 sleeptime/senderidpassesNOT DEFINED
control file parallel write9.87"3","3","3"9.87 filesblock#requests
reliable message9.72"2961493624","3348354712","2962353352"2.09 channel contextchannel handlebroadcast message
  "2961493624","3348354712","2962352968"1.49    
  "2961493624","3348354712","2962351432"1.05    
RMAN backup & recovery I/O2.39"1","32","2147483647"2.24 countintrtimeout

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$BACKGROUNDUNNAMED56.95UNNAMED56.95
SYS$USERSracgimon@stage-rac01 (TNS V1-V3)20.48UNNAMED20.48
 racgimon@stage-rac02 (TNS V1-V3)8.07UNNAMED8.07
 backup archivelog5.530000058 STARTED165.23
SUSASTGUNNAMED3.14UNNAMED3.14

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
SELECT96.430.01

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution15.250.01

Back to Load Profile
Back to Top

Top Remote Instances

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL with Top Events

SQL IDPlanhashSampled # of Executions% ActivityEvent% EventTop Row Source% RwSrcSQL Text
7frqszzdu8sgg4109302118244.93 control file sequential read2.39FIXED TABLE - FULL1.64 select DECODE(UPPER(d.OPEN_MOD...
     reliable message2.24PX COORDINATOR2.24
9jmd3y1tnxy9n 01.49 CPU + Wait for CPU1.35** Row Source Not Available **1.35 ** SQL Text Not Available **

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
7frqszzdu8sgg4109302118244.93 PX COORDINATOR2.24reliable message2.24 select DECODE(UPPER(d.OPEN_MOD...
     FIXED TABLE - FULL1.79control file sequential read1.64
9jmd3y1tnxy9n 01.49 ** Row Source Not Available **1.49CPU + Wait for CPU1.35 ** 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

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
7frqszzdu8sggselect DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
9jmd3y1tnxy9n** 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#125.23 SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE#125.23
SYSMAN.EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS1.05 SQL0.75


Back to Top

Top Java Workload

No data exists for this section of the report.


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
1094, 811.96reliable message9.12 SYSracgimon@stage...1 (TNS V1-V3)61/7,200 [ 1%]0
  control file sequential read2.39   16/7,200 [ 0%]0
544, 111.81control file sequential read10.46 SYSoracle@stage-rac01 (LMON)70/7,200 [ 1%]0
  CPU + Wait for CPU1.35   9/7,200 [ 0%]0
537, 111.66control file parallel write9.87 SYSoracle@stage-rac01 (CKPT)66/7,200 [ 1%]0
533, 110.16CPU + Wait for CPU9.27 SYSoracle@stage-rac01 (ASMB)62/7,200 [ 1%]0
545, 16.73CPU + Wait for CPU6.73 SYSoracle@stage-rac01 (DIA0)45/7,200 [ 1%]0

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
1102, 1( 1)2.84log file sync2.39 SYSoracle@stage-rac01 (LGWR)18/7,200 [ 0%]0

Back to Top Sessions
Back to Top

Top Sessions running PQs

Sid,Srl# (Inst)% ActivitySQL IDEvent% EventUserProgramSQL Text
1094, 8(1)17.19 PX Deq: Slave Session Stats7.03 SYSracgimon@stage...1 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
   reliable message6.88 SYSracgimon@stage...1 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
  7frqszzdu8sggreliable message2.24 SYSracgimon@stage...1 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
537, 3(2)8.22 PX Deq: Slave Session Stats7.62 UserID:   

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 CountEventEvent Count% Event
05:00:32 (11.5 min)82CPU + Wait for CPU324.78
  RMAN backup & recovery I/O162.39
  control file sequential read142.09
05:12:00 (12.0 min)66CPU + Wait for CPU192.84
  PX Deq: Slave Session Stats182.69
  reliable message121.79
05:24:00 (12.0 min)48CPU + Wait for CPU223.29
  PX Deq: Slave Session Stats81.20
  control file sequential read71.05
05:36:00 (12.0 min)58CPU + Wait for CPU182.69
  control file sequential read101.49
  reliable message91.35
05:48:00 (12.0 min)72CPU + Wait for CPU284.19
  PX Deq: Slave Session Stats111.64
  log file parallel write60.90
06:00:00 (12.0 min)87CPU + Wait for CPU233.44
  control file parallel write213.14
  control file sequential read172.54
06:12:00 (12.0 min)70CPU + Wait for CPU253.74
  control file parallel write152.24
  control file sequential read131.94
06:24:00 (12.0 min)55CPU + Wait for CPU172.54
  PX Deq: Slave Session Stats142.09
  control file sequential read81.20
06:36:00 (12.0 min)57CPU + Wait for CPU182.69
  PX Deq: Slave Session Stats121.79
  control file sequential read111.64
06:48:00 (12.0 min)64CPU + Wait for CPU274.04
  control file sequential read152.24
  PX Deq: Slave Session Stats91.35
07:00:00 (32 secs)10CPU + Wait for CPU40.60
  control file sequential read20.30
  ASM file metadata operation10.15


Back to Top

End of Report