Re: Databases in a server box

NoName wrote:

> Thanks for you all. Good education.
>
> Here is my situation:
>
> In a SQL server (say, a clustered node with 8 CPU, 8G RAM), we host 30 DB's,
> including small ones like Company Web (not too much in the DB), Employee
> Directory, Time Sheet,... No problem.
>
> Now, they are developing a new Company Web and want to host on Oracle. The
> DBA requests new clustered servers with 4 CPU 4 G RAM in each node. The top
> boss wants to migrate Employee Directory to Oracle, the DBA requests another
> new server box with at least 4 CPU 4 G RAM; Time Sheets to be hosted in
> Oracle, yet they need another powerful new box or a clustered system. So if
> we move the 30 DB from SQL to Oracle, do they really need to buy 30 new
> powerful server boxes? Can't they just share one or a few like we do in MS
> SQL?
>
> I am learning Oracle, have read a few books already. Never see anything like
> this mentioned in any books or articles.
>
> Thanks again.
>
> "NoName" <PlayMan_at_Somewhere.com> wrote in message
> news:VCcA8.1425$ce4.128371_at_newsread1.prod.itd.earthlink.net...
> > 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.
> >
> >

If I understand you correctly ... using Oracle terminology you have one database with 30 schemas. If this all being hosted in SQL Server on one box then it can easily be moved to Oracle and hosted on one box. Are your DBAs Oracle DBAs or SQL Server DBAs?

Sounds to me like they see an opportunity and are trying to seize it.

Daniel Morgan Received on Fri May 03 2002 - 14:18:42 CDT