Shared ORACLE server question ??

I have a general ORACLE layout and configuration question.

Given the following:
1) You are in a many customer environment, ie. you have many customers, in this case, lets say 10 customers

2) Each customer has a minimal of 50 concurrent database connections and a max of 500

3) Each customer is using a different application & database model, ie. each customer does not resemble the other except that they are all using ORACLE as a backend, meaning 10 different data models

4) All customers are using the same version of ORACLE

5) You are given one UNIX server, as big as need be to support this environment, minus the application servers or in another words, the app servers will reside elsewhere and not on "this" UNIX database server

What seems the near wisest solution with respect to keeping all customers happy performance wise or if not listed please supply:

1. Seperate each customer out onto their own ORACLE server on the same physical UNIX server, each a dedicated ORACLE server, throw lots of memory & fast i/o/disk access & ...
2. combine all databases into one dedicated ORACLE server, each customer having their own schema, each schema contains an individual customers model, tighten up security (use encryption and checksumming), again, throw lots of memory & fast i/o/disk access & ...
3. combine all databases into one MTS ORACLE server, if resources available, put connection manager on another UNIX server, or just use MTS bare bones, again, throw lots of memory & fast i/o/disk access & ...

All help appreciated,

Thanks,

George Washton

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 06 2000 - 08:41:06 CDT