As promised, I have attached the slide deck we used for our presentation at Oracle Open World. A big thanks to Allan for asking me to help… glad to do it!
ID#: S315915
Title: Optimizing Oracle Databases on Sun SPARC Enterprise M-Series Servers
Track: Sun SPARC Servers
Date: 20-SEP-10
Time: 12:30 – 13:30
Venue: Moscone South
Room: Rm 270
Slides : oow2010_db_on_mseries.pdf
There are a bunch of OTN white papers that were produced to show how to run the Oracle stack best on Sun servers. I will try to post an index soon but feel free to peruse the OTN site, there is lots of new content.
Glenn.
Awesome presentation at oow#10.
You made a statement about connection storms which arise when max!=min. Most application server configs do this. What is the compelling argument to NOT do it besides the obvious.
It really is the obvious reason. If you try to increase concurrency with an application that is ailing, you are only making the problem worse… and at the worst possible time when the system is under heavy load. When the system is really busy you want to limit dynamic behavior because it is a fairly expensive operation on the OS to create a new process and then connect to a database.
Hi Glenn,
Regarding DISM, you have mentioned to turn it off if not configured properly. We are using DISM in all of the ERP applications (Solaris 9) that are running on E20k domains. Can you elaborate a bit on what did you mean by “proper configuration” or point me to the whitepaper that has this information.
Thanks
Amir
Sorry about the belated response. Basically, the configuration I am referring to is making sure the “ora_dism” process runs with SUID root. Allan Packer wrote an excellent paper that basically says all that is needed on DISM.
http://www.oracle.com/technetwork/articles/systems-hardware-architecture/using-dynamic-intimate-memory-sparc-168402.pdf