Re: Do I really need more than 1 rollback segment?

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 platformspecific  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