Cause: While waiting to lock a library object, a timeout is occurred. Action: Action depends on the root cause. Based on the cause you can choose to kill the session or wait until the other process has finished and release the lock. How to find out why an ORA-4021 error occurs: In that example I have created a scenario where ORA-4021 error appear and show how to find out what causing the error.

WAITING SESSION

HOLDING SESSION

LOCK

ADDRESS

MODE_HELD

MODE_REQU

1529

410

Pin

0700010AA444F6D8

Share

Exclusive

— To check the blocked Session (Waiter)

— To check the Holding Session (Waiter)

Today’s thought 
“Keep your face always toward the sunshine—and shadows will fall behind you.” —Walt Whitman

Thank you for giving your valuable time to read the above information.

For More Detail , You can join us follow:

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Tagged:

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.