ASH Report For SUSASTG/SUSASTG2

DB NameDB IdInstanceInst numReleaseRACHost
SUSASTG2407826999SUSASTG2211.1.0.7.0YESstage-rac02

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
42,039M (100%)672M (33.0%)656M (32.2%)8.0M (0.4%)

Sample TimeData Source
Analysis Begin Time:07-Dec-10 12:30:28V$ACTIVE_SESSION_HISTORY
Analysis End Time:07-Dec-10 14:30:28V$ACTIVE_SESSION_HISTORY
Elapsed Time: 120.0 (mins)  
Sample Count: 632 
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 StatsOther20.890.02
reliable messageOther15.190.01
CPU + Wait for CPUCPU7.750.01
log file syncCommit4.110.00
control file sequential readSystem I/O1.580.00

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPUCPU23.100.02
control file sequential readSystem I/O12.180.01
control file parallel writeSystem I/O3.320.00
ASM file metadata operationOther2.690.00
log file parallel writeSystem I/O2.690.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
PX Deq: Slave Session Stats20.89"268632063","1","0"12.18 sleeptime/senderidpassesNOT DEFINED
reliable message15.98"2760167032","3717508896","2761025992"2.69 channel contextchannel handlebroadcast message
  "2760167032","3717508896","2761027528"2.22    
  "2760167032","3717508896","2761027144"1.74    
control file sequential read13.77"0","35","1"8.07 file#block#blocks
  "0","1","1"2.37    
  "0","3","1"2.06    
log file sync4.11"3410","0","0"1.74 buffer#NOT DEFINEDNOT DEFINED
control file parallel write3.32"3","4","3"3.32 filesblock#requests

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$BACKGROUNDUNNAMED45.41UNNAMED45.41
SYS$USERSracgimon@stage-rac02 (TNS V1-V3)28.96UNNAMED28.96
 racgimon@stage-rac01 (TNS V1-V3)6.80UNNAMED6.80
 UNNAMED5.54UNNAMED5.54
SUSASTGUNNAMED4.43UNNAMED4.43

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
SELECT199.180.01
PL/SQL EXECUTE42.060.00
INSERT31.110.00

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution23.730.02
PLSQL Execution1.580.00

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
7frqszzdu8sgg4109302118234.91 reliable message3.01PX COORDINATOR3.01 select DECODE(UPPER(d.OPEN_MOD...
     control file sequential read1.58FIXED TABLE - FULL1.42

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
7frqszzdu8sgg4109302118234.91 PX COORDINATOR3.16reliable message3.01 select DECODE(UPPER(d.OPEN_MOD...
     FIXED TABLE - FULL1.42control file sequential read1.42

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

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
SYSMAN.EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS3.32 SQL1.90


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
537, 316.61reliable message14.56 SYSracgimon@stage...2 (TNS V1-V3)92/7,200 [ 1%]0
  control file sequential read1.58   10/7,200 [ 0%]0
1086, 112.82CPU + Wait for CPU10.13 SYSoracle@stage-rac02 (ASMB)64/7,200 [ 1%]0
  ASM file metadata operation2.69   17/7,200 [ 0%]0
1096, 110.44control file sequential read10.13 SYSoracle@stage-rac02 (LMON)64/7,200 [ 1%]0
1097, 15.38CPU + Wait for CPU5.38 SYSoracle@stage-rac02 (DIA0)34/7,200 [ 0%]0
1090, 14.27control file parallel write3.32 SYSoracle@stage-rac02 (CKPT)21/7,200 [ 0%]0

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
1091, 1( 2)4.75log file sync4.11 SYSoracle@stage-rac02 (LGWR)17/7,200 [ 0%]0

Back to Top Sessions
Back to Top

Top Sessions running PQs

Sid,Srl# (Inst)% ActivitySQL IDEvent% EventUserProgramSQL Text
537, 3(2)27.06 PX Deq: Slave Session Stats11.55 SYSracgimon@stage...2 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
   reliable message11.55 SYSracgimon@stage...2 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
  7frqszzdu8sggreliable message3.01 SYSracgimon@stage...2 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
1094, 8(1)6.96 PX Deq: Slave Session Stats6.49 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
12:30:28 (5.5 min)36CPU + Wait for CPU203.16
  reliable message60.95
  control file sequential read30.47
12:36:00 (12.0 min)69CPU + Wait for CPU213.32
  PX Deq: Slave Session Stats152.37
  control file sequential read101.58
12:48:00 (12.0 min)43CPU + Wait for CPU152.37
  PX Deq: Slave Session Stats101.58
  control file sequential read101.58
13:00:00 (12.0 min)71CPU + Wait for CPU274.27
  PX Deq: Slave Session Stats121.90
  reliable message111.74
13:12:00 (12.0 min)91control file sequential read193.01
  log file sync162.53
  CPU + Wait for CPU142.22
13:24:00 (12.0 min)62CPU + Wait for CPU142.22
  PX Deq: Slave Session Stats111.74
  control file sequential read101.58
13:36:00 (12.0 min)59CPU + Wait for CPU223.48
  PX Deq: Slave Session Stats121.90
  reliable message111.74
13:48:00 (12.0 min)71PX Deq: Slave Session Stats253.96
  reliable message203.16
  CPU + Wait for CPU172.69
14:00:00 (12.0 min)52CPU + Wait for CPU132.06
  PX Deq: Slave Session Stats132.06
  reliable message121.90
14:12:00 (12.0 min)49CPU + Wait for CPU203.16
  PX Deq: Slave Session Stats101.58
  control file sequential read81.27
14:24:00 (6.5 min)29CPU + Wait for CPU121.90
  PX Deq: Slave Session Stats81.27
  control file sequential read40.63


Back to Top

End of Report