ORACLE set head,Oracle 10.2.0.4 SYSTEM表空间中HIST_HEAD$ 过大如何处理？

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

Rem Base column statistics

create table hist_head$ /* histogram header table */

(obj# number not null, /* object number */

col# number not null, /* column number */

bucket_cnt number not null, /* number of buckets */

row_cnt number not null, /* number of rows in histgrm$ */

cache_cnt number, /* number of rows in row cache */

null_cnt number, /* number of nulls in this column */

timestamp# date, /* date of histogram's last update */

sample_size number, /* for estimated stats, size of sample */

minimum number, /* minimum value (if 1-bucket histogram) */

maximum number, /* minimum value (if 1-bucket histogram) */

distcnt number, /* # of distinct values */

lowval raw(32),

/* lowest value of column (second lowest if default) */

hival raw(32),

/* highest value of column (second highest if default) */

density number, /* density value */

intcol# number not null, /* internal column number */

spare1 number, /* sample number of distinct values */

spare2 number, /* flags */

/* 0x01 = user-specified stats */

/* 0x02 = global stats */

/* 0x04 = endpoint actual values in histogram */

avgcln number, /* average column length */

spare3 number, /* spare */

spare4 number /* spare */

)

storage (initial 350k next 100k maxextents unlimited pctincrease 0)

hist_head$ 是直方图histogram 基础信息表

SQL> select count(1) from HIST_HEAD$;

COUNT(1)

----------

33373

数据库中数据表和表上的字段越多 且收集了直方图时 该表上的记录越多， 你的情况可能是 应用习惯性使用大量临时表所致。 可以考虑在系统级别不设置收集historgram