Re: OracleXE

From: Ëèòîâ÷åíêî Åâãåíèé <litovchenko_at_ogk6.ru>
Date: Fri, 01 Aug 2008 09:19:31 +0400
Message-ID: <g6u6d7$1gbn$1@news1.macomnet.ru>

bdbafh ïèøåò:

> 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

i've found metalink note but
exec dbms_stats.purge_stats(systimestamp); did not helped at all;

expdp will try next weekend Received on Fri Aug 01 2008 - 00:19:31 CDT