Re: Hardware, Cores, Licenses
Date: Mon, 13 Aug 2012 13:59:50 -0700 (PDT)
Message-ID: <20b60243-242a-4e21-b396-c03956497226_at_pp9g2000pbc.googlegroups.com>
On Aug 13, 12:40 pm, Alex Busam <abu..._at_gmx.de> wrote:
> thanks!
> what happens on a server which is installed on a single core and cloned
> to a quad core? What does oracle do? Runs normal by using only one core?
> and no other problems are there?
Oracle sets the cpu count to 4 (or more with hyperthreading) and then allocates as the OS says to. This could make things run faster, as more threads could run at a time. This could make things run slower, as more I/O requests come out of the cpu and jam up the I/O. There are so many variables you can only test empirically and iteratively, fixing whatever you find wrong and trying again. There are version dependencies, sometimes having more memory available means Oracle can do more stuff in memory, pounding on cpu and slowing things down (some operations in 10gR2 seem very susceptable to this. Modern Oracle also can give some weight to the system performance it sees. Most performance issues come from the SQL, and how the optimizer deals with things can change as you change the physical configuration. For that matter, adding a row or making a slight init.ora change can change the plan for a query on the edge. And if the stuff your SQL does is heavy on the I/O anyways, putting in faster/more cpu might make no difference at all (hence the "wait faster" comments). You can work through Craig Shallahammer's capacity planning, if you have some desire for that sort of thing.
Why bother with a 32 bit system in this day and age?
Note I don't have all that much experience with your kind of configuration, it proved itself unsuitable to me long ago. YMMV.
jg
-- _at_home.com is bogus. Flashmob success = epic fail http://www.utsandiego.com/news/2012/aug/12/police-investigating-vandalism-balboa-park-lily-po/Received on Mon Aug 13 2012 - 15:59:50 CDT