{"id":479,"date":"2013-11-06T11:02:21","date_gmt":"2013-11-06T09:02:21","guid":{"rendered":"http:\/\/www.ludovicocaldara.net\/dba\/?p=479"},"modified":"2020-08-18T16:46:38","modified_gmt":"2020-08-18T14:46:38","slug":"how-many-oracle-instances-can-be-consolidated-on-a-single-server","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/how-many-oracle-instances-can-be-consolidated-on-a-single-server\/","title":{"rendered":"How many Oracle instances can be consolidated on a single server?"},"content":{"rendered":"

According to Exadata consolidation guide<\/a>, this is what you can consolidate on Oracle specialized Hardware:<\/p>\n

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.<\/p>\n

 <\/p><\/blockquote>\n

But how many instances are actually beeing consolidated by DBAs from all around the world?<\/p>\n

I’ve asked it to the Twitter community<\/strong><\/p>\n

I’ve sent this tweet a couple of weeks ago and I would like to consolidate some replies into a single blog post.<\/p>\n

who has done more than this on a single server? $ ps -eaf | grep ora_pmon | wc -l 77 #oracle<\/a> #consolidation<\/a><\/p>\n

\u2014 Ludovico Caldara (@ludovicocaldara) October 25, 2013<\/a><\/p><\/blockquote>\n

 <\/p>\n

My customer environment however, was NOT a production one. On the production they have 45.<\/p>\n

Some replies…<\/strong><\/p>\n

@CacheFlush<\/a> @kevinclosson<\/a> @ludovicocaldara<\/a> I know one customer with 58<\/p>\n

\u2014 Bjoern Rost (@brost) October 25, 2013<\/a><\/p><\/blockquote>\n

 <\/p>\n

 <\/p>\n

@ludovicocaldara<\/a> I have more \ud83d\ude42 \u2014 Wissem El Khlifi (@orawiss) October 25, 2013<\/a><\/p><\/blockquote>\n

 <\/p>\n

@ludovicocaldara<\/a> ay cant believe it, think they removed some DBs, i have now 73. Ok u win \ud83d\ude41 \u2014 Wissem El Khlifi (@orawiss) October 25, 2013<\/a><\/p><\/blockquote>\n

Wissem cores 73 on a production system, 1TB memory!<\/p>\n

@ludovicocaldara<\/a> about 150 TB of storage, 1TB memory, 40 Cores …<\/p>\n

\u2014 Wissem El Khlifi (@orawiss) October 25, 2013<\/a><\/p><\/blockquote>\n

 <\/p>\n

@ludovicocaldara<\/a> we have at least 4 servers like this , big ones! 2 for prods …<\/p>\n

\u2014 Wissem El Khlifi (@orawiss) October 25, 2013<\/a><\/p>\n

 <\/p><\/blockquote>\n

Chris correctly suggests to give a try to the new 12c consolidation features:<\/p>\n

.@ludovicocaldara<\/a> a good playground for either threaded_execution=true or multitenant \ud83d\ude09<\/p>\n

\u2014 Christian Antognini (@ChrisAntognini) October 25, 2013<\/a><\/p><\/blockquote>\n

 <\/p>\n

Kevin, as a great expert, already experimented one hundred instances environment:<\/p>\n

.@ludovicocaldara<\/a> up to 100 instances\/host when researching for this paper: http:\/\/t.co\/sIAuvnDJ2D<\/a> Proof point stayed much lower though<\/p>\n

\u2014 Kevin (@kevinclosson) October 25, 2013<\/a><\/p><\/blockquote>\n