Instance vs Schema [message #348688] |
Wed, 17 September 2008 11:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hi Experts,
I have two instances running on the database server.
Is it appropriate to add one more instance or should I go
for schema creation in already existing instance.
The CPU Utilization on the database server is alreeady 55%.
The new application will be highly transactional and size of
new appliccation will be 20gb.I have enough memory and disk
space.The only issue is CPU.
Regards,
Varun Punj,
|
|
|
Re: Instance vs Schema [message #348689 is a reply to message #348688] |
Wed, 17 September 2008 11:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
It depends on how you intend to use the schema/instances.
Generally, just another schema is better as you save in allocated resources.
But, i would not add a schema (for dev) in a production database.
It is totally upto your audit standards /Application requirements,
your backup strategy for the application etc.
Meanwhile, 20gb is minuscule.
[Updated on: Wed, 17 September 2008 11:11] Report message to a moderator
|
|
|
|