IO-TIME in V$FILESTAT
From: Hameed, Amir <amir.hameed_at_sleepnumber.com>
Date: Fri, 19 Nov 2021 17:40:54 +0000
Message-ID: <CH0PR14MB501250B053DE137ADD445F84E09C9_at_CH0PR14MB5012.namprd14.prod.outlook.com>
Hi,
I would like to ask a general question. How reliable are READTIM, SINGLEBLKRDTIM, AVGIOTIM statistics in V$FILESTAT in 11.2.0.4 and 12.1.0.2? I vaguely remember someone had advised me a while ago not to rely on these statistics.
Date: Fri, 19 Nov 2021 17:40:54 +0000
Message-ID: <CH0PR14MB501250B053DE137ADD445F84E09C9_at_CH0PR14MB5012.namprd14.prod.outlook.com>
Hi,
I would like to ask a general question. How reliable are READTIM, SINGLEBLKRDTIM, AVGIOTIM statistics in V$FILESTAT in 11.2.0.4 and 12.1.0.2? I vaguely remember someone had advised me a while ago not to rely on these statistics.
Any feedback will be appreciated.
Thanks,
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 19 2021 - 18:40:54 CET