Re: Databases in a server box

If databases support different applications, that change frequently, sometimes it's useful to 'cluster' certain types of schemas into separate databases (instances). It might add some inefficiency (e.g. extra system tablespaces, extra memory used).. but there are definetely some pluses as well: faster backups/recoveries, higher overall uptime, etc.

On Thu, 02 May 2002 17:20:38 +0200, Knut Talman <knut.talman_at_mytoys.de> wrote:

>NoName wrote:
>
>> Hi,
>>
>> I am MS SQL DBA in a large company. In SQL servers, we have 20-50 databases
>> in each box, but in Oracle servers, only one database in each Unix box, even
>> for very small databases (a hundred MB). Is that supposed to be? Can't or
>> Shouldn't Oracle server host more databases? Thanks.
>
>
>That's the usual mistake of MS SQL users.
>
>MS SQL database != Oracle database
>
>In Oracle we call it schema. There might be only one database (where the data is
>stored) but as many schemas (MS SQL database) as you want.
>Nevertheless you can also run more than one database (or instance to confuse you
>even more) on one machine but almost ever it makes no sense.
>
>Regards,
>
>Knut
>

.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Thu May 02 2002 - 13:11:25 CDT