Locking
following is the content of my alert file,Iam getting often Calls from my clients complaining DB is hanging ,Everytime I have to look for Database locks and kill the session helding locks
Pls help me out of this problem
nmh1_diag_9494.trc
Wed Mar 24 14:49:51 2010
GES: Potential blocker (pid=1047) on resource TX-00170027-0000DFA4;
enqueue info in file /u01/oracle/admin/NMH/bdump/nmh1_lmd0_9500.trc and DIAG trace file
Wed Mar 24 15:11:36 2010
GES: Potential blocker (pid=1047) on resource TX-00170027-0000DFA4;
enqueue info in file /u01/oracle/admin/NMH/bdump/nmh1_lmd0_9500.trc and DIAG trace file
Wed Mar 24 16:00:10 2010