I’ve hit this problem a couple of times lately where a developer is trying to recompile a PL/SQL package and their session hangs until they eventually get this error: SQL> @new_pkg CREATE OR REPLACE PACKAGE BODY test_package * ERROR at line 1: ORA-04021: timeout occurred while waiting to lock object Basically, whilst someone or something else (a
The “Refresh From My Oracle Support” job in EM12c runs daily at 00:00 (midnight) by default. If the OMS host is under load at that time (backups etc.) then this can cause the refresh job to run past the 10 minutes StuckThreadMaxTime limit, which leads to a stuck thread being detected within WebLogic, and EM raising the
After moving to Oracle Enterprise Manager Cloud Control 12c, one of the annoyances I soon discovered was this message “The page has expired. Click OK to continue”. When you’re not actively using the console, it doesn’t take long before the message appears, which is especially annoying when you have the performance monitoring pages running in the background! According to Oracle it’s