Re: 9.2.0.5 is available for win32

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<407117ac$0$3304$ed9e5944_at_reading.news.pipex.net>...
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1081006651.655924_at_yasure...
> > I will give it to you as specifically as I can ... my chief
> > technical contact at Oracle ... sorry can't name names ...
> > when asked about installing the 9.2.0.5 patch said in two words,
> > and I quote: "Don't ... Wait". That is all I know. In the next
> > breath he said the 9.2.0.4 CD set just released is fine.
>
> Not so much the 2 words as the pause between them then. Don't wait is of
> course an unhesitating recommendation!
>
> > I'd suggest watching metalink for awhile and not applying it
> > unless it specifically fixes a known problem.
>
> I'm not sure I like the look of users must use 10.1 OUI to ensure that
> future patches can be applied. There is some interesting stuff in there
> about what happens if you install 9.2.0.4 before creating a database, which
> has been my practice for new databases. Possibly it is wiser to install the
> base release create your new db and then migrate it.
>
> There is as always an interesting list of bugs that are fixed. At least some
> of the following might be worth an upgrade alone

<snip>

> 6. An auto extensible undo tablespace may grow before reusing expired
> extents.

Niall,

I'm very glad to hear that.
in 9.2.0.4 (RHEL 3.0 ES)
we were blowing thru 4 GB of UNDO with an undo retention time = 300 (seconds) to load about 600 MB of data into IOTs.

oracle was not releasing any undo space.

thanks,

Paul Received on Mon Apr 05 2004 - 10:05:27 CDT