Andrew,
> The Packer Solaris database book (Packer, Allan N., _Configuring &
> Tuning Databases on the Solaris Platform_. Palo Alto: Sun
> Microsystems P, 2002. ISBN 0-13-083417-3) does suggest mounting the
> filesystems with forcedirectio; I dimly recall using this for the wal
> partition on one test box, and STR that it helped.
This is a good idea for a WAL partition, but is NOT a good idea for the
database.
You pay want to look into setting segmap_percent to 70% or something. On
Solaris 10 at least, the OS by default only uses 10% of memory for disk
buffers.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco