Rami Aubourg-Kaires wrote:

> GMI wrote:
>
>
>> As I sait, currently, we are using reiserfs, but performance is
>> abismally bad: even a basic P IV pc with a IDE disk performs much
>> better...
>
>
>
> Oh, yes, and you should check if asynch I/O is on, that you've got
> libaio libraries, if your RAID system has its buffers on, and if
> /proc/sys/fs/aio-max-size is something reasonable like 1 Meg.
>
>
I never had any luck using async io in 9i under Linux. There are
other versions of Oracle under Solaris Sparc where I've had similar
problems. Lack of async io will certainly be a drag, but it shouldn't
be fatal. You can route around it with things like multiple db
writers. IO problems like these should keep him from getting the
best performance possible, not cause him to get the worst
performance possible.

In 8i, sort_area_size can get you quite a boost.

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting