As well as endorsing Bruce's post, on a great many systems, the main cause of this style of contention is poor sql, where 'poor' means massive buffer gets due to either coding or executions. Take a look in v$sql and see if there are any obvious candidates.
hth connor --- Robertson Lee - lerobe <[EMAIL PROTECTED]> wrote: > All, > > Oracle 8.0.5 > Tru64 4.0f > > I was doing a stats pack analysis and noticed that > we had "latch problems". > I drilled in a bit further and it would appear that > the issue was down to > cache buffer chains. > > The Metalink article (I was flying blind here) > states > > "To identify the heavily accessed buffer chain look > at > the latch stats for this latch under > <View:V$Latch_Children>" > > I did this and it came back with over 10000 rows > !!!! > > Can someone give me a little guidance here ?? > > Regards > > Lee > > > > > The information contained in this communication is > confidential, is intended only for the use of the > recipient > named above, and may be legally privileged. If the > reader > of this message is not the intended recipient, you > are > hereby notified that any dissemination, distribution > or > copying of this communication is strictly > prohibited. > If you have received this communication in error, > please > re-send this communication to the sender and delete > the > original message or any copy of it from your > computer > system. > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
