Shulou(Shulou.com)06/01 Report--

After 12C, you can use the following statements:

ALTER SYSTEM CANCEL SQL 'SID, SERIAL;ALTER SYSTEM CANCEL SQL' SID, SERIAL, SQL_ID'; ALTER SYSTEM CANCEL SQL 'SID, SERIAL, @ INST_ID, SQL_ID'

Other versions can only be cancelled through kill session. However, in 11g, the session of another kill node supports the following syntax:

ALTER SYSTEM KILL SESSION 'SID, SERIAL, @ INST_ID'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.