Negative buffer_gets on oracle 9i
I am on oracle 9.2.0.7 on RHEL 4. I see negative buffer_gets in v$sqlarea. How do I interpret this. Thanks
Mukesh
1 select buffer_gets, executions , (buffer_gets / executions ) bgp from v$sqlarea
2* where hash_value = 551667471
SQL> /
BUFFER_GETS EXECUTIONS BGP
------------------------ ------------------------ ------------------------
-1,290,712,912 486,341 -2,654