RE: Running many instances of Oracle per server
- From: "Andrew Bryant" <adb@xxxxxxxxxxxx>
- To: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- Date: Thu, 6 May 2010 14:38:58 +0100
Andrew:
>... in my experience Oracle performance is much more dependent on user
load than amount of data in the database. That being said, how busy are
the CPU's in the servers you currently have, and what does the memory
usage look like? If you have significant physical IO, you will have to
worry about overloading your IO paths also.
For sure, and we're using AWR to get a feel for those loads. AWR is
telling us that our current plan for consolidation would see each single
node server experience 50-90MB/s read+write (average, based on one week
last month) and up to 14 CPU-days for that same week. Memory for
SGA+PGA would be 12-43GB per server.
Andy
--
The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.
Other related posts:
