Skip to Main Content

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 long running SQL query

574580Apr 26 2007 — edited Apr 27 2007
Hello Guru's,
Need your guidance. I am using ASP.NET as front end and trying to execute SQL query which is taking too long to execute because of large amount of data in the base table.
If I use the STOP button from browser it stop the operation but in the Oracle engine the query still runs. Is there any way to identify this query in oracle and kill

Right now I am using DBMS_APPLICATION_INFO package to update module, client and action fields of v$session dynamic view before running the query. I am using above 3 mentioned fields to identify the query and kill the session using sid and serial#. But using this approach my oracle session is getting expired and I am getting message NOT CONNECTED TO ORACLE.

Am I using the right approach....? please put some light on it.

Thanks in advance
GK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2007
Added on Apr 26 2007
12 comments
3,961 views