ASH Report For HLT1/hlt11

DB NameDB IdInstanceInst numReleaseRACHost
HLT14015448600hlt11110.2.0.5.0YESprod-rac21.wp.cl.datapipe.net

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
1624,576M (100%)22,624M (92.1%)1,669M (6.8%)29.0M (0.1%)

Sample TimeData Source
Analysis Begin Time:06-Jun-11 11:00:14DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 28009
Analysis End Time:06-Jun-11 13:00:14DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 28010
+ V$ACTIVE_SESSION_HISTORY
Elapsed Time: 120.0 (mins)  
Sample Count: 28,427 
Average Active Sessions: 39.48 
Avg. Active Session per CPU: 2.47 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% ActivityAvg Active Sessions
enq: TX - row lock contention Application 79.98 31.58
gc buffer busy Cluster 5.43 2.14
log file sync Commit 2.84 1.12
enq: TX - index contention Concurrency 2.29 0.90
gc current block busy Cluster 1.84 0.73

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% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
enq: TX - row lock contention 79.98 "1415053318","17694721","8540" 2.33 name|mode usn<<16 | slot sequence
    "1415053318","10223645","7215" 1.63      
    "1415053318","11599907","10314" 1.59      
gc buffer busy 5.43 "9","2250270","65537" 0.92 file# block# id#
log file sync 2.84 "29","3624154874","0" 0.00 buffer# sync scn NOT DEFINED
enq: TX - index contention 2.29 "1415053316","4128773","858744" 0.16 name|mode usn<<16 | slot sequence
db file sequential read 1.43 "202","2","1" 0.01 file# block# blocks

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
hlt1 JDBC Thin Client 97.71 UNNAMED 97.71
SYS$BACKGROUND UNNAMED 2.03 UNNAMED 2.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

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT 62 45.26 17.87
UPDATE 197 40.57 16.02
INSERT 27 9.13 3.60

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
7bd3r84urtm8u 607575284 42.53 enq: TX - row lock contention 42.27 select LASTSEQID from ParticID...
cpw5amz5aa8hy 1780642097 38.07 enq: TX - row lock contention 37.71 update Authorization set curco...
7j4jahj2b0n0w   2.42 gc buffer busy 1.03 insert into SystemLog ( Result...
9k6466qth49pj   1.86 enq: TX - index contention 0.64 insert into Episodes (Particip...
db7qh8puap919   1.41 gc buffer busy 0.56 insert into MessageQueue (msgi...

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
7bd3r84urtm8uselect LASTSEQID from ParticIDKeeper for update
7j4jahj2b0n0winsert into SystemLog ( ResultDT , JobCD, ParticipantID, EpisodeID, ResultCD, ResulTX) values (:1, :2, :3, :4, :5, :6)
9k6466qth49pjinsert into Episodes (ParticipantID, EpisodeID, instrumentCD, instrumentversion, projectcd, enrollmethodcd, EnrollDate, lmptype, etestdata, authcd, distcd, custcd, customercd, reportflag) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)
cpw5amz5aa8hyupdate Authorization set curcount = curcount+:"SYS_B_0" where authcd = :1
db7qh8puap919insert into MessageQueue (msgid, msgtype, instrumentCD, episodeID, participantID, tailored, expirydt, senddt) values ( :1, :2, :3, :4, :5, :6, :7, :8)

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

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
2191, 1 3.35 log file sync 2.84 SYS oracle@prod-ra...pe.net (LGWR) 175/720 [ 24%] 0
1772, 38 1.66 enq: TX - row lock contention 1.66 HBASE JDBC Thin Client 60/720 [ 8%] 5
1448, 1310 1.47 enq: TX - row lock contention 1.47 HBASE JDBC Thin Client 27/720 [ 4%] 5
1851, 876 1.47 enq: TX - row lock contention 1.47 HBASE JDBC Thin Client 61/720 [ 8%] 3
1899, 7381 1.40 enq: TX - row lock contention 1.40 HBASE JDBC Thin Client 63/720 [ 9%] 4

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

Object ID% ActivityEvent% EventObject Name (Type)Tablespace
81183 42.52 enq: TX - row lock contention 42.27 VHBA.PARTICIDKEEPER (TABLE) VHBA
80572 38.92 enq: TX - row lock contention 37.71 VHBA.AUTHORIZATION (TABLE) VHBA
    gc buffer busy 1.00    
81456 1.28 gc buffer busy 0.88 VHBA.RESULTDT_IDX (INDEX) VHBALARGE

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
77 2.99 gc buffer busy 1.55 +ORAFILES/hlt1/datafile/vhbalarge_idx.321.752295631 VHBALARGE_IDX
76 1.67 gc buffer busy 0.92 +ORAFILES/hlt1/datafile/vhbalarge.323.752293355 VHBALARGE
9 1.55 gc buffer busy 1.19 +ORAFILES/hlt1/datafile/vhba.413.752293323 VHBA
7 1.21 gc buffer busy 0.91 +ORAFILES/hlt1/datafile/vhbalarge_idx.551.752293313 VHBALARGE_IDX

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
11:00:14 (9.8 min) 56 log file sync 18 0.06
    CPU + Wait for CPU 11 0.04
    db file sequential read 5 0.02
11:10:00 (10.0 min) 320 log file sync 72 0.25
    CPU + Wait for CPU 50 0.18
    db file sequential read 37 0.13
11:20:00 (10.0 min) 1,183 enq: TX - row lock contention 386 1.36
    log file sync 196 0.69
    gc buffer busy 107 0.38
11:30:00 (10.0 min) 17,442 enq: TX - row lock contention 15,112 53.16
    gc buffer busy 803 2.82
    enq: TX - index contention 309 1.09
11:40:00 (10.0 min) 6,330 enq: TX - row lock contention 5,412 19.04
    gc buffer busy 293 1.03
    enq: TX - index contention 161 0.57
11:50:00 (10.0 min) 1,271 enq: TX - row lock contention 294 1.03
    gc buffer busy 265 0.93
    log file sync 117 0.41
12:00:00 (10.0 min) 1,804 enq: TX - row lock contention 1,531 5.39
    log file sync 49 0.17
    gc buffer busy 43 0.15
12:10:00 (10.0 min) 10 CPU + Wait for CPU 3 0.01
    control file sequential read 3 0.01
    db file sequential read 3 0.01
12:20:00 (10.0 min) 3 CPU + Wait for CPU 1 0.00
    control file sequential read 1 0.00
    db file sequential read 1 0.00
12:30:00 (10.0 min) 4 CPU + Wait for CPU 2 0.01
    control file sequential read 2 0.01
12:40:00 (10.0 min) 3 Streams AQ: qmn coordinator waiting for slave to start 1 0.00
    gc current block busy 1 0.00
    row cache lock 1 0.00
12:50:00 (10.0 min) 1 control file parallel write 1 0.00


Back to Top

End of Report