Effective PL/SQL Code Insight With PL/Scope – or yet another reason to put code in the database
In this presentation I’ll show how we used Oracles
free PL/Scope to analyse 1.000.000 lines code base
to make informed and well working design decisions.
We also introduced a new logging framework and
started changing code, deploying changes live several
times a day.
Some things we rewrote from scratch. Other places
we replaced SQL-statements with calls to our low level
APIs, as well as re-instrumenting code and fixing old
bugs that suddenly were a lot more easy to identify.