OraFAQ Forum: Performance Tuning » a locking scenario

Home » RDBMS Server » Performance Tuning » a locking scenario (Generic)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

a locking scenario [message #350815]

Fri, 26 September 2008 08:57

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

There was a blocking scenario , blcoking session was inactive for long time(and donig nothing)but ws blocking another session.
Any idea why this happens ?

Following are details of the sessions.


501 was blocking 1059

SID:  501  SERIAL#: 38981  ORAUSER: user1  OSUSER:   STATUS: INACTIVE  FRGRND: 1234  PID: 2662634
KILL: 501,38981  LOGON: 09/26/2008 07:09:47 AM  IDLE ( Day:Hr:Min:Sec ) : 00:00:27:55
MACHINE:  TERMINAL: NULL  PROGRAM: NULL
DISK READS: NULL  BUFFER GETS: NULL  PARSE CALLS: NULL  EXECUTIONS: NULL
SQLTEXT: NULL
WAIT EVENT: SQL*Net message from client


SID:  1059  SERIAL#: 45737  ORAUSER: user1  OSUSER:   STATUS: ACTIVE  FRGRND: 1234  PID: 3289754
KILL: 1059,45737  LOGON: 09/26/2008 07:51:02 AM  IDLE ( Day:Hr:Min:Sec ) : 00:00:26:10
MACHINE:  TERMINAL: NULL  PROGRAM: NULL
DISK READS: 0  BUFFER GETS: 4771  PARSE CALLS: 7  EXECUTIONS: 6
SQLTEXT:   UPDATE mytable_data      SET currency_line_id = null    WHERE master_project_id = :1
WAIT EVENT: enq: TX - row lock contention

[Updated on: Fri, 26 September 2008 09:00]

Report message to a moderator