Re: Translate p1/p2/p3 for cell single block phyiscal read
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Wed, 26 Aug 2020 20:54:17 -0400
Message-ID: <CAMHX9JLbit+CuG5bqEJSSd9p6WKCLgG+bwpHEAoU+HpVBA=3kQ_at_mail.gmail.com>
Date: Wed, 26 Aug 2020 20:54:17 -0400
Message-ID: <CAMHX9JLbit+CuG5bqEJSSd9p6WKCLgG+bwpHEAoU+HpVBA=3kQ_at_mail.gmail.com>
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):
_at_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_at_gmail.com> wrote:Received on Thu Aug 27 2020 - 02:54:17 CEST
> 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.'
>
-- http://www.freelists.org/webpage/oracle-l