Database Administration (MOSC)

MOSC Banner

Negative buffer_gets on oracle 9i

edited Jan 14, 2009 8:43AM in Database Administration (MOSC) 1 comment
 Hi

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center