[databases-discuss] Benefits of using Oracle with Solaris10 & SPARC64 VI CPU

[przemolicc at poczta.fm]

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