SQL & PL/SQL

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!

long time cancel process

846181Apr 5 2011 — edited Nov 11 2011

Hello expert,

I ran a complex sql for 30 minutes, without completing, I aborted it , a message window displayed as " Cancel pending, please wait ( This may take some time)". but till now , 1:21 hrs passed, no sign to stop, will you please tell me why this cancelling process takes some much time? what can I do to get rid of this long time cancel processing?

Many Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2011

Added on Apr 5 2011

#connection

3 comments

4,216 views