TOP 5 WAIT EVENT
ReposSep 14 2009 — edited Sep 15 2009Hi
have the following configuration
Oracle 10 g r2 , Red hat Linux 5 , RAC
From AWR Report i saw the following wait events
if i check this event -- enq: TX - row lock contention
using sql , one event is -- sysman -- oms
and other is --oracle@ora (J003)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 13,283 40.8
db file scattered read 3,434,917 5,769 2 17.7 User I/O
enq: TX - row lock contention 9,846 4,809 488 14.8 Application
db file sequential read 3,664,522 4,528 1 13.9 User I/O
gc cr multi block request3 3,151,754 1,025 0 3.1 Cluster
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
why this enq: TX - row lock contention having lock for sysman & backround process
is this will impact the Database performance
rds
Edited by: user1000000 on Sep 14, 2009 7:54 AM