Database - RAC/Scalability (MOSC)

MOSC Banner

STATSPACK delete the relevant data that has PERFSTAT schema on SYSAUX tablespace

edited Feb 19, 2016 4:07AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Check the share table space SYSAUX saw it STATSPACK accounted for 15GB

I want to delete the relevant data STATSPACK PERFSTAT have.

Do not include the reduced capacity "sppurge.sql" I try to do the "sptrunc.sql",

If I perform a "sptrunc.sql", I will not be seeing anything like (Ctrl + E in orange tools) you want to analyze only those where no information or statistics about the past simple "plan information"?

In general, the impact goes even wonder statistical information (statistics automatically from 11g to collect statistics or to gather_table_stats, etc.) to collect.

And, there are now automatically collect statistics, automatic statistics collection JOB even stop running as the account (PERFSTAT), I wonder that there is no impact.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center