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]