Re: How much instances per server?

On Tue, 22 May 2001 12:41:06 GMT, "Jim Kennedy" <kennedy-family_at_home.com> wrote:

>Why not make it easier and just have multiple schemas? (Performance is
>never secondary; everyone says it is then bitches when it bites.) The user
>will have the same effect and with less maintenance and better performance
>than multiple instances. Theoretically, you can have a very large number;
>in practice after about 5 performance really starts to tail off.

Why not use multiple schemas? Let's see

• Rollback contention
• Redo contention
• No independent full backup
• No independent restore
• DB-wide privileges apply to all schemas ... not just the one you're using to mimic a database.
• Problems with commercial packages that use prescriptive schemas
• Every other major db (DB2, Informix, Sybase, SQL Server 2k) supports multiple DBs per instance, AND schemas within each DB.

Oracle is really good at a great many things ... but they're 10 years behind on this particular topic.

Ciao
Fuzzy
:-) Received on Tue May 22 2001 - 20:53:57 CDT