DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PMON not release lock

  1. #1
    Join Date
    Oct 2000
    Posts
    250

    Smile

    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!

  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width