Re: OracleXE
Date: Thu, 31 Jul 2008 07:13:39 -0700 (PDT)
Message-ID: <e0591455-a079-42d4-abc6-fb8d1cef4c96@m36g2000hse.googlegroups.com>
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
> killer?
>
> 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.
good luck.
-bdbafh Received on Thu Jul 31 2008 - 09:13:39 CDT