When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user?
1. DBWn
2. LGWR
3. SMON
4. PMON
Answer 4 - PMON, the Process MONitor is responsible for clearing up the failed user processes. It reclaims all the resources held by the user and releases all locks on tables and rows held by the user.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment