OceanBase Oracle 租户下 user_tables/all_tables 的 num_rows 与实际数据量不一致

SELECT owner,
       table_name,
       num_rows,
       last_analyzed,
       stale_stats
FROM dba_tab_statistics
WHERE owner = 'YOUR_SCHEMA'
  AND table_name = 'YOUR_TABLE';

SELECT * FROM SYS.DBA_OB_TABLE_STAT_STALE_INFO
WHERE TABLE_NAME = 'YOUR_TABLE';

-- 查询全局默认值
SELECT dbms_stats.get_prefs('STALE_PERCENT', 'SYS') FROM dual;

-- 查询特定表的配置
SELECT dbms_stats.get_prefs('STALE_PERCENT', 'YOUR_SCHEMA', 'YOUR_TABLE') FROM dual;

CALL dbms_stats.gather_table_stats(
    ownname          => 'YOUR_SCHEMA',
    tabname          => 'YOUR_TABLE',
    granularity      => 'GLOBAL',
    method_opt       => 'FOR ALL COLUMNS SIZE AUTO'
);

SET SESSION ob_query_timeout = 3600000000;

-- 设置单表阈值为 5%
CALL dbms_stats.set_table_prefs('YOUR_SCHEMA', 'YOUR_TABLE', 'STALE_PERCENT', '5');

-- 验证
SELECT dbms_stats.get_prefs('STALE_PERCENT', 'YOUR_SCHEMA', 'YOUR_TABLE') FROM dual;

-- 修改全局默认值
CALL dbms_stats.set_global_prefs('STALE_PERCENT', '5');

-- 验证
SELECT dbms_stats.get_prefs('STALE_PERCENT', 'SYS') FROM dual;

-- 示例：收集指定 Schema 下所有表的统计信息
BEGIN
    FOR rec IN (
        SELECT table_name FROM user_tables
        WHERE num_rows > 8000000 OR num_rows IS NULL
    ) LOOP
        dbms_stats.gather_table_stats(
            ownname     => USER,
            tabname     => rec.table_name,
            granularity => 'GLOBAL',
            method_opt  => 'FOR ALL COLUMNS SIZE AUTO'
        );
    END LOOP;
END;
/

SELECT owner,
       table_name,
       num_rows,
       last_analyzed,
       stale_stats
FROM dba_tab_statistics
WHERE num_rows IS NULL
   OR last_analyzed < SYSDATE - 7
ORDER BY last_analyzed;