RE: 8i Buffer Headers Dump & touch count

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 8 Sep 2000 01:58:14 +1000
Message-Id: <10612.116414@fatcity.com>

Hi Gopal,

If you take the 'buffers' dump at level 4 that will give the information, but it is not an easy dump to read. An awk or perl script to translate that ordered list of buffer header addresses into an order list of file and block number would be very useful. I started work on one some years ago, but I never finished it. I do have a script that does the same from X$BH but it stopped working after 7.2 and I have not fixed that either. Happy scripting!

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal_at_yahoo.com] Sent: Thursday, 7 September 2000 16:25
To: Oracle-l_at_fatcity.com
Cc: oracledba_at_lazydba.com
Subject: 8i Buffer Headers Dump & touch count

I want to figure out the position
of a buffer in the hash chain at any given point of time. How do I trace that?

The buffer header dump does NOT show the position. Anyway I can get the position of a buffer in X$ entry Received on Thu Sep 07 2000 - 10:58:14 CDT