Oracle · PL/SQL - SQL

Stored Procedure Dependency May Crash Your Database

DDL operations on your production may cripple your system. It is an all known fact. Especially when a Stored Procedure (SP), that has a dependency on that object, is heavily used. Most probably you can not compile it and you will have a lot of library cache pin, library cache lock … events. This post… Continue reading Stored Procedure Dependency May Crash Your Database

Oracle · PL/SQL - SQL

ORA-4068 Errors for Valid Objects

Compilation of oracle objects are pretty easy where there is no activity on the database. If the objects are heavily accessed and the compilation takes place then you should be prepared for the worst case scenarios.Depending on the object dependency and access rates, sometimes downtime is required. Offline the system and compile the objects and… Continue reading ORA-4068 Errors for Valid Objects