In a customer database with version 19c. We saw a sudden spike in concurrency waits(mainly library cache lock. It was there for ~10 minutes and things were in hung state. Multiple queries were experiencing library cache related locks. The output from Tanel's dash_top and dash wait_chain is showing those too , below is the output from same. Seeing few calls from OAUTH and LOGOFF top_level_call_name which points towards authorization kind of stuff. And also Memory: Reg/Dereg operation. Want to understand the cause of this. Has anybody encountered such pattern?
Dash_wait_chain_top.xlsx (10.31 KB)
