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
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

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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Mar 28 06:40:56 CDT 2024