RE: Oracle out the door
Date: Wed, 30 Apr 2008 09:08:25 -0400
Shameless plug indeed, but good product as I have tried using it in the past. The problem is that it comes with a license cost which in some shops is the "blue screen of death" since it can be downloaded & used directly from postgresql.org. And even though EnterpriseDB has done a very good job of porting Oracle functionality into PostgreSql, it's not 100% transparent which means some re-engineering nonetheless.
BTW: When I was using PostGreSql I had two real problems with it that I believe have been fixed & maybe you can comment on the fixes. The first was the need to "vacuum" the db regularly so that the equivalent of the Oracle SCN would not wrap onto itself. The second was that all of the db files had to be on a single mount point so that your database was limited to the size of a mount and if you ever got it to 100% used the db would crash, badly.
Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com 45 Bartlett St. / Marlborough, MA 01752
Together: the Collaborative Business Experience
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Derek Rodner Sent: Tuesday, April 29, 2008 6:10 PM
To: gints.plivna_at_gmail.com; jhthomp_at_gmail.com Cc: oracle-l_at_freelists.org
Subject: RE: Oracle out the door
Sorry, but I am going to put a shameless plug in here. Has your company looked at EnterpriseDB? It is based on Postgres, but we added a ton of Oracle features including PL/SQL syntax support, Oracle Packages, system views, stored procedures, etc, etc, etc.
Ok, shameless plug over.
Derek M. Rodner
732.331.1333 office 484.252.1943 cell www.enterprisedb.com
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gints Plivna Sent: Tuesday, April 29, 2008 5:48 PM
Subject: Re: Oracle out the door
Following ideas comes to mind:
1) Have you/your company considered other editions than EE? I.e. SE, SE One, trying to get discounts, optimizing (e.g. throwing several apps on the same boxes) environments?
2) Have you/your company calculated all other costs connected with database change i.e. staff skills, possibility to rebuild applications totally from scratch, possibility to have various kind of problems because of lack of knowledge and migration to other DBMSes? A while ago I've summarized a few criteria for choosing DBMS and the main message I'd like to offer is - as probably everyone knows - the cost of DB is not the same as the cost of DBMS licence. In case anyone is interested the article is here http://gplivna.eu/papers/choose_database.htm
2008/4/29 John Thompson <jhthomp_at_gmail.com>:
> Company I work for just announced that we're going to convert all but
> our 89 Oracle databases to either SQL Server, MYSQL, or PostgreSQL.
> is due to the high licensing cost. I'm bummed.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 30 2008 - 08:08:25 CDT