Some advanced topics of PL/SQL – using RETURNING INTO clause, BULK Transactions and much more…..
Oracle Performance Tuning is one of least followed up but critical aspects of the database.
In this presentation, we share what Oracle say about performance tuning. Excerpts from Oracle documentation have been presented with SQL based examples.
Analytical functions and queries are next level of data selection methods for cases where requirement of selection criteria is no so simple or straight. Let’s have a glimpse.
Continue reading →
How to implement SPM – SQL Plan Baseline Management?
SPM is one of the methods of SQL Plan Control available in Oracle 11g. It allows SQL plans to change only when new plans are guaranteed to perform better than existing plans.
yet to blog