Re: Databases in a server box

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Thu, 02 May 2002 17:20:38 +0200
Message-ID: <3CD15946.5000002@mytoys.de>

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 Received on Thu May 02 2002 - 10:20:38 CDT