ASH Report For CAPGENT/capgent1

DB NameDB IdInstanceInst numReleaseRACHost
CAPGENT4127787440capgent1110.2.0.4.0YESrac1.capgent.com

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
43,840M (100%)3,088M (80.4%)704M (18.3%)8.0M (0.2%)

Sample TimeData Source
Analysis Begin Time:20-Jan-11 13:09:47V$ACTIVE_SESSION_HISTORY
Analysis End Time:20-Jan-11 13:14:47V$ACTIVE_SESSION_HISTORY
Elapsed Time: 5.0 (mins)  
Sample Count: 322 
Average Active Sessions: 1.07 
Avg. Active Session per CPU: 0.27 
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 96.58 1.04

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

No data exists for this section of the report.

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$USERS SQL*Plus 93.17 UNNAMED 93.17
capgent Realtime Connection 3.11 UNNAMED 3.11
SYS$BACKGROUND UNNAMED 1.24 UNNAMED 1.24
SYS$USERS OEM 1.24 UNNAMED 1.24

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 11 98.14 1.05

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
gsg9qq19qycas   93.17 CPU + Wait for CPU 93.17 select invtxn0_.IV_ID as col_0...

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
gsg9qq19qycas select invtxn0_.IV_ID as col_0_0_, invtxn0_.IV_DATE as col_1_0_ from NCO.INV_TXN invtxn0_ where (invtxn0_.IV_ID in ('3839889' , '3846839' , '3841399' , '3839886' , '3836759' , '3836765' , '3855754' , '3843404' , '3830272' , '3832301' , '3839882' , '3839880' , '3838280' , '3835335' , '3854234' , '3832299' , '3833980' , '3826943' , '3841400' , '3852297' , '3843405' , '3845066' , '3846837' , '3832300' , '3836757' , '3836758' , '3846834' , '3845064' , '3830273' , '3833982' , '3836763' , '3826944' , '3843406' , '3832302' , '3854233' , '3846835' , '3839881' , '3830269' , '3830268' , '3850670' , '3848789' , '3839885' , '3850668' , '3835338' , '3835337' , '3830265' , '3835336' , '3839884' , '3833981' , '3850669' , '3845065' , '3830270' , '3836764' , '3839877' , '3833983' , '3838281' , '3852296' , '3839887' , '3839878' , '3833978' , '3923221' , '3836762' , '3836761' , '3843407' , '3846841' , '3846840' , '3845063' , '3923220' , '3839883' , '3839890' , '3846836' , '3854232' , '3830271' , '3832303' , '3828560' , '3839879' , '3839888')) and (invtxn0_.IV_DATE in ('20-Feb-09' , '26-Feb-09' , '23-Feb-09' , '20-Feb-09' , '18-Feb-09' , '18-Feb-09' , '05-Mar-09' , '24-Feb-09' , '12-Feb-09' , '13-Feb-09' , '20-Feb-09' , '20-Feb-09' , '19-Feb-09' , '17-Feb-09' , '04-Mar-09' , '13-Feb-09' , '16-Feb-09' , '10-Feb-09' , '23-Feb-09' , '03-Mar-09' , '24-Feb-09' , '25-Feb-09' , '26-Feb-09' , '13-Feb-09' , '18-Feb-09' , '18-Feb-09' , '26-Feb-09' , '25-Feb-09' , '12-Feb-09' , '16-Feb-09' , '18-Feb-09' , '10-Feb-09' , '24-Feb-09' , '13-Feb-09' , '04-Mar-09' , '26-Feb-09' , '20-Feb-09' , '12-Feb-09' , '12-Feb-09' , '02-Mar-09' , '27-Feb-09' , '20-Feb-09' , '02-Mar-09' , '17-Feb-09' , '17-Feb-09' , '12-Feb-09' , '17-Feb-09' , '20-Feb-09' , '16-Feb-09' , '02-Mar-09' , '25-Feb-09' , '12-Feb-09' , '18-Feb-09' , '20-Feb-09' , '16-Feb-09' , '19-Feb-09' , '03-Mar-09' , '20-Feb-09' , '20-Feb-09' , '16-Feb-09' , '28-Apr-09' , '18-Feb-09' , '18-Feb-09' , '24-Feb-09' , '26-Feb-09' , '26-Feb-09' , '25-Feb-09' , '28-Apr-09' , '20-Feb-09' , '20-Feb-09' , '26-Feb-09' , '04-Mar-09' , '12-Feb-09' , '13-Feb-09' , '11-Feb-09' , '20-Feb-09' , '20-Feb-09'))

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

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
294, 13 93.17 CPU + Wait for CPU 93.17 SYSTEM sqlplus@rac1.c...m (TNS V1-V3) 300/300 [100%] 0
275, 532 1.24 db file scattered read 0.93 SYSTEM OMS 3/300 [ 1%] 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 CountEventEvent Count% Event
13:09:47 (13 secs) 16 CPU + Wait for CPU 14 4.35
    control file sequential read 1 0.31
    db file sequential read 1 0.31
13:10:00 (1.0 min) 64 CPU + Wait for CPU 62 19.25
    db file parallel write 1 0.31
    db file sequential read 1 0.31
13:11:00 (1.0 min) 63 CPU + Wait for CPU 60 18.63
    db file scattered read 3 0.93
13:12:00 (1.0 min) 64 CPU + Wait for CPU 62 19.25
    db file sequential read 1 0.31
    enq: PS - contention 1 0.31
13:13:00 (1.0 min) 63 CPU + Wait for CPU 62 19.25
    control file sequential read 1 0.31
13:14:00 (47 secs) 52 CPU + Wait for CPU 52 16.15


Back to Top

End of Report