CODEWITHSUNDEEP
oracle-databasesqlplus
kumarprd
kumarprd

Reputation: 936

Oracle hangs while updating table

I am updating a table with statement

update asdf123 
   set state='Rlzd' 
 where documentname = '11212121212' 
   and superseded = '-';

But it hangs indefinitely.

I checked the session, got a hanged session, then killed it and the above session was killed. Again same situation happens.

What could be the reason?

Upvotes: 4

Views: 4835

Answers (1)

Florin Ghita
Florin Ghita

Reputation: 17643

I guess you killed the blocked session(your session) Use something like this to find blocking session:

SELECT
   s.blocking_session, 
   s.sid, 
   s.serial#, 
   s.seconds_in_wait
FROM
   v$session s
WHERE
   blocking_session IS NOT NULL

See another ways to find them: http://www.oraclerecipes.com/monitoring/find-blocking-sessions/

Upvotes: 4

Related Questions