Autotrace displays a lot of statistics information as 0 ()

A friend used autotrace to view the database execution plan and found that the result is as follows. Many information in statistics is 0, which is definitely abnormal. Everything can be 0, and the consistent gets cannot be 0.

SQL> set autot onSQL> select count(*) from RACV_DATA.PARTY_DUMMY;   COUNT(*)----------        47 Elapsed: 00:00:00.00 Execution Plan----------------------------------------------------------Plan hash value: 3621440939 --------------------------------------------------------------------------| Id  | Operation          | Name| Rows| Cost (%CPU)| Time|--------------------------------------------------------------------------|   0 | SELECT STATEMENT   |             |     1 |     3   (0)| 00:00:01 ||   1 |  SORT AGGREGATE    |             |     1 |            |          ||   2 |   TABLE ACCESS FULL| PARTY_DUMMY |    47 |     3   (0)| 00:00:01 |--------------------------------------------------------------------------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)          1  rows processed

Solution

SQL>  select owner,object_name from dba_objects where object_name=‘PLAN_TABLE‘; no rows selected SQL> @?/rdbms/admin/utlxplan.sql Table created.

Review statistics information

Statistics----------------------------------------------------------          0  recursive calls          0  db block gets          7  consistent gets          0  physical reads          0  redo size        522  bytes sent via SQL*Net to client        524  bytes received via SQL*Net from client          2  SQL*Net roundtrips to/from client          0  sorts (memory)          0  sorts (disk)          1  rows processed

Http://www.xifenfei.com/3306.html

Autotrace displays a lot of statistics information as 0 ()