Any tool to analyze SP Packeges??
Hi - Is there any way we can analyze SP Packages in ORacle 9i???
We have lots of Packeges and we want to analyze if Stored procedured build are optimized or not...
is there any tool which is easy to use and can give me reports on how well written sp's are...
DBMS_PROFILER in Oracle 8i is a good tool and should be in 9i as well which I am not sure of .
There is a chapter on it in Expert one on One by Tom Kyte .
Click Here to Expand Forum to Full Width