Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 0 consistent gets
<dba.orcl_at_gmail.com> wrote in message
news:1112642642.218446.42110_at_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>
>
logged in as sys by any chance? Received on Mon Apr 04 2005 - 15:04:21 CDT