x$bh找到buffer cache属于哪个pool

select x$bh.set_ds,x$bh.* from x$bh where x$bh.set_ds = '000007FFBDDA4EA8';

--根据缓存所属集合，找到集合的id
select x$kcbwds.set_id,x$kcbwds.addr from x$kcbwds where x$kcbwds.addr = '000007FFBDDA4EA8';

--根据每个pool所跨的集合id范围，确定对应的集合属于哪个pool
select x$kcbwbpd.bp_lo_sid, x$kcbwbpd.bp_hi_sid,x$kcbwbpd.*
	from x$kcbwbpd
 where x$kcbwbpd.bp_lo_sid <= 9
   and x$kcbwbpd.bp_hi_sid >= 9;

select x$bh.set_ds,count(*) from x$bh group by x$bh.set_ds;