1 使用dbms_stats.create_stat_table 创建统计信息表
SQL> begin
2 dbms_stats.create_stat_table('DAO','DAO_STATS_TABLE','USERS');
3 end ;
4 /
PL/SQL procedure successfully completed
2 查看表结构
SQL> set linesize 200
SQL> desc dao.DAO_STATS_TABLE ;
Name Null? Type
--------------------------------- -------- ----------------
STATID VARCHAR2(30)
TYPE CHAR(1)
VERSION NUMBER
FLAGS NUMBER
C1 VARCHAR2(30)
C2 VARCHAR2(30)
C3 VARCHAR2(30)
C4 VARCHAR2(30)
C5 VARCHAR2(30)
N1 NUMBER
N2 NUMBER
N3 NUMBER
N4 NUMBER
N5 NUMBER
N6 NUMBER
N7 NUMBER
N8 NUMBER
N9 NUMBER
N10 NUMBER
N11 NUMBER
N12 NUMBER
D1 DATE
R1 RAW(32)
R2 RAW(32)
CH1 VARCHAR2(1000)
CL1 CLOB
3 查看统计信息副本表数据
SQL> select *
2 from dao.DAO_STATS_TABLE ;
no rows selected
4 将统计信息导入到统计信息副本表
SQL> begin
2 dbms_stats.export_table_stats(ownname => 'DAO',
3 tabname => 'TEST_STATS',
4 stattab => 'DAO_STATS_TABLE');
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> select count(*)
2 from dao.DAO_STATS_TABLE ;
COUNT(*)
----------
17
至此统计信息已经被导出到统计信息副本表