Re: Shared ORACLE server question ??

Comments and questions embedded...
Regards,

Sybrand Bakker, Oracle DBA

<gwashton_at_my-deja.com> wrote in message news:8p5hhd$eot$1_at_nnrp1.deja.com...
> 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

IMO, that's not many
>
> 2) Each customer has a minimal of 50 concurrent database connections and
> a max of 500
>

Could you explain further? Is that customer a firm. Are you trying to set up an ASP. Otherwise allowing one single user to make 50 to 500 simultaneous connections doesn't make any sense to me, he/she can not possibly control that.

> 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:
>
> a) 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 & ...
>

Running 10 instances on one physical Unix server, even when there is sufficient memory etc, is possible, but should be considered as one of the safest pathways to hell. Assume, you need to shutdown that one single server!

> b) 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 & ...
>
> c) 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
>
>
>

d) If you really want to be able to support 50-500 connections per customer (which would result in a max of 5000 simultaneous connections), IMO, you simply need 10 distinct servers. I don't think any Unix server will be capable of handling this load, and as I tried to explain above that server will become a single point of failure. You should avoid that.
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 06 2000 - 11:10:45 CDT