Re: Regarding the number of consistent gets.

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 19 Sep 2005 05:25:22 -0700
Message-ID: <1127132722.089701.150070@g14g2000cwa.googlegroups.com>

Buy Tom Kyte's book on Effective Oracle by Design it has all the details or check out asktom.oracle.com. Guy Harrison also has a good SQL tuning book that could help you.

You are very off in your understanding of logical memory versus physical memory. What is logical memory?

When oracle is processing a query it may have to touch and look at data which comes out of blocks in the database.

If the query processes the same block more than once ( can happen for lots of reasons ) the block is counted twice.

Neither the db_cache_size or the db_block_size are factors in how many consistent gets a query requires.

The SQL that was written and the execution plan that the oracle optimizer uses are factors in how many consistent gets a query uses. Received on Mon Sep 19 2005 - 07:25:22 CDT