What does it mean when v$filestat.avgiotim has a negative value?

From: Jeffrey Yee <jeffyee_at_hotmail.com>
Date: 12 Oct 2003 20:21:39 -0700
Message-ID: <ec4cec95.0310121921.5131d519@posting.google.com>

Hi,

I run the following sql statement:
  select f.FILE#, ts.name "TABLESPACE", d.name "DATAFILE",

         f.PHYRDS, f.PHYWRTS,
	 f.AVGIOTIM, f.MINIOTIM, f.MAXIORTM, f.MAXIOWTM

  from v$filestat f, v$datafile d, v$tablespace ts   where f.file# = d.file#
    and d.ts# = ts.ts#

and this is the result I get:

1,SYSTEM,/ovo_data/oradata/system_1.dbf,1695726,2221,-1184695209,0,18,1
2,TEMP,/ovo_data/oradata/temp_1.dbf,69077,101054,65535,0,0,0
3,RBS1,/ovo_data/oradata/RBS1_1.dbf,81478,2208043,1437347278,0,19,2
4,TOOLS,/ovo_data/oradata/tools_1.dbf,229,229,0,0,1,0
5,OPC_TEMP,/ovo_data/oradata/OPC_TEMP_1.dbf,2203442,1535091,0,0,2,0
6,OPC_1,/ovo_data/oradata/OPC_1_1.dbf,72161915,131881,-1623892274,0,155,2

It shows that the system and opc_1 tablespaces has avgiotim in negative value. I'm confuse, as the oracle document did not mention anything about this. Can someone please help. Thank you in advance.

Best Regards,
Jeffrey Yee Received on Sun Oct 12 2003 - 22:21:39 CDT