Re: Oracle partitioning

bdbafh_at_gmail.com wrote:

<snipped>
>..separate databases may be the way to go.

Hell no. Very expensive licensing wise. Very expensive platform wise as running multiple database instances on a single platform require a lot of extra horse powers and space.

On a platform where you can easily support a 100 +customers via a single db instance, you will not even be able to support 10 customers effectively using 10 instances - each with its own resource footprint on CPU (pmon, smon etc), memory (SGA), and disk space (temp, undo etc.).

To be very blunt - I think that anyone running multiple instances on a production platform is seriously missing the point. Completely.

--
Billy