Date: Thu, 31 Jul 2008 06:40:46 -0700 (PDT)
On 31 Jul, 14:13, ìÉÔÏ×ÞÅÎËÏ å×ÇÅÎÉÊ <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
A query such as the following might help shed some light on your problem:
SELECT OWNER, TABLESPACE_NAME, SEGMENT_TYPE, COUNT(*)
GROUP BY OWNER, TABLESPACE_NAME, SEGMENT_TYPE; HTH -g Received on Thu Jul 31 2008 - 08:40:46 CDT