Why not just use ASH *current_obj#* and *current_file#* fields? (or their
row_wait_obj#, row_wait_file# equivalents in v$session?)
With ASH, this would do the trick (or add current_obj# directly to see the
object ID of a partition too):
@ashtop username,objt "event like 'cell single%'" sysdate-1/24 sysdate
--
Tanel Poder
https://tanelpoder.com/events
On Wed, Aug 26, 2020 at 5:30 PM Andrew Kerber <andrew.kerber@xxxxxxxxx>
wrote:
I am trying to track down tablespace and file on an exadata for cell
single block physical read. the P1/P2/P3 are cellhash#, diskhash#, and
bytes. Does someone have a sql query to translate that to tablespace and
file?
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'