Home » RDBMS Server » Security » getover the lock on the table
getover the lock on the table [message #285414] Tue, 04 December 2007 07:50 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68785
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 21 09:58:58 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.