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

[Allan Packer]

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, and for  
all your tablespaces provided you have an appropriately sized database  
cache (see http://blogs.sun.com/bobs/entry/one_i_o_two_i for more info).

There's a ton of good info about Solaris 10 available at http://www.sun.com/solaris 
  and http://opensolaris.org.

Finally, check out http://www.solarisdatabases.com.   See if you can  
beg or borrow a copy - it's fairly old now, although much of it is  
still relevant and the principles still apply.

Hope this helps.

Regards,
Allan



On 15/03/2008, at 6:32 AM, Aps Reine wrote:

> Hi Everyone -
>
> I'm new to the Solaris world and SPARC CPUs.  I've been an Oracle  
> DBA for many years, but up till now it's always been on AMD/Intel  
> Linux/Windows.
>
> But now we have a Solaris10 OS and SPARC64 VI CPus entering the  
> mix ....
>
> So I'm wondering, what benefits do SPARC processors bring to the  
> table?  What changes are necessary to make the most out of the SPARC  
> CPUs?  I read a lot about how much more powerful these CPUs are, but  
> I suppose the database has to be configured differently to make use  
> of the threads.
>
> Any help or links to blogs/advice/documentation would be nice.
>
> Thanks,
> Aps
> _______________________________________________
> databases-discuss mailing list
> databases-discuss at opensolaris.org
> http://mail.opensolaris.org/mailman/listinfo/databases-discuss