Hi,
As a Oracle Developer, I am writing many Procedures,Functions and Packages. Facing Many optimization issue after writing these Database objects. Trying to tune it manually.
Can we write any Shell/Perl/Python script to Optimize these Database objects instead of doing manual check and optimize?? It would be great if we can optimize/fining the issue where the query is taking long time ( instead of going through the Explain Plan).
Please advise.
Thanks,
Vasu
Do you know how to use the tkprof oracle profiler? It produces a file that is a compilation (summary) of what you just asked for. So if your object has several different sql operations, tkprof will write a summary for each one. Every sql statement gets a performance summary in the output file.
You may have to have the DBA or the sysadmin give write permissions to the oracle directory tkprof writes to. We run it against a program that calls many objects because it gives such a nice fine-grained report and objects may call each other in some cases.