Oracle Internet/Intranet Licencing - Overflow from a DBI-users thread

Sorry to relocate a thread but...

This is a long running argument on the DBI-Users mailing list and I would like some input from this news group as to their opinions on Oracle licencing when connected to the internet (or internets with known numbers of users) via a web server with known limits and the most economical way of achieving this.

There is some debate as the the exact limitations of the Oracle Licences and their pricing policy.

Patrick Mulvany

Orlando Andico wrote:

> Argh. That's expensive. We got our Oracle license before the new
> licensing
> scheme came into effect. We got 10 concurrent devices which was <
> $10000.
> The web server counts as one concurrent device.. :]
>
> I got some rumor over at the linux-informix_at_iiug.org mailing list to
> the
> effect that Informix Foundation 2K is $2000 a year on Linux
> single-CPU.
>
> Still, with the load the original poster was talking about, even the
> old
> Sybase 11.0.3.3 on Linux (free) could do that..
>
>

Patrick Mulvany wrote:

> *** From dbi-users - To unsubscribe, see the end of this message.
> ***
> *** DBI Home Page - http://www.symbolstone.org/technology/perl/DBI/
> ***
>
> Are but you are forgetting the Oracle Licence for internet connection.
>
> Perperutal internet licence for Oracle is based on CPU MHz therefor
> for the 2450
> (600P3x2) machine a perpertual licence will cost :- $100 x 600 x 2 =
> $120,000
>
> Even if you take to 2 year licence option with is 35% of the
> perpertual licence this
> is still $42,000.
>
> It is also recommended that you have something like silver support of
> Oracle which is
> 22% of the perpetual licence which is $26,400.
>
> The total cost of the machine is insignificant in comparison to the
> $146,400 for the
> Oracle licence.
>
> And don't even think what happens when you get to Quad or Octal
> machines <looks over
> at a 6350 and groans>.
>
> Even with the lower spec 450P3 x 2 the cost could easily be $109,800
> in Oracle
> licences.
>
> Thanks
>
> Patrick Mulvany
>
> Jeff Warner wrote:
>
> > *** From dbi-users - To unsubscribe, see the end of this
> message. ***
> > *** DBI Home Page -
> http://www.symbolstone.org/technology/perl/DBI/ ***
> >
> > I have to agree with Mark. You could easily handle this
> load on a Dell
> > 2300 or 2450 running Oracle/Linux. A decent load on a 2450
> (600P3x2, 1GB
> > RAM, RAID1 array) would cost you under $8000 and would sleep on this
> load.
> > We have a 2300 (450P3x2, 1GB RAM, RAID5 array) running 8i (nearly
> out of the
> > box and in archive mode!) and we can generate over a million
> database driven
> > e-mails per hour from a single server and the database server is
> pulling a
> > 1.5 load.
> > If your transactions are all or mostly read only, you are
> talking a light
> > load. Getcha a couple of servers, one for apache, one for database
> and
> > another for a stand-by and you'll be ready for bear.
> >
> > Jeff
> >
> > -----Original Message-----
> > From: dbi-users-bounce_at_isc.org [mailto:dbi-users-bounce_at_isc.org]On
> > Behalf Of Mark Dedlow
> > Sent: Tuesday, March 21, 2000 8:28 PM
> > To: jmaes_at_sportingnews.com
> > Cc: DBI user mailing list
> > Subject: Re: Great Database Minds
> >
> > *** From dbi-users - To unsubscribe, see the end of this
> message. ***
> > *** DBI Home Page -
> http://www.symbolstone.org/technology/perl/DBI/ ***
> >
> > > Hey all, I am hoping that some of you great database minds out
> there
> > > will be able to lend me a hand on this one.
> > >
> > > Which of the following would be better suited for a simple
> database (1
> > > table) with around a 1/2 to 1 million rows. That would receive 100
> to
> > > 500 transactions per a minute.
> > >
> > > the two choices here are
> > >
> > > Oracle 8 on a Sun box ($100,000 - $150,000)
> > > or
> > > Informix 9.2 on a Linux/Intel ($50,000)
> > >
> > >
> > > All of the load on the database will come from simple web queries,
> and
> > > updates.
> >
> > I guess by "better suited", you mean which would handle the load
> > better. I think both configurations are overkill for the
> > load you describe. I can't speak to Informix, but Oracle could
> > handle that load on a machine 1/10 that cost. 500 transactions
> > per minute == 8.3/sec. I've clocked hundreds of "simple"
> > transactions per sec on my desktop sparcstation (~3,000).
> >
> > Mark
>
Received on Fri Mar 24 2000 - 06:39:07 CST