OraFAQ Forum: Security » getover the lock on the table

Home » RDBMS Server » Security » getover the lock on the table

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

getover the lock on the table [message #285414]

Tue, 04 December 2007 07:50

kbalasmile
Messages: 1
Registered: December 2007
Location: india

Junior Member

currently i am working in oracle 10 g. I use stored procedures. If I run one procedure it's hanging then the whole session is terminated.i am not able to sort out this problem.could anyone help me out

Report message to a moderator

Re: getover the lock on the table [message #285415 is a reply to message #285414]

Tue, 04 December 2007 07:53

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Did you trace that session ?
Enable sql tracing and post here trace output.

Search SQL_TRACE for how to trace your session.
http://tahiti.oracle.com

Report message to a moderator

Re: getover the lock on the table [message #285418 is a reply to message #285414]

Tue, 04 December 2007 08:15

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why your title is "getover the lock on the table"?
Did you see any lock on table?
Also post your Oracle version with 4 decimals.

Regards
Michel

[Updated on: Tue, 04 December 2007 08:15]

Report message to a moderator

Previous Topic:	A question about ALTER User statement
Next Topic:	find user failed to connect to datadbse

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 05:42:00 CDT 2025