According to Exadata consolidation guide, this is what you can consolidate on Oracle specialized Hardware:
NOTE: The maximum number of database instances per cluster is 512 for Oracle 11g Release 1 and higher. An upper limit of 128 database instances per X2-2 or X3-2 database node and 256 database instances per X2-8 or X3-8 database node is recommended. The actual number of database instances per database node or cluster depends on application workload and their corresponding system resource consumption.
But how many instances are actually beeing consolidated by DBAs from all around the world?
I’ve asked it to the Twitter community
I’ve sent this tweet a couple of weeks ago and I would like to consolidate some replies into a single blog post.
who has done more than this on a single server? $ ps -eaf | grep ora_pmon | wc -l 77 #oracle #consolidation
— Ludovico Caldara (@ludovicocaldara) October 25, 2013
My customer environment however, was NOT a production one. On the production they have 45.
Some replies…
@CacheFlush @kevinclosson @ludovicocaldara I know one customer with 58
— Bjoern Rost (@brost) October 25, 2013
@ludovicocaldara I have more 🙂 — Wissem El Khlifi (@orawiss) October 25, 2013
@ludovicocaldara ay cant believe it, think they removed some DBs, i have now 73. Ok u win 🙁 — Wissem El Khlifi (@orawiss) October 25, 2013
Wissem cores 73 on a production system, 1TB memory!
@ludovicocaldara about 150 TB of storage, 1TB memory, 40 Cores …
— Wissem El Khlifi (@orawiss) October 25, 2013
@ludovicocaldara we have at least 4 servers like this , big ones! 2 for prods …
— Wissem El Khlifi (@orawiss) October 25, 2013
Chris correctly suggests to give a try to the new 12c consolidation features:
.@ludovicocaldara a good playground for either threaded_execution=true or multitenant 😉
— Christian Antognini (@ChrisAntognini) October 25, 2013
Kevin, as a great expert, already experimented one hundred instances environment:
.@ludovicocaldara up to 100 instances/host when researching for this paper: http://t.co/sIAuvnDJ2D Proof point stayed much lower though
— Kevin (@kevinclosson) October 25, 2013
But Bertrand impresses with his numbers!
@ludovicocaldara Will give you the right number on Monday but I would say around 120 🙂
— Bertrand Drouvot (@BertrandDrouvot) October 25, 2013
@ludovicocaldara Here is the exact number dude: ps -ef | grep -c ora_smon 131
— Bertrand Drouvot (@BertrandDrouvot) October 28, 2013
@BertrandDrouvot @ludovicocaldara damn your the winner, i can’t higher then 118 but this customer is still busy migrating more.
— Klaas-Jan Jongsma (@futureveterans) October 28, 2013
@ludovicocaldara capacity planning is a big challenge here with currently around 1800 databases and this is constantly increasing…
— Bertrand Drouvot (@BertrandDrouvot) October 25, 2013
@ludovicocaldara @orawiss 1TB is our default as of a few months 🙂
— Bertrand Drouvot (@BertrandDrouvot) October 25, 2013
Intel platform with 1TB of RAM = Xeon E7, suggests Kevin:
. @BertrandDrouvot @ludovicocaldara @orawiss so you standardize on Xeon E7 ?
— Kevin (@kevinclosson) October 25, 2013
@kevinclosson how did you guess ? 🙂 @ludovicocaldara @orawiss
— Bertrand Drouvot (@BertrandDrouvot) October 25, 2013
. @BertrandDrouvot @ludovicocaldara @orawiss because there are no 1TB EP offerings… at least not until after Haswell. Ivy EX does 12TB 🙂
— Kevin (@kevinclosson) October 25, 2013
Flashdba has seen 87 instances on a single host, but on a Multi-node RAC: but still huge and complex!
@ludovicocaldara @BertrandDrouvot @orawiss When I worked for Oracle I saw 87 instances on single a node – and it was six node RAC
— flashdba (@flashdba) October 25, 2013
@ludovicocaldara @BertrandDrouvot @orawiss It was a production system too – and yes, it was a nightmare!
— flashdba (@flashdba) October 25, 2013
@kevinclosson @ludovicocaldara @BertrandDrouvot @orawiss The cluster had around 120 DBs, not every database had an instance on every node
— flashdba (@flashdba) October 25, 2013
@kevinclosson @ludovicocaldara @BertrandDrouvot @orawiss The result was between 50 and 87 instances running per node #complicated
— flashdba (@flashdba) October 25, 2013
Conclusion
Does this thread of tweets reply to the question? Are you planning to consolidate your Oracle environment? If you have questions about how to plan your consolidation, don’t hesitate to get in touch! 🙂
—
Ludo