--
-- buffer_map.sql
-- by Brian Peasland
-- 28 December 2000
--
-- This script will display a map of the Buffer Cache.
-- This script MUST BE RUN AS SYS!!!!

SELECT b.buf# AS buff_num, u.name AS owner, o.name AS segment_name,
       DECODE(b.state,0,'Free',1,'Modified',2,'Not Modified',
              3,'Being Read','Other') AS state
FROM   sys.x$bh b, sys.user$ u, sys.obj$ o
WHERE  b.obj = o.obj# AND o.owner# = u.user#
/