In my previous 2 posts we have discussed some basics of Perl coding namely
Keeping these basics on mind and adding to them here we develop our first Perl script .
Although it's the DBA who deploy STORED PROCEDURE and FUNCTIONS , some times you want to quickly check the PROCEDURES deployed from last week or so and check the cost(timerons) against them to find the culprit.
I use this script more than seldom, but every time I use this , it fulfills my tasks
This script helps you check the ESTIMATED COSTS of the deployed STORED PROCEDURES from the last n no. of days on the go.