Re: Which Version of Oracle RDBMS to use for a new system?

From: Michael Gast <mig-sm_at_web.de>
Date: Mon, 17 May 2004 10:26:15 +0200
Message-ID: <40a87761$0$262$4d4ebb8e@read.news.de.uu.net>

Hi Hans,

Hans Forbrich schrieb:
> Michael Gast wrote:
>

>> Hi all,
>> 
>> what version of the Oracle RDBMS would you use for a new system being
>> developped during the next six months? The system does not necessarily
>> need any of the new features of Oracle 10g.
>> 
>> What points for Oracle 9.2 and what for Oracle 10g?
>> 
>> Thanks a lot for your opinions.
>> 

>
> Look at the end user and end administrator requirements.
>
> Also look at the development model.
>
> If you are developing toward the 'Oracle is a highly
> available/scalable/reliable version of MS Access' model, then pick any
> supported version.
>
> If you are using the development model as described in Thomas Kyte's Expert
> One on One Oracle, where you are determined to save yourself development
> cost and your customer maintenance and administration cost, then develop
> toward the full set of capabilities in 9i and look at the features of 10g
> to see whther you can further expand on the savings using the 10g feature
> set.
>
> My suggestion - start by reading (and understanding) Kyte's book. Then read
> the New Features doc for 9i. Then read the new features doc for 10g. Then
> start you development plans.
>
> My fear - you've already decided the model and just want a super SQL base to
> hand back results of SQL queries rathen than hand back answers to problems.
> In which case 9i likely will do quite nicely.

Thanks a lot for your valuable suggestions.

We want to build a new standard system for a special market to be used in medium to large scale companies. Unfortunately, we don't know much of the end user and end admin requirements. But we know that most of them currently use Oracle as RDBMS in different versions up to 9i.

I've allready read all documents you suggest (the new features doc for 10g up to now not in depth but i will do it soon). I've also read Thomas Kyte's book Experts One-on-One and i want to use its development model as basic guideline for the project - adopted to the new features in 9i and probably 10g. I don't want to use Oracle as some kind of "Super SQL base". From my point of view this does not make much sense. With my experience in former projects i know that deeply understanding the architecture and using the special features of the RDBMS speeds up the implementation process and results in 'better' - that means faster, more reliable, more secure, etc. - systems.

Up to now, there is no decision in regard to the Oracle version made in this project.

The only point i wanted to ask for is: Does we take high risks when we decide to implement for Oracle 10g? Are there any known issues with e.g. reliability, speed etc?

-- 
Mit freundlichen Grüßen / Best regards
Michael Gast
SEPP MED GmbH

All emails sent to this address are never read and never will be
answered. Sorry, but until someone cleans up the spam mess, that's the
way it has to be.

E-Mails, die direkt an diese Adresse geschickt werden, lese und
beantworte ich nicht. Ich bedauere diesen Umstand sehr, kenne derzeit
aber keine bessere Möglichkeit, um die Spam-Flut abzustellen.

Received on Mon May 17 2004 - 03:26:15 CDT