Hi SQL Gurus,
I have a sql query which is taking too long to execute becasue of millions of data in database. I would like to identify and kill this sql query if it is taking more then 2 mins to execute.
Yes, we can identify the session and kill the session. But I dont want to kill session. I want to kill the particular SQL query in Oracle 9i.
Thanks in Advance.
Thanks
GK
I have a sql query which is taking too long to execute becasue of millions of data in database. I would like to identify and kill this sql query if it is taking more then 2 mins to execute.
Yes, we can identify the session and kill the session. But I dont want to kill session. I want to kill the particular SQL query in Oracle 9i.
Thanks in Advance.
Thanks
GK