RE: Rule of thumb for new schema vs. new database?

99% of the time a new schema or user is appropriate. Creating new database instances for each application is a nightmare for administration. And creates new performance problems as each instance competes for the same system resources.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BP Sent: Wednesday, October 05, 2005 5:09 PM To: Oracle-L
Subject: Rule of thumb for new schema vs. new database?

Hi Again,

I have a meeting tomorrow with one of our project managers who is going to request a new schema or database. He wants my advice on which is best for his needs. Now...as I've said before I'm a neophyte DBA and do know the difference between a schema and a new database. I'm inclined to suggest just a new schema, but now I'm wondering to myself what kind of 'rule of thumb' is there is for this kind of decision.

When would it be preferable to create a new db vs. just a schema in an existing db?

Thanks for you help.

Brian Peasey
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 05 2005 - 16:17:51 CDT