Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Process still active after killing session!

movilogoMay 21 2009 — edited May 23 2009

I was running an update statement on a huge table (150 million rows) via SqlPlus (Oracle 10g)

However, I discovered that particular key doesn't have index, so I cancelled the query by just closing the SQL Plus and then killing the session via TOAD (not right method but anyway).

Now I see that session is still active - even if it is marked as KILLED in TOAD.

I can't create index as I'm getting resource busy on the table!!

How I can really kill the session - ie stop the update statement from running as ghost?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 20 2009

Added on May 21 2009

#general-database-discussions

5 comments

1,770 views