sql script: 找出stale statistics的对象

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)

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