multiple schema or multiple instance

Hello,

I would like to understand when it's better to have multiple schema and when it's better to have multiple instance. By reading this group, I feel I'm missing something...

Having multiple schema in one instance allow a far better utilization of the resource (RAM, disk) of the server. And it's more simple for administrative task.
Having multiple instance allow an independance between the applications. Independance for the parameters of the database, independance for the shutdown of the instance.

But the key point is the restore of the database. If a schema require a incomplete recovery, all the database will be concerned by this incomplete recovery and it would not be acceptable for the other application using the other schema.

So, for production database, one instance for one application is almost always required. Do you agree or do I miss something ? Received on Thu Sep 30 2004 - 16:18:52 CDT