ora-31

[snayak]

Hi All,

Wondering anyone has faced this issue. A query which usually completes in 2hours, but when interupted like alter system kill session or closing the sqlplus i.e rebooting my client, the v$session status field shows KILLED i.e. I get message as ora-31 marked for kill. This never changes until I kill the OS process. There are no locks nor rollbacks as can see from v$locked_object,v$locks,V$transactions no records found. OS truss also shows nothing.

I tried DCD everything . Please help, if anyone has encountered this weird situation & how to solve this other than killing the OS process. Appreciate your help.

Regards

 

[sem]

Just wait! In fact your long-running query does write to rollback segment to provide read-consistency. But in this case killing a proceess IMO is also quite safe.

Regards, Dima

http://seminihin.narod.ru

 

[snayak]

Hi Dima,

Actually the session keeps running for more than 2 days if not for killing the OS process, I have never seen the session coming out from that spin.

Thanks,
Regards.