(wrong string) …
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