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

Oracle University Istanbul Expert Summit 2014

We had greate 3 days with the experts in their field. Pete Finnigan with great focus on Security. Database design according to the security principles. He also mentioned encryption, leakage of critical data, dangerous functions and use of incorrect privileges. Jonathan Lewis gave tons of examples from simple ones to complex ones and show how to… Continue reading Oracle University Istanbul Expert Summit 2014