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@xxxxxxxxxxx>
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?--
//www.freelists.org/webpage/oracle-l
