Hi All,
we are just about to start a sizable project (1-2TB (disk) EDW with
200+ users) and the client is AIX 5.1 Oracle 9.2.

The mostly likely timeframe for 'production' is somewhere around the
middle of next year I would think....maybe a bit sooner but certainly
not before April.

The questions have come up:
1. Should we start the design work with 10G (AIX) in mind?
2. Should we be planning to use 10G features on day 1? (That is be 100%
committed to 10G from day 1?)
3. Is 10G ready for such 'prime time'? (Of course it's no use asking
Oracle that question...)

Are other folks out there finding 10G does what it is supposed to do
with a similar level of reliability to 9.2?

Much appreciate any thoughts, advice and guidance on this....

(I am told there is 'lots and lots' of great stuff in 10G that is not
in 9.2....but I worry whether Oracle has ironed out all the
bugs....call me crazy...;-) )

Best Regards
Peter Nolan

peter@peternolan.com wrote:

> Hi All,
> we are just about to start a sizable project (1-2TB (disk) EDW with
> 200+ users) and the client is AIX 5.1 Oracle 9.2.
>
> The mostly likely timeframe for 'production' is somewhere around the
> middle of next year I would think....maybe a bit sooner but certainly
> not before April.
>
> The questions have come up:
> 1. Should we start the design work with 10G (AIX) in mind?
> 2. Should we be planning to use 10G features on day 1? (That is be 100%
> committed to 10G from day 1?)
> 3. Is 10G ready for such 'prime time'? (Of course it's no use asking
> Oracle that question...)
>
> Are other folks out there finding 10G does what it is supposed to do
> with a similar level of reliability to 9.2?
>
> Much appreciate any thoughts, advice and guidance on this....
>
> (I am told there is 'lots and lots' of great stuff in 10G that is not
> in 9.2....but I worry whether Oracle has ironed out all the
> bugs....call me crazy...;-) )
>
> Best Regards
> Peter Nolan
>

Yes, yes, and yes with one caveat. A few new 10g features have had a
few challenges such as data pump but most are very stable. Check
metalink and test before implementing.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

peter@peternolan.com wrote:

> Hi All,
> we are just about to start a sizable project (1-2TB (disk) EDW with
> 200+ users) and the client is AIX 5.1 Oracle 9.2.
>
> The mostly likely timeframe for 'production' is somewhere around the
> middle of next year I would think....maybe a bit sooner but certainly
> not before April.
>
> The questions have come up:
> 1. Should we start the design work with 10G (AIX) in mind?
> 2. Should we be planning to use 10G features on day 1? (That is be 100%
> committed to 10G from day 1?)
> 3. Is 10G ready for such 'prime time'? (Of course it's no use asking
> Oracle that question...)
>
> Are other folks out there finding 10G does what it is supposed to do
> with a similar level of reliability to 9.2?
>
> Much appreciate any thoughts, advice and guidance on this....
>
> (I am told there is 'lots and lots' of great stuff in 10G that is not
> in 9.2....but I worry whether Oracle has ironed out all the
> bugs....call me crazy...;-) )
>
> Best Regards
> Peter Nolan

Opinion ...

I'm personally convinced that 10g is prime-time based on what I've seen of
the features and have used myself. I would certainly look to using Oracle
Database 10g for this project, for the following reasons:

1) Anything that was introduced in 9iR2 or earlier seems rock solid in 10g;
2) Seems like 10gR2 is on it's way already, if I read the announcements from
Open World right;
3) By the time you go into production, the release will have over 1 year of
'maturity', so you are just fighting a few new features, which will likely
have been debugged by then (if they are not already);
4) You can review the actual 'new' feature set in the New Features document
and determine whether they make any sense for the project requirements.


That said, I know no one who has moved to 10g on AIX yet, as this area is
either Windows/Solaris/Linux on 9i/10g or very cautious orgs using AIX and
slowly moving up from 8i. So for the AIX side, I concur with Daniel -
check Metalink.

HTH/Hans