Mark, how do you manually remove objects from buffer cache? I saw you
writing before that you know how to do it and I would be very interested to
know also if it is not trade secret of course.
Alex Hillman
-Original Message-
Sent: Friday, May 04, 2001 11:11 PM
To: Multiple recipients of
I think if you offline a tablespace (or is it
read-only? I can't remember), then any relevant
buffers are flushed out...
hth
connor
--- Hillman, Alex [EMAIL PROTECTED]
wrote: Mark, how do you manually remove objects from
buffer
cache? I saw you
writing before that you know how to do it and I
Bunyamin,
You can check how many blocks are in the buffer cache for segments through
the x$bh and v$bh views.
Try this query,
select count,b.object_name from
(select count(*) count,objd from v$bh
group by objd) a, user_objects b
where a.objd=b.data_object_id
/
Regards
Suhen
Hi