0 consistent gets

From: <dba.orcl_at_gmail.com>
Date: 4 Apr 2005 12:24:02 -0700
Message-ID: <1112642642.218446.42110@o13g2000cwo.googlegroups.com>

Hi:

I am getting ZERO consistent gets for SELECT statement. Is that possible?

SQL> select * from v$version;

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production NLSRTL Version 10.1.0.2.0 - Production

SQL>create table t1 as select * from dba_objects; Table created.

SQL> select count(*) from t1;

  COUNT(*)

---

     48253

SQL>create index t_ix01 on t1(object_type); Index created.

SQL>analyze table t1 compute statistics;
SQL> set autotrace on
SQL> select owner,object_id,status from t1 where object_type='VIEW';

Execution Plan

---

   0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=55 Card=1177 Bytes=27071)

   1 0 TABLE ACCESS (BY INDEX ROWID) OF 'T1' (TABLE) (Cost=55 Card=1177 Bytes=27071)

   2 1 INDEX (RANGE SCAN) OF 'T_IX01' (INDEX) (Cost=4 Card=1177)

Statistics

---

          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
          0  bytes sent via SQL*Net to client
          0  bytes received via SQL*Net from client
          0  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
       3492  rows processed

SQL> Received on Mon Apr 04 2005 - 14:24:02 CDT