Re: howto remove perfstat snapshots

"Frank" <no_at_spam.org> a écrit dans le message de news: 43823b8a$0$11069$e4fe514c_at_news.xs4all.nl...
| Hello,
|
| perfstat runs at my site every hour of every day of the week. Because of
| the continue groth of data I want to remove old snapshots. How can I do
| this?
|
| Also I am not very interested in the perfstat data that is collected in
| the weekends. How can I schedule a job that runs only every hour on
| workdays (monday-friday).
|
| Thanks in advance,
|
| Frank

Use sppurge.sql or sptrunc.sql you'll find in $ORACLE_HOME/rdbms/admin.

Regards
Michel Cadot Received on Mon Nov 21 2005 - 16:03:08 CST