ANd make sure you go past 8.1.7.0. Had a small memory leak problem. I also
ran into a slight problem going from (I think - this is in old memory and
the brain cells for that are just about gone under the influence of too much
good Australian red wine!) 8.1.7.0 to 8.1.7.2 because someone else closed
the database down BUT forgot to stop the AQ queues - ugh! It was ugly.
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Currently writing the "Oracle9i New Features for Administrators Exam Cram"
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:1008851523.275.0.nnrp-01.9e984b29_at_news.demon.co.uk...
>
> Re moving from 8.0.6 to 8.1.7
>
> Watch out for bug 1967363 - relating to the
> cache buffers chains latches for index root
> blocks becoming very hot - initial symptom
> is a dramatic increase in waits for 'latch free'
> which can be identified as sleeps on the
> 'cache buffers chains' latch' and then
> tracked to x$bh.hladdr via v$latch_children.addr
> to blocks which are the second block of index
> segments.
>
> I believe you can put in a request for platform-
> specific patches when needed.
>
>
> Looks like your '4 peaked at 400M' is sufficient
> reason for 400MB rbs by the way.
>
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
> Screen saver or Life saver: http://www.ud.com
> Use spare CPU to assist in cancer research.
>
> Nuno Souto wrote in message <3c21d4ac.1430317_at_news>...
> >Yup. That's how I arrived at the 400M size. Left it much smaller,
> >then watched how much they growed in heavy batch use. 4 peaked at
> >400M. 4 being the number of concurrent batch jobs we allow.
> >
> >
> >Starting to move them to 8.1.7 from 8.0.6 during the Xmas break as
> >well. Wish me luck.
> >
> >
> >Cheers
> >Nuno Souto
> >nsouto_at_optushome.com.au.nospam
>
>
Received on Thu Dec 20 2001 - 10:00:24 CST
