Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!proxad.net!proxad.net!194.117.148.138.MISMATCH!pe2.news.blueyonder.co.uk!blueyonder!pe1.news.blueyonder.co.uk!blueyonder!text.news.blueyonder.co.uk!53ab2750!not-for-mail
From: "Dave" <x@x.com>
Newsgroups: comp.databases.oracle.server
References: <1112642642.218446.42110@o13g2000cwo.googlegroups.com>
Subject: Re: 0  consistent gets
Lines: 64
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
Message-ID: <95h4e.3962$G8.3288@text.news.blueyonder.co.uk>
Date: Mon, 04 Apr 2005 20:04:21 GMT
NNTP-Posting-Host: 82.39.109.209
X-Complaints-To: abuse@blueyonder.co.uk
X-Trace: text.news.blueyonder.co.uk 1112645061 82.39.109.209 (Mon, 04 Apr 2005 21:04:21 BST)
NNTP-Posting-Date: Mon, 04 Apr 2005 21:04:21 BST
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:239608


<dba.orcl@gmail.com> wrote in message 
news: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>
>

logged in as sys by any chance?