Date: Thu, 31 Jul 2008 07:13:39 -0700 (PDT)
On Jul 31, 9:13 am, μΙΤΟΧήΕΞΛΟ εΧΗΕΞΙΚ <litovche..._at_ogk6.ru> wrote:
> Hi there!
> will anyone help me with OracleXE?
> the problem:
> web server running Bitrix over OracleXE, web site is very small but DB
> size has reached the limit of 4Gb.
> Size of all tables, acordig to Oracle XE web interface is less then 300Mb
> but SYSAUX is more then 4Gb. what's wrong with it? how to find storage
> Tablespace File Name Size MB
> SYSAUX D:\ORACLEXE\ORADATA\XE\SYSAUX.DBF 4 290
> SYSTEM D:\ORACLEXE\ORADATA\XE\SYSTEM.DBF 470
> UNDO D:\ORACLEXE\ORADATA\XE\UNDO.DBF 220
> USERS D:\ORACLEXE\ORADATA\XE\USERS.DBF 350
With only 350 MB (max) of data in that database, I'd consider using expdp and exporting the data and import it into a new XE db. Set statistics_level=basic and don't use the default job which gathers histograms on all columns.
Next setup a job to purge old stats.
Do you have metalink access? If so there is a note covering purging of stale statistics.
-bdbafh Received on Thu Jul 31 2008 - 09:13:39 CDT