Re: Latch free

From: biti_rainy <biti_rainy_at_itpub.net>
Date: Mon, 26 Apr 2004 23:19:33 +0800
Message-Id: <20040426150608.11D2072C9E6@turing.freelists.org>

hi,syed jaffar hussain

    maybe you are not use bind var     the cache buffer chain :
    v$latch_children.addr(name =3D cache buffer chains) join to =  x$bh.hladdr , x$bh.dbablk between dba_extents.block_id and=  dba_extents.block_id+blocks .       

Best regards

yahoo id: feng_chunpei
A new dba from china

• from the mail-----
  >Hi List,
  >
  >When I took statspack report and I clearly see that my system=
  is
  >suffering heavily with latchfree wait problem. There were a lot=
  of
  >latches on library cache and cache buffers chains. Surprisingly,=
  I found
  >session_cached_cursors=3D0 value, I recently joined this company,=
  and the
  >problem is I can't bounce the DB as its 24*7 to change the=
  values, so,
  >what I did is, wrote a database logon trigger and set thses=
  parameter
  >value=3D10 as dynamically by altering session, as we are using=
  8.1.7.4
  >version. Is I am doing right or this doesn't effect? To reduce=
  the cache
  >buffes chains, I am figuring out what the hottest block/buffer=
  in the
  >cache is and why it is hot. Please recommend something.
  >
  >Best Regards,
  >
  >Syed Jaffar Hussain
  >----------------------------------------------------------------=
  

>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------=

>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>.

=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Apr 26 2004 - 10:15:46 CDT