oracle 统计信息全为0的解决办法

最新推荐文章于 2024-11-13 10:59:25 发布

yrg5101

最新推荐文章于 2024-11-13 10:59:25 发布

阅读量181

点赞数

分类专栏： oracle基本知识文章标签： oracle disk sql object table

本文链接：https://blog.csdn.net/yrg5101/article/details/7645048

版权

oracle基本知识专栏收录该内容

75 篇文章 0 订阅

订阅专栏

1.select count(*) from RACV_DATA.PARTY_DUMMY;

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

2.select owner,object_name from dba_objects where object_name='PLAN_TABLE';

3.@?/rdbms/admin/utlxplan.sql

4.set autot on

5.select count(*) from RACV_DATA.PARTY_DUMMY;

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