OraFAQ Forum: Server Administration » How many Oracle instance on Dual Core System

Home » RDBMS Server » Server Administration » How many Oracle instance on Dual Core System (11g R2 ( Enterprise Edition ))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How many Oracle instance on Dual Core System [message #646010]

Thu, 17 December 2015 12:02

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 ?

Report message to a moderator

Re: How many Oracle instance on Dual Core System [message #646011 is a reply to message #646010]

Thu, 17 December 2015 12:17

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: How many Oracle instance on Dual Core System [message #646015 is a reply to message #646011]

Thu, 17 December 2015 13:58

ThomasG
Messages: 3211
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 770 times)

Report message to a moderator

Re: How many Oracle instance on Dual Core System [message #646016 is a reply to message #646010]

Thu, 17 December 2015 17:10

John Watson
Messages: 8794
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 03 16:49:39 CST 2023