Home » RDBMS Server » Performance Tuning » a locking scenario (Generic)
a locking scenario [message #350815] Fri, 26 September 2008 08:57 Go to next message
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

Re: a locking scenario [message #350828 is a reply to message #350815] Fri, 26 September 2008 10:14 Go to previous message
Alessandro Rossi
Messages: 166
Registered: September 2008
Location: Rome
Senior Member
Changes must be committed or rolled back to release locks on involved resources.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/consist.htm#sthref2026

Bye Alessandro

Previous Topic: SQL execution time based on ash history
Next Topic: Two 30 million records tables join query needs tuning
Goto Forum:
  


Current Time: Fri Dec 09 17:13:15 CST 2016

Total time taken to generate the page: 0.34980 seconds