Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data Access Time
Select the pseudocolumn ROWID in your query. It has 18 positions in the format xxxxxxxx.xxxx.xxxx. The first 8 positions identify the block #, positions 10 thru 13 identify the row # (first row is 0000) and positions 15 thru 18 identify the datafile #. Use the SUBSTR function to get the block # and datafile # (those 2 values should be of interest to you).
Hope this helps.
Michael Serbanescu