How to get data file name from p1 p2 p3 cell single block physical read
From: Moustafa Ahmed <moustafa_dba_at_hotmail.com>
Date: Fri, 29 Jan 2021 20:27:40 +0000
Message-ID: <DM5PR06MB2796DA38E494F6068FC06A4CE1B99_at_DM5PR06MB2796.namprd06.prod.outlook.com>
Hello listers
Date: Fri, 29 Jan 2021 20:27:40 +0000
Message-ID: <DM5PR06MB2796DA38E494F6068FC06A4CE1B99_at_DM5PR06MB2796.namprd06.prod.outlook.com>
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
Received on Fri Jan 29 2021 - 21:27:40 CET