I am working on a project that will need STATSPACK.
I have installed it and also run the spauto.sql to gather hourly snapshot on the database.
Our goal here is to keep 12 months of hourly snapshot (that 8064 snaps)and purge anything beyond 12 months and I was asked not to use a cron, maestro or any other scheduler to do the purge but to use something similar the Oracle "spauto" that get hourly snap everyday.
Can sppurge.sql be manipulated and run as dbms_job and act the same way as spauto that you run once and get the snapshot every hour for you and ONLY purge if we have beyond 12 months and if we do not have 12 months of
snap retrun "no rows purged" or "No snapshot purge is necessary"
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.