Re: How to get data file name from p1 p2 p3 cell single block physical read
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Sat, 30 Jan 2021 11:24:26 +0000
Message-ID: <CAGtsp8=3R+Cd5Cz6KwbpptkdRwr3hNkcEKn1f=1c4_Pvdvnk0w_at_mail.gmail.com>
Date: Sat, 30 Jan 2021 11:24:26 +0000
Message-ID: <CAGtsp8=3R+Cd5Cz6KwbpptkdRwr3hNkcEKn1f=1c4_Pvdvnk0w_at_mail.gmail.com>
Ash doesn't need to use the p1, p2, p3 parameters to idenify the segment, the object_id (probably with a minor name change that I don't recall off-hand) is a column in v$active_session_history.
Regards
Jonathan Lewis
On Fri, 29 Jan 2021 at 20:27, Moustafa Ahmed <moustafa_dba_at_hotmail.com> wrote:
> Hello listers
>
> What is the best way to get data file name from p1 p2 p3 ...
> I have noticed that in many cases specially with (delayed block clean out)
> Ash will report top segments for
> cell single block physical read As the index or table yet as expected the
> top data file is undo!
> Which is correct but how did the ash report deduce that from p1 p2 p3?
> If so how?--
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 30 2021 - 12:24:26 CET