oracle开发 – ANBOB

sql script: 找出stale statistics的对象

2022-11-292012-04-09 by weejar zhang

Using the code below one can find the tables/indexes that have stale statistics in a schema, when options=>’GATHER AUTO’ is used oracle gathers statistics analyzes the tables/indexes that have stale statistics.

oracle 找出没有记录的空表(zero rows tables)

2011-08-29 by weejar zhang

oracle 11g以前，建立空表也会分配段占用磁盘空间，如果查出库中所有没有记录的空表呢？呵今天无意间发现一怪语法