Automation Script for Opttimization

[vasuv]

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 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

[Larz60+]

Can we write Python script to Optimize these Database objects instead of doing manual check and optimize??

Yes, of course optimization is a huge subject, and has many different aspects. That's why people are hired for this
task as a primary occupation.
You can get started here: http://www.oracle.com/technetwork/articl...91323.html