Avatar of dbadm
Flag for Italy

asked on 

kill only one query in a session

I've Oracle Databases with various versions: 11g,, 18c, 19c

My clients often ask me to kill a query that is taking a long time and I kill the session with the following statement:
alter system kill session 'sid,serial#' immediate;

Is there a possibility kill only one SQL_ID instead of the session?

SQLOracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon