select distinct t.owner, t.table_name
from v$bh bh, dba_objects o, dba_tables t, v$parameter p
where o.data_object_id = bh.objd
  and t.owner = o.owner
  and t.table_name = o.object_name
  and t.buffer_pool = 'KEEP'
  and p.name = 'buffer_pool_keep'
  and ( p.value is not null and p.value != '0' )
order by 1, 2
/

select distinct t.owner, t.table_name
from
v$bh b join dba_objects o on (o.data_object_id = b.objd)
join dba_tables t on (t.table_name = o.object_name and t.owner = o.owner)
where
t.buffer_pool = 'KEEP'
and b.status <> 'free'
order by 1, 2
/

select distinct t.owner, t.table_name
from v$bh bh, dba_objects o, dba_tables t, v$parameter p
where o.data_object_id = bh.objd
  and t.owner = o.owner
  and t.table_name = o.object_name
  and t.buffer_pool = 'KEEP'
  and p.name = 'buffer_pool_keep'
  and ( p.value is not null and p.value != '0' )
  and bh.status != 'free'
order by 1, 2
/