Wednesday, November 19, 2014

How to increase the SMB space budget

When the message below shows up in the database alert.log, you should increase the SMB space budget.

Message:
SPM: SMB space usage (13523353600) exceeds 10.000000% of SYSAUX size (15728640000).
Command:
exec dbms_spm.configure('Space_budget_percent', 30);

No comments:

Post a Comment