negative dates in v$ tables

From: <shcho_at_banmail.ml.com>
Date: 1995/05/03
Message-ID: <D80pGq.4tF_at_tigadmin.ml.com>#1/1


When querying the writetim column in the v$filestat dynamic performance table, I obtain the value -9.23E+08. I understand thatOracle starts "wrapping around" on time values if the db is up for an extended period of time.

     Does anyone know a workaround to this problem? At what point do these times "max out"? Is there an algorithim I can use to convert these bogus negative numbers into positive numbers?

     Any advice would be greatly appreciated.

Sheck Cho
shcho_at_banmail.ml.com Received on Wed May 03 1995 - 00:00:00 CEST

Original text of this message