Question: I am migrating a database into an
Oracle RAC cluster, and I need to decide whether to add the system
as a new schema within an existing instance or create a new
instance. How do I decide whether to create a new instance versus
creating a new schema?
Answer: Essentially, the decision of
creating a new instance vs. a new schema is a question of sharing
If the system never communicate with each other, I would not put
them in the same instance . . .
With a separate instance, one system cannot clobber another, but
you need to have enough RAM to support the extra SGA regions on each
In a nutshell, if you have the extra RAM, a new instance give the
DBA more granular control over the system performance and
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.