Recently got an request to configure statspack for 2 different day and different time as well.
After seeing the requirement , i manage to get a rough picture of what need to be done.
1) Customer request to have 2 statspack report , 1 at monday for 09:00 to 09:30
another one report is friday for 13:00 to 13:30
2) Report is require to generate based on this 4 snap
3) After generate send the report to customer on monday.
utility involve is
-Oracle build in package Dbms_job is create to make the 4 snap on oracle side
-Unix crontab is create to generate the 2 report
-Unix Sendmail is require to send it automatically to customer
There are a risk there , as customer require us to send report on Monday morning, if not proper schedule of crontab, we will not able to capture the correct begin snap and end snap for monday.
I have assign this task to my team, but most of them don't even know how to get the request properly.
Till i have to get 'SWAT' team in to help out..:)
Now i wonder whether if we technically are strong but if without analytical skill , can we further perform or not ?