To start with PL/SQL or SQL tuning the first step should be to identify the bottleneck in the whole code. Idetifying individual SQL queries that are giving problems is no difficult task.
But identifying some PL/SQL block can be a difficult job.
Database Notes
Excluding tables while using EXP in Oracle
Problem statement: How do we go about to exclude certain tables while using ‘exp’ in older versions of Oracle. Solution: Although there is no option of using the EXCLUDE option in older versions of Oracle as we have in newer versions of Oracle (9i and above), the below mentioned trick might work Run this query … Read more