OraFAQ Forum: Client Tools » execute long time ( table lock )

Home » SQL & PL/SQL » Client Tools » execute long time ( table lock ) (oracle 7, pl/sql developper)

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

execute long time ( table lock ) [message #610416]

Wed, 19 March 2014 21:49

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

Report message to a moderator

Re: execute long time ( table lock ) [message #610417 is a reply to message #610416]

Wed, 19 March 2014 21:53

BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: execute long time ( table lock ) [message #610421 is a reply to message #610417]

Wed, 19 March 2014 22:24

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

Report message to a moderator

Re: execute long time ( table lock ) [message #610422 is a reply to message #610421]

Wed, 19 March 2014 22:31

BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: execute long time ( table lock ) [message #610429 is a reply to message #610421]

Thu, 20 March 2014 01:08

Michel Cadot
Messages: 67743
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.

Report message to a moderator

Re: execute long time ( table lock ) [message #610546 is a reply to message #610429]

Fri, 21 March 2014 02:49

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Oracle 7

Report message to a moderator

Previous Topic:	Time stored as a NUMBER field
Next Topic:	[oracle 10g]oracle connection problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 26 16:19:10 CST 2021