From: William Ng (william.ng@exchangesys.com)
Date: Sun May 18 2003 - 01:26:49 CEST
Message-ID: <ED65E6826FC5D6118D710020ED295BF9102020@exchange.exchangesys.com> From: William Ng <william.ng@exchangesys.com> Date: Sun, 18 May 2003 00:26:49 +0100 Subject: RE: [suse-oracle] Oracle 9i - SuSE 8.1 - Reiser (Slow)
This also occurs on SUSE 8.2.
Like yourself, i found that Oracle 9i with EXT3 is considerably faster than
with REISERFS on SUSE 8.2. On 8.0, REISERFS performance was fine, under 8.2
its about 5 times slower.
> -----Original Message-----
> From: Samuel H Roseman [mailto:calliesam@ev1.net]
> Sent: 17 May 2003 14:22
> To: suse-oracle@suse.com
> Subject: [suse-oracle] Oracle 9i - SuSE 8.1 - Reiser (Slow)
>
>
> In a nutshell...
> I have SuSE 8.0 running on a Sony Laptop with, I guess, IDE drives.
> I have SuSE 8.0 running on a self-built desktop with SCSI drives.
> I have an Oracle 9i database (/u0?/oradata) located on
> Reiser partitions.
>
> I can a run dbms_stats.gather_table_stats under SuSE 8.0 and it will
> finish in about 3 minutes
> (really minutes and 32 seconds).
>
> I upgraded to SuSE 8.1, it run significant longer.
>
> After searching the WEB and finding little about this problem, I did
> find some talk about using EXT3.
>
> Under SuSE 8.1, I...
>
> 1. Wiped out my database on my desktop.
> 2. Reformatted by Reiser partitions to be EXT3 partitions.
> 3. Recreated my database and loaded up my table with the same data.
> 4. I ran the same dbms_stats command and it finished in 2
> minutes and
> 33 seconds.
>
> Reiser is considerably faster under SuSE 8.0 than under SuSE 8.1.
>
> Does anyone know why?
>
> Sam
> OCA
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
> For additional commands, e-mail: suse-oracle-help@suse.com
> Please see http://www.suse.com/oracle/ before posting
>
---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting
This archive was generated by hypermail 2.1.7 : Sun May 18 2003 - 01:27:03 CEST