Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Killed oracle session still showing in OEM

user5716448Oct 2 2019 — edited Oct 3 2019

Hi,

10.2.0.4.

User had long running refresh of mv which killed and then dba issued alter session kill (sid,serail#)

Process still shows in OEM hours later and concern is we get lack of undo tablespace meassage again due to this if not 'rolledback in time before next overnight processing starts.

Can/it it safe to kill at operating system level?

What is best way to ensure this process is fully extinct?

Thanks

This post has been answered by L. Fernigrini on Oct 2 2019
Jump to Answer
Comments
Post Details
Added on Oct 2 2019
7 comments
491 views