|
Ethan,
Cool utility! Wow, thanks for sharing this with us.
The timing couldn't have been more perfect. I used it immediately for a problem
I was working on. I thought I would share it with everyone.
We have a little situation here, management
wants a certain tuning excercise be played out. Part of the requirement was that
the buffer cache should be empty before each change - a reasonable request.
Since there was no way the buffer cache could be flushed, a technique (thanks to
Tom Kyte) employed was to make the tablespace offline and then online again.
This would flush all the blocks of the files of that tablespace. However, most
people did not agree that offlining and onlining a tablespace would flush the
buffers. Using filemon, I proved that it did. In filemon, I searched for the
datafiles of the tablespace only. Fired up a select from a table; the files were
opened and shown by filemon. Then I queried again; this time the files were not
opened and queried by oracle, because the blocks were found in buffer cache.
Offline, online the tablespace and repeat ... voila... the files show up again.
The skeptic minds are silent now.
Thanks again.
Arup
|
Title: Message
- filemon Post, Ethan
- RE: filemon Hately, Mike (NESL-IT)
- RE: filemon Arup Nanda
- RE: filemon Jesse, Rich
