Oracle 8i Standard Edition vs Enterprise Edition for Linux

Hi,

I am in the process of choosing a back-end database server platform for a new application service.
My platform is Red Hat Linux/Apache and all the application will be written in 90% Perl (mod_perl based) and 10% ANSI C. The application will maintain persistent connection to the back-end database and also includes batch processing for purchase history analysis.

After looking at the pricing and other information at Oracle web site, I came to the following conclusion:

Solution #1: Using multiple (2+) standard edition Oracle 8i on Linux I will load balance clients between 2 or more Oracle 8i standard edition servers to maintain a high degree of performance.

Solution #2: Using (1-2) enterprise edition Oracle 8i on Linux I will load balance clients between 1-2 Oracle 8i enterprise edition servers to maintain a high degree of performance.

Obviously, the 2nd solution is VERY EXPENSIVE.

What I would like to find out is the following:

Am I better of with solution #1 where the Oracle pricing allows me to add more standard edition database servers as my need grows with more and more clients. Any thoughts/pointers will be greatly appreciated.

Also, I am interested in hearing about Oracle experts who are using it in Linux platform for large scale OLTP.

A reply post or direct e-mail will be greatly appreciated.

Kind Regards,

Kabir
http://www.nitec.com Received on Fri Dec 10 1999 - 19:24:13 CST