Home » RDBMS Server » Server Administration » How many Oracle instance on Dual Core System (11g R2 ( Enterprise Edition ))
How many Oracle instance on Dual Core System [message #646010] Thu, 17 December 2015 12:02 Go to next message
viba1987
Messages: 3
Registered: May 2014
Location: Chennai
Junior Member
How may Oracle enterprise editions ( 11g R2 ) can be run on a Dual Core system with 16GB RAM , 200 concurrent users. also does Oracle run on single core system ?
Re: How many Oracle instance on Dual Core System [message #646011 is a reply to message #646010] Thu, 17 December 2015 12:17 Go to previous messageGo to next message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
viba1987 wrote on Thu, 17 December 2015 10:02
How may Oracle enterprise editions ( 11g R2 ) can be run on a Dual Core system with 16GB RAM , 200 concurrent users. also does Oracle run on single core system ?


Post URL to single core system; even my Raspberry Pi is a multi-core system.
System above is VERY resource limited.
If you can afford Oracle s/w license, surely you can afford better hardware.
Answer depends upon your definition of run.
Is 2+ minute response time acceptable?
Re: How many Oracle instance on Dual Core System [message #646015 is a reply to message #646011] Thu, 17 December 2015 13:58 Go to previous messageGo to next message
ThomasG
Messages: 3205
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, I run our main production db with ~400 concurrent users on a VM which where the guest sees four processors cores.

Here is the CPU load for one week:

/forum/fa/12947/0/

So it seems in that week it happened ONCE hat more than two CPUs (50%) were in use.

So I would say It depends a lot on what those people are doing. Whether it's just "data shovelling" or more CPU intensive tasks with a lot of calculations going on.
  • Attachment: cpu_chart.png
    (Size: 93.95KB, Downloaded 108 times)
Re: How many Oracle instance on Dual Core System [message #646016 is a reply to message #646010] Thu, 17 December 2015 17:10 Go to previous message
John Watson
Messages: 7216
Registered: January 2010
Location: Global Village
Senior Member
I'm running 5 standard edition database instances on a cloud server with 2 CPUs and 4GB RAM. We had to upgrade from only one CPU because when doing large jobs (backups, exports) performance degraded for the users.

[Updated on: Thu, 17 December 2015 17:10]

Report message to a moderator

Previous Topic: trace bind variable for insert statement not working
Next Topic: ORA-12154: TNS:could not resolve the connect identifier specified in oracle 12c
Goto Forum:
  


Current Time: Thu Jan 18 14:35:13 CST 2018

Total time taken to generate the page: 0.02472 seconds