Subject query refuses to die
Author Nick Upson
Hi,

(running 2.1.5 on centos) I tried to kill a exceptionally long-running
query (several hours) by deleting the row from MON$STATEMENT, no errors
but it didn't delete. I was connected via isql as sysdba, the query wasn't
using sysdba

select * from

MON$STATEMENTS where MON$STATEMENT_ID = 30;

showed the query, then I did

SQL> delete from

MON$STATEMENTS where MON$STATEMENT_ID = 30;
SQL> commit;

select * from

MON$STATEMENTS where MON$STATEMENT_ID = 30;

and it was still there, disconnected and connected again, still there.

Should I have done something different, how can I ensure this works in
future?


--
Nick Upson, Telensa Ltd


[Non-text portions of this message have been removed]