Can I trunc perfstat tables in production database 10gR2
Hi gurus,
I have Large Production database(10gR2) on HP-Unix platform.
In that I have tools tablespace occpying 50 gig and it is growing. The growth is because of statspack snaps that are being collected for every hour.
My production database is backed up every night(midnight) by shutting down and taking cold backups.
We are using statspack reports even in 10g instead of AWR. I inherited this system. Now we want to get rid of space occupied by statspack user, without uninstalling the perfstat user.
I have used sptrunc.sql on a development system where we don't run 'optimizer stats', and feel ok.
I have Large Production database(10gR2) on HP-Unix platform.
In that I have tools tablespace occpying 50 gig and it is growing. The growth is because of statspack snaps that are being collected for every hour.
My production database is backed up every night(midnight) by shutting down and taking cold backups.
We are using statspack reports even in 10g instead of AWR. I inherited this system. Now we want to get rid of space occupied by statspack user, without uninstalling the perfstat user.
I have used sptrunc.sql on a development system where we don't run 'optimizer stats', and feel ok.
0