Home » SQL & PL/SQL » Client Tools » execute long time ( table lock ) (oracle 7, pl/sql developper)
execute long time ( table lock ) [message #610416] Wed, 19 March 2014 21:49 Go to next message
thanakrit_w
Messages: 2
Registered: March 2014
Location: Thailand
Junior Member
hi guy
i have a problem with pl/sql developper tool run as client
to oracle 7 ,linux base server .

i try to Test prcedure and it take long time.
so then i try to kill process but process marked as killed
but the target table still lock.
how can i resolve it? please help

please find attachedment

thank you
thankrit from thailand
Re: execute long time ( table lock ) [message #610417 is a reply to message #610416] Wed, 19 March 2014 21:53 Go to previous messageGo to next message
BlackSwan
Messages: 22908
Registered: January 2009
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

I'll make a blind guess since you provided NO useful details.

If your procedure does DML, then your symptoms can occur when no COMMIT is issued.
Re: execute long time ( table lock ) [message #610421 is a reply to message #610417] Wed, 19 March 2014 22:24 Go to previous messageGo to next message
thanakrit_w
Messages: 2
Registered: March 2014
Location: Thailand
Junior Member
Thank for. Guild BlackSwan
The error is :ORA-00031 mark as killed.
if not kill at os level only one way is waiting until that process is gone.
that only solutioin i found.
FYI
Re: execute long time ( table lock ) [message #610422 is a reply to message #610421] Wed, 19 March 2014 22:31 Go to previous messageGo to next message
BlackSwan
Messages: 22908
Registered: January 2009
Senior Member
The real solution is to avoid the problem in the first place.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: execute long time ( table lock ) [message #610429 is a reply to message #610421] Thu, 20 March 2014 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 59424
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Killing the OS process does not release the locks they are maintained until the rollback is completed, the only difference is that this is not the same process that does it.

Re: execute long time ( table lock ) [message #610546 is a reply to message #610429] Fri, 21 March 2014 02:49 Go to previous message
Roachcoach
Messages: 1219
Registered: May 2010
Location: UK
Senior Member
Oracle 7 Shocked
Previous Topic: Time stored as a NUMBER field
Next Topic: [oracle 10g] ora-27101 shared memory realm does not exist windows xp
Goto Forum:
  


Current Time: Fri Oct 24 02:59:52 CDT 2014

Total time taken to generate the page: 0.12533 seconds