Home » RDBMS Server » Server Administration » Instance vs Schema (10.2.0.2)
Instance vs Schema [message #348688] Wed, 17 September 2008 11:05 Go to next message
varunvir
Messages: 363
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 messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: Instance vs Schema [message #348710 is a reply to message #348689] Wed, 17 September 2008 14:36 Go to previous message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Thanks Mahesh.I will go for schema.Application is
already tested.

Regards,
Varun Punj,
Previous Topic: space quota exceeded for tablespace
Next Topic: scrollbar creatin
Goto Forum:
  


Current Time: Sun Dec 04 12:48:30 CST 2016

Total time taken to generate the page: 0.09130 seconds