Re: Different DBA for different database instance

        There is an old folk saying that I think applies here. "Too many cooks spoil the broth." Five DBAs all working on the same machine is, IMHO, about four too many cooks. If you create a separate instance for each department in order to keep the DBAs from stepping all over each other you need either an awful lot of RAM or a bunch of trivial applications.

        If your applications aren't trivial and/or you don't have enough RAM to avoid thrashing the db buffers you would have to have more than one DBA working in the same instance at the same time. Now, in theory this is possible, but only if all of the parties that are involved agree on a separation of duties. Which, given that they are in different departments, is probably not very likely to happen.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/30/00, 5:28:40 PM, yeowhin_at_hotmail.com (Y H Ong) wrote regarding Different DBA for different database instance:

> I have 5 databases (belonging to 5 departments) on a single unix
> machine. Currently, the 5 databases are managed by 1 DBA. But now, I
> would like each of the department to manage their own databases but at
 

> the same time, don't want them to mess with the rest.
 

> Can anyone advise on how can I achieve this. Thanks.
 

> Rgds,
> YH.
Received on Tue May 02 2000 - 00:00:00 CDT