Tag Archives: dba_tab_statistics

Oracle10g的DBA_TAB_STATISTICS视图的STATTYPE_LOCKED列没有正确的显示结果。 10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列对分区锁定显示为空：https://yangtingkun.net/?p=1023 上文提到了DBA_TAB_STATISTICS中的STATTYPE_LOCKED列在10g中对于分区锁定统计信息显示为空，那么在10g中有没有办法获取到正确的结果呢： SQL> SELECT TABLE_NAME, partition_name, last_analyzed, stattype_locked 2 FROM dba_tab_statistics 3 WHERE owner = USER 4 AND TABLE_NAME = ‘T_PART’; TABLE_NAME PARTITION_NAME LAST_ANAL STATT —————————— —————————— ——— —– T_PART 16-JUL-12 T_PART P1 T_PART P2 16-JUL-12 T_PART PMAX 16-JUL-12 … Continue reading →