rw-r-r- 1 ludovico ludovico 165304 May 20 08:18 buffer_busy_waits.rrd rw-r-r- 1 ludovico ludovico 165304 May 25 15:00 Streams_AQ_enqueue_blocked_on_low_memory.rrd This is a very basilar script that works greatly for me with good performances: Since I’m very comfortable with php, I did it this way. The less rrdtool update commands you will execute, the better the whole process will perform.ĭo it in a language you are comfortable with and that supports easily connection descriptors. – build and execute an rrdtool update command The whole process of gathering performance data and update rrd files can be resumed into the following steps: Historical views could be useful also to collect historical data once a week rather than query the fixed views every few minutes doing the hard work twice (you and AWR). If you are administering a new instance and you haven’t collected its statistics so far, you can query (as example) the DBA_HIST_BG_EVENT_SUMMARY view to gather all AWR data about wait events. No matter if you are using AWR or statspack, you can rely on their views to collect data for your RRDs. Since release 10.1 Oracle has introduced Automatic Workload Repository, a finer version of old good Statspack. You can query many v$ fixed views at regular intervals and populate many RRD files through rrdtool: space usage, wait events. Oracle Database Server has the most powerful system catalog that allows to query almost any aspect inside an oracle instance. Ludo Posted in Oracle, Oracle Database, Oracle Database 12c, Oracle Upgrade, Install and Configuration, Trivadis Blog | Tagged Capacity Planning, consolidation, Oracle, Oracle Database, oracle database 12c, oracle rac, RAC, server, workload | 5 Replies Mass datafile resizing flashdba October 25, The result was between 50 and 87 instances running per node #complicatedĭoes 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! □ flashdba October 25, The cluster had around 120 DBs, not every database had an instance on every node flashdba October 25, It was a production system too – and yes, it was a nightmare! Ivy EX does 12TB □įlashdba has seen 87 instances on a single host, but on a Multi-node RAC: but still huge and When I worked for Oracle I saw 87 instances on single a node – and it was six node RAC because there are no 1TB EP offerings… at least not until after Haswell. Kevin October 25, how did you guess ? □ Bertrand Drouvot October 25, 2013 Intel platform with 1TB of RAM = Xeon E7, suggests Kevin: Bertrand Drouvot October 25, 1TB is our default as of a few months □ Klaas-Jan Jongsma October 28, capacity planning is a big challenge here with currently around 1800 databases and this is constantly increasing… Bertrand Drouvot October 28, damn your the winner, i can’t higher then 118 but this customer is still busy migrating more. Bertrand Drouvot October 25, Here is the exact number dude: ps -ef | grep -c ora_smon 131 up to 100 instances/host when researching for this paper: Proof point stayed much lower thoughīut Bertrand impresses with his Will give you the right number on Monday but I would say around 120 □ Kevin, as a great expert, already experimented one hundred instances environment: a good playground for either threaded_execution=true or multitenant □ Wissem El Khlifi October 25, we have at least 4 servers like this, big ones! 2 for prods …Ĭhris correctly suggests to give a try to the new 12c consolidation features: Wissem cores 73 on a production system, 1TB about 150 TB of storage, 1TB memory, 40 Cores … Ok u win □ - Wissem El Khlifi October 25, 2013 Bjoern Rost October 25, I have more □ - Wissem El Khlifi October 25, ay cant believe it, think they removed some DBs, i have now 73. My customer environment however, was NOT a production one. Who has done more than this on a single server? $ ps -eaf | grep ora_pmon | wc -l 77 #oracle #consolidation I’ve sent this tweet a couple of weeks ago and I would like to consolidate some replies into a single blog post. The actual number of database instances per database node or cluster depends on application workload and their corresponding system resource consumption.īut how many instances are actually beeing consolidated by DBAs from all around the world? 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. NOTE: The maximum number of database instances per cluster is 512 for Oracle 11g Release 1 and higher. According to Exadata consolidation guide, this is what you can consolidate on Oracle specialized Hardware:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |