OraFAQ Forum: SQL & PL/SQL » Update lasting a very long and unasual time

Home » SQL & PL/SQL » SQL & PL/SQL » Update lasting a very long and unasual time

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

Update lasting a very long and unasual time [message #19051]

Wed, 27 February 2002 01:34

Cyrille
Messages: 2
Registered: February 2002

Junior Member

I've got an update query that's usually very quick (less than one min.) but today, this query didn't finished after 3 hours of elapse time, althought it was the same query.

Did somebody already have this problem? Can it be due to an Oracle pb?

Report message to a moderator

Re: Update lasting a very long and unasual time [message #19054 is a reply to message #19051]

Wed, 27 February 2002 01:52

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

the table on which the update statement is action on , may have been locked by some other user.check it out

Report message to a moderator

Re: Update lasting a very long and unasual time [message #19088 is a reply to message #19054]

Wed, 27 February 2002 23:12

slamt
Messages: 3
Registered: February 2002

Junior Member

loe nggak ada kerjaan (nganggur). kerja cuman ngejawab mail orang... norak loe

Report message to a moderator

Previous Topic:	how to create a table
Next Topic:	very urgent..help needed in simple select statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 19:46:09 CDT 2024