-
Hi,
Is anybody know how to 'wake up' the PMON as it seems 'sleeping' until doesn't know release the lock ? I am using the Oracle 8.1.6.1.4 standard edition running on Windows 2000 Server platform.
I have to find out the id and kill the process everytime encounter the locking issue.
Your help is very much appreciated.
Thanks and have a nice day!
-
Killing a session you can get a message "session marked for kill". If the session did some update/insert/delete operations oracle has to rollback the transaction. It takes time to rollback large transactions.
Sergey.
