Coskan’s Approach to Oracle

July 23, 2007

latch: cache buffer chain with negative address value

Filed under: Tips — coskan @ 2:40 pm

Sometimes I face with negative P1 value from the 10046 trace output of some sessions. The output like below
WAIT #9: nam=’latch: cache buffers chains’ ela= 1 p1=-4611686000696528624 p2=116 p3=0

When I try to convert this value to hexadecimal to use as an input to find the hot block (metalink note id 163424.1) . I searched internet, metalink but I couldn’t find any answer, till Ogun Heper, one of the members of Turkish Oracle Users (DBA & Developers), answered the reason of my problem.

The reason was simple, the sign bit of the p1 value was 1 and this causes to get negative value when using 64 bit OS.
If you want to convert it to hexadecimal value by using Glenn Fawcetts useful convertion script, you must first add 2 to the power 64 to the p1 value then convert the value to module 16.

You can find the modified script of Glenn Fawcett here


1 Comment »

  1. Hi, i am working on oracle about 2 years i am ocp and dba in a company in turkey, it is great cure for me when i am scrambling “cache buffer chain” latches waits in these days.


    Merhaba, yaklaşık 2 yıldır oracle üzerinde çalışıyorum türkiyede özel bir şirkette dba yim. “cache buffer chain” latch ları ile uğraştığım bu günlerde döküman harika bir ilaç oldu benim için tekrar teşekkürler.

    Comment by Fatih — February 12, 2008 @ 9:48 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Blog at

%d bloggers like this: