Database Administration (MOSC)

MOSC Banner

Locking

edited Mar 31, 2010 4:33AM in Database Administration (MOSC) 12 commentsAnswered
Dear Seniors

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center