RE: db block get vs consistent gets

Stephane - I believe that Cary Millsap (www.hotsos.com) has studied this issue in quite some detail.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 3:14 PM To: Multiple recipients of list ORACLE-L

Re: db block get vs consistent gets

Stephane, The cost of an LIO is determined by many things. It used to be that one row access was one LIO. Now a days you will see that many rows are gotten in a single LIO. That means that the single LIO is more expensive. You will see that depending on the access plan oracle will access one or m

db block get vs consistent gets

Has anybody figures about the CPU cost of a consistent get vs a db block get? I have always expected it to be higher but not extremely higher. I have had a bad surprise today on a process-of-death which I am trying to salvage (although it looks a bit more like the last sacrament rather than a cure