Re: OracleXE
Date: Thu, 31 Jul 2008 06:40:46 -0700 (PDT)
Message-ID: <bafd4cb5-6437-4295-b085-670fa2a9386d@k30g2000hse.googlegroups.com>
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
> 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
A query such as the following might help shed some light on your
problem:
SELECT OWNER, TABLESPACE_NAME, SEGMENT_TYPE, COUNT(*)
FROM DBA_SEGMENTS
GROUP BY OWNER, TABLESPACE_NAME, SEGMENT_TYPE;
HTH
-g
Received on Thu Jul 31 2008 - 08:40:46 CDT