Pl/sql package procedure reivew/tuning
Posted on 2013-05-30
DB: Oracle 11gR2
Hi, need some assistance, how one can review/tune a 500 lines pl/sql package, have already tried DBMS_PROFILER, but not good, also able to tune each and every sql within the package too, all the sql looks good, but when executed within this 500 lines package, taking more time then expected.
Is there any way to review/tune this whole package, what exactly it is doing and where exactly is the bottleneck.
Looking for some hints/tips or even some guidelines should work too.
Thanks in advance.