> 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.
>
>

I did. On SCSI disks. Something like a 4x performance boost on imports
and I/O intensive tasks under 8i and 9i. On IDE disks, never had any
performance problems.

OT: Under Solaris, separate the Oracle partitions from the rest of your
system and mount them with forcedirectio option. You'll get an I/O
performance boost on Oracle, but performance decrease on plain system
I/O. As with Linux, IDE disks are just fine. Only SCSI and fiber channel
can have the performance problem.


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