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

Hi,
 cool, you can call that an Oracle ;-) it does know the answer before you even ask a question.

 seriously, i have seen this kind of thing happen when some counter overflows:
 tablespaces with heavy i/o maybe ???

 Not sure whether that's the case for you - I wouldn't expect system to be heavily hit.

Karsten  

jeffyee_at_hotmail.com (Jeffrey Yee) wrote in message news:<ec4cec95.0310121921.5131d519_at_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 Mon Oct 13 2003 - 08:20:02 CDT