i am trying to figure out what object is the block# pointing to...below is from ASH report
Event % Event P1 Value, P2 Value, P3 Value % Activity Parameter 1 Parameter 2 Parameter 3
db file scattered read 41.64 "44","516433","2" 0.16 file# block# blocks
db file sequential read 27.62 "41","129824","1" 0.16 file# block# blocks
read by other session 8.85 "27","323532","1" 0.25 file# block# class#
log file parallel write 2.46 "2","2","2" 0.98 files blocks requests
log file sync 2.38 "144","0","0" 0.08 buffer# NOT DEFINED NOT DEFINED
and looking at the below link...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/waitevents003.htm#sthref3028
i understand file number is the datafile number and block number would be the block number inside that datafile...but i cant find that specific object....
in the above link it says see block# (link)
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/waitevents002.htm#i970852
and it point out to this select statment which dose not exist...
select name, kind
from ext_to_obj_view
where file# = file#
and lowb <= block#
and highb >= block#;
ext_to_obj_view...it says table or view dose not exist...so i am trying to find the object name to which this block# and file# points too