OraFAQ Forum: Security » How To Know Which Session Causing A TX Lock

Home » RDBMS Server » Security » How To Know Which Session Causing A TX Lock (Windows XP, Oracle 11g)

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

How To Know Which Session Causing A TX Lock [message #496481]

Mon, 28 February 2011 09:32

oraQ
Messages: 57
Registered: January 2011

Member

I have to find out the cause of a lock where a particular session with some serial no is causing a TX level lock for certain duration. Can anyone guide me in that? Thanks in advance.

Report message to a moderator

[Message index]

		How To Know Which Session Causing A TX Lock By: oraQ on Mon, 28 February 2011 09:32
		Re: How To Know Which Session Causing A TX Lock By: BlackSwan on Mon, 28 February 2011 09:33
		Re: How To Know Which Session Causing A TX Lock By: oraQ on Mon, 28 February 2011 09:55
		Re: How To Know Which Session Causing A TX Lock By: BlackSwan on Mon, 28 February 2011 09:56
		Re: How To Know Which Session Causing A TX Lock By: Michel Cadot on Mon, 28 February 2011 09:58
		Re: How To Know Which Session Causing A TX Lock By: John Watson on Mon, 28 February 2011 10:29
		Re: How To Know Which Session Causing A TX Lock By: oraQ on Mon, 28 February 2011 10:36
		Re: How To Know Which Session Causing A TX Lock By: BlackSwan on Mon, 28 February 2011 10:38
		Re: How To Know Which Session Causing A TX Lock By: oraQ on Mon, 28 February 2011 10:45
		Re: How To Know Which Session Causing A TX Lock By: BlackSwan on Mon, 28 February 2011 10:51
		Re: How To Know Which Session Causing A TX Lock By: oraQ on Mon, 28 February 2011 10:55
		Re: How To Know Which Session Causing A TX Lock By: Michel Cadot on Mon, 28 February 2011 11:12
		Re: How To Know Which Session Causing A TX Lock By: cookiemonster on Mon, 28 February 2011 11:13
		Re: How To Know Which Session Causing A TX Lock By: oraQ on Mon, 28 February 2011 11:20
		Re: How To Know Which Session Causing A TX Lock By: Michel Cadot on Mon, 28 February 2011 11:27
		Re: How To Know Which Session Causing A TX Lock By: BlackSwan on Mon, 28 February 2011 11:31
		Re: How To Know Which Session Causing A TX Lock By: oraQ on Tue, 01 March 2011 07:53
		Re: How To Know Which Session Causing A TX Lock By: Michel Cadot on Mon, 28 February 2011 10:45

Previous Topic:	Query Regarding AUDIT_TRAIL
Next Topic:	send oracle auditing to syslog

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:34:08 CDT 2024