Home » SQL & PL/SQL » SQL & PL/SQL » Re: Extremely high Consistent Gets and DB Buffer Gets
Re: Extremely high Consistent Gets and DB Buffer Gets [message #19234] Wed, 06 March 2002 08:18
Steve Karam
Messages: 3
Registered: March 2002
Junior Member
Before, the query returned the same number of rows, but did 0 recursive calls, 0 db block gets, at most 8000 consistent gets, and 0 physical reads. I know if I have to choose, I'd rather consistent gets and db block gets. But why did it go up so high?

Report message to a moderator

Previous Topic: how to generate random records
Next Topic: illegal use of LONG datatype
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 18:58:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.