Post the STATSPACK as a text attachment.
We started have 'reviews' of such things a little
while back on the newsgroup and haven't seen
one recently.
Has your 'block gets' also climbed and your
'blocks pinned' dropped at the same time ?
--
Jonathan Lewis
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
See http://www.jlcomp.demon.co.uk/book_rev.html
For latest news of public appearances
See http://www.jlcomp.demon.co.uk
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Scott Gamble wrote in message ...
>OS = TRU64 4.0F
>CPUS = 12
>DB = 8.1.7.1 + one off patch to address 4031 issues
>
>Has anyone run into very high 'cache buffers chains' contention
>after upgrading to 8.1.7.1 with no application changes at all.
>Sounds _very_ similiar to a bug that was reported in addition to the
>above mentioned one off patch we applied. However it was included
>in the 'fix list' for the 8.1.7.1 path so supposedly is fixed, yet
>we are showing extraordinary contention.
>
>Our application did not change, and the execution plans did not
>change either. Yet with the upgrade from 8.0.6.1 to 8.1.7.1
>our latch contention has gone through the roof, to the point
>where the application is almost unusable.
>
Received on Thu Aug 23 2001 - 09:47:17 CDT
