library cache lock

“library cache lock” waits from many concurrent DBMS_JOB.submit() operations

I have faced performance issue on one of production database in banking environment. From AWR report I found that “library cache lock” as the top wait event. Database has spent 68.95% of database time waiting on this wait event. By