Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"A script that will delete perfstat snapshots older than 90 days with SPPURGE..."

unknown-2886786Apr 22 2015 — edited Apr 29 2015

Hello to all my fine Oracle related friends...We are all one large extended Family...

I want to create a script that will execute SPPURGE on Perfstat for snapshots that are older than 90 days.

Now, I have Grid 12c Cloud Control up and running for all the Databases that we have...

Should I use Grid 12c to execute the SPPURGE and just pass the parameters in like that?

Or should I go "Old School" and make a Shell Script and schedule it in the crontab?

What would you guys do?

I want implement this for 41 "Standard Edition" Databases....some are "Data Guard".....

Thanks,

Xevv.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2015
Added on Apr 22 2015
12 comments
2,097 views