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!

killing sql query running on schema in background

DattatrayJan 21 2016 — edited Jan 22 2016

hello all,

this is my first post in oracle db.

we have one schema on which i ran one query which takes more 4 hrs.

accidentally another user had run same query on the same schema.

is there a way to kill any session or query running in background that is running on that schema ?

regards,

dattatray mate

This post has been answered by Nimish Garg on Jan 22 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2016

Added on Jan 21 2016

#11g, #pl-sql, #sql-developer

5 comments

1,665 views