Re: OracleXE
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 31 Jul 2008 11:19:46 -0500
Message-ID: <Mylkk.6895$cn7.3728@flpi145.ffdc.sbc.com>
>> 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
Date: Thu, 31 Jul 2008 11:19:46 -0500
Message-ID: <Mylkk.6895$cn7.3728@flpi145.ffdc.sbc.com>
bdbafh wrote:
> 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
if your our data will actually grow to that size - you may have to consider Mysql or similar. Received on Thu Jul 31 2008 - 11:19:46 CDT