Many Small Oracle Databases

From: Charles <cdavis10717_at_comcast.net>
Date: 21 Jan 2004 15:32:07 -0800
Message-ID: <83dbb3cd.0401211532.543df32e@posting.google.com>

All,

I manage Oracle/UNIX and MS-SQL Server databases in a large company.

For smaller databases (100MB - 10GB) I always give the developer a SQL Server database since it it very quick and easy to create on a shared SQL Server that already has many other databases on it. The Oracle databases are mostly very large SAP instances.

But today I was challenged to give a reason why I do not give out lots of small Oracle/UNIX databases. I am formulating a business strategy for choosing the DBMS to use for apps.

I am asking what other DBAs are doing?

Are you creating individuals Oracle SIDs for all kinds of small databases for deparmental apps?

Do you have one large-ish Oracle SID that you create multiple schemas in for each "separate" database request that you get?

I'd sure appreciate hearing how DBAs working in a large enterprise handle this.

Many thanks.

Charles Received on Wed Jan 21 2004 - 17:32:07 CST