ASH Report For BHDB/BHDB4

(1 Report Target Specified)

DB NameDB IdInstanceInst numReleaseRACHost
BHDB391220044BHDB4410.2.0.3.0YESacsdb803

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
815,472M (100%)12,000M (77.6%)1,672M (10.8%)M (%)

Sample TimeData Source
Analysis Begin Time:12-Feb-08 15:08:55DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 7419
Analysis End Time:12-Feb-08 15:38:55DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 7419
Elapsed Time: 30.0 (mins)  
Sample Count: 882 
Average Active Sessions: 4.90 
Avg. Active Session per CPU: 0.61 
Report Target:SQL_ID like 'cx476us09t8z2'40.5% of total database activity

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% ActivityAvg Active Sessions
enq: TX - row lock contention Application 99.43 4.87

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 99.43 "1415053316","17694744","226920" 34.69 name|mode usn<<16 | slot sequence
    "1415053316","1245215","1041198" 28.00      
    "1415053316","23134213","37506" 16.33      

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
BHDB.oracle.com EmailServiceInstance 100.00 es_access:expunge_folder 100.00

Back to Load Profile
Back to Top

Top Client IDs

Client ID% ActivityAvg Active SessionsUserProgramService
141.146.40.81:92479:1202857406761:1216167,0 18.14 0.89 OCS_CODE   BHDB.oracle.com
141.146.40.81:7083:1202857696977:2461864,0 17.35 0.85 OCS_CODE   BHDB.oracle.com
141.146.40.80:19553:1202857555357:2636671,0 13.83 0.68 OCS_CODE   BHDB.oracle.com
141.146.40.81:25611:1202857992120:2583449,0 12.93 0.63 OCS_CODE   BHDB.oracle.com
141.146.40.70:65207:1202857916314:1542699,0 10.77 0.53 OCS_CODE   BHDB.oracle.com

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
INSERT 1 100.00 4.90

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
cx476us09t8z2 2548684123 100.00 enq: TX - row lock contention 99.43 INSERT INTO ES_REMOVAL_HISTORY...

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
cx476us09t8z2INSERT INTO ES_REMOVAL_HISTORY (EID , PARENT_EID , CACHE_TS , CACHE_SQ, MESSAGE_UID) SELECT N.EID , N.PARENT_EID , N.CACHE_TS , N.CACHE_SQ, N.MESSAGE_UID FROM ES_INSTANCES N WHERE N.EID = :B1

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
OCS_CODE.ES_ACCESS.EXPUNGE_FOLDER 100.00 SQL 64.51
    OCS_CODE.ES_UTIL.RECORD_REMOVE 35.49


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
1733,16211 18.14 enq: TX - row lock contention 18.03 OCS_CODE   159/180 [ 88%] 14
1707, 3503 17.35 enq: TX - row lock contention 17.23 OCS_CODE   152/180 [ 84%] 17
1597, 7838 13.83 enq: TX - row lock contention 13.72 OCS_CODE   121/180 [ 67%] 15
1569,30154 12.93 enq: TX - row lock contention 12.81 OCS_CODE   113/180 [ 63%] 14
1625, 5658 10.77 enq: TX - row lock contention 10.66 OCS_CODE   94/180 [ 52%] 15

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
1597, 7838 16.33 enq: TX - row lock contention 16.33 OCS_CODE   179/180 [ 99%] 17
1625, 5658 9.18 enq: TX - row lock contention 9.18 OCS_CODE   161/180 [ 89%] 16
1733,16211 1.13 enq: TX - row lock contention 1.13 OCS_CODE   179/180 [ 99%] 18

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
228578 46.94 enq: TX - row lock contention 46.37 OCS_DATA.ES_REMOVAL_HISTORY$I_1.SYS_P9831 (INDEX PARTITION) OCS_INDEX
204032 9.41 enq: TX - row lock contention 9.41 OCS_DATA.ES_INSTANCES.SYS_P9073 (TABLE PARTITION) OCS_DATA
204035 6.69 enq: TX - row lock contention 6.69 OCS_DATA.ES_INSTANCES.SYS_P9076 (TABLE PARTITION) OCS_DATA
204033 3.85 enq: TX - row lock contention 3.85 OCS_DATA.ES_INSTANCES.SYS_P9074 (TABLE PARTITION) OCS_DATA
204034 3.85 enq: TX - row lock contention 3.85 OCS_DATA.ES_INSTANCES.SYS_P9075 (TABLE PARTITION) OCS_DATA

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
15:08:55 (1.1 min) 18 enq: TX - row lock contention 18 2.04
15:10:00 (5.0 min) 119 enq: TX - row lock contention 119 13.49
15:15:00 (5.0 min) 110 enq: TX - row lock contention 110 12.47
15:20:00 (5.0 min) 104 enq: TX - row lock contention 99 11.22
    gc buffer busy 4 0.45
    gc current block busy 1 0.11
15:25:00 (5.0 min) 117 enq: TX - row lock contention 117 13.27
15:30:00 (5.0 min) 270 enq: TX - row lock contention 270 30.61
15:35:00 (3.9 min) 144 enq: TX - row lock contention 144 16.33


Back to Top

End of Report