(wrong string) …

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Fri, 25 Jun 2010 05:58:43 -0700 (PDT)
Message-ID: <7a63bd42-6fb7-42dc-a5f4-e0f58e9717be_at_t10g2000yqg.googlegroups.com>


I have setup sql plan management using sqlmanagement base. Set following parameters to control space:
exec dbms_spm.configure('plan_retention_weeks', 5); exec DBMS_SPM.configure('space_budget_percent', 5);

Second parameter as far as I know only gives warning messages in alert log, but does not reduce space.
 First parameter I found cannot be set lower than 5 weeks. Is there any way to reduce it to purge space?
Is there anyway to purge plans?

My sysaux tablespace keeps growing, it is 11GB now. Most of the space is occupied by SQL Management Base. How can I free up this space? Fri Jun 25 08:33:32 2010
SQL Management Base Schema
9089.9375
SYS Server Manageability - Automatic Workload Repository 321.1875
SYS Enterprise Manager Repository
182.6875
SYSMAN XDB
97.25
XDB Server Manageability - Advisor Framework 80.1875
SYS Server Manageability - Optimizer Statistics History 28.8125
SYS Oracle Spatial
22.75
MDSYS Oracle interMedia ORDSYS Components
13.8125
ORDSYS LogMiner
7.625
SYSTEM
*** number of plans ***

    732467 Received on Fri Jun 25 2010 - 07:58:43 CDT

Original text of this message