RE: Tracking buffer gets by tablespace

--openmail-part-096a8b14-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

Patrice,

I believe you can do this by turning trace on (and/or) setting the right events in init.ora (or at the session level) using the 'alter session set events '10046 trace name context forever, level 8'.

This should generate the raw trace files which you then look at by grepping for the word 'db file' and looking for the p1 parameter which indicates the file#.

have never tried it - just a wild idea derived from elsewhere, so YMMV!

John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-096a8b14-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: 7bit

<binary content removed -- do not send binaries to the list>

--openmail-part-096a8b14-00000001--
Received on Thu Jun 29 2000 - 03:02:14 CDT