On Sat, Mar 15, 2008 at 10:16:15PM -0700, Allan Packer wrote: > Hi Aps, > > Welcome to the world of Sun! > > Oracle is able to take advantage of the extra CPUs (each core and each > thread appears to Solaris as a CPU). Without knowing anything about > your application, here's a few things to consider: > - configure the right number of CPUs for operations that are able to > be multithreaded (e.g. database load, index create, etc). For OLTP > applications, the users should use the various CPUs. For DSS > applications, configure the right level of query parallelism to use up > all your CPUs. > - configure sufficient memory for your database cache. > - you've made a good choice for your file system. If you're using > UFS, consider using Direct I/O for your redo logs at least,
It is even better to use direct I/O on the Oracle side. I mean to use filesystemio_options=setall and leave the ufs filesystem mounted without forcedirectio option. That way you can have buffered access to some files (which is sometimes better) and direct to the other - Oracle decides which is better. Regards przemol -- http://przemol.blogspot.com/ ---------------------------------------------------------------------- Wojna wampirow trwa - po ktorej jestes stronie? Zagraj >>> http://link.interia.pl/f1cf4
