Re: cache buffer chains

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Fri, 17 May 2002 01:08:18 -0800
Message-ID: <F001.004633DE.20020517010818@fatcity.com>

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 <lerobe_at_acxiom.co.uk> 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: hamcdc_at_yahoo.co.uk

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: ListGuru_at_fatcity.com (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).

Received on Fri May 17 2002 - 04:08:18 CDT