Re: Oracle 10G experiences

Comments in-line.

1. Zarins wrote:

> I was wondering if I could get feedback on peoples experiences with
> 10G, specifically in large data warehouse environments, or ETL
> environments.
> The product has been out for close to a year now, and we are
> considering
> putting it into our development areas. Is 10G
>
> - Stable?

Solid as a rock with all 9i functionality and much of the new 10g.

   Any issues re installation or running 9i and 10G on the
> same server.

Not that I am aware of but then I am against running more than one instance on a single machine unless it is a very very small one such as an OEM repository.

> - Performance. Any benchmarks, observations from the "real" world
> (meaning
> not a Oracle sales rep) on performance gains, especially if they
> involve
> direct load/insert, aggregation, OLAP type rollups
> (multi-dimensions), and
> calculations. Assume a 2 to 3 terabyte warehouse with a 150 Gig
> monthly
> data load.

I find 0-25% improvement in performance.

> - Any problems, concerns, issues, or surprises?

I've yet to have a happy experience with DataPump.

> - Any feedback on the 10G patchset released in August.

Still in evaluation.

> Much appreciated.

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)