oracle中收集统计信息,分别收集和发布统计信息

然后，检查 CUSTOMERS_OBE 表的正在审核的统计信息。在终端窗口中，执行以下脚本：

@show_pending_stats CUSTOMERS_OBE

show_pending_stats.sql 代码如下所示：

-- tables

select table_name, last_analyzed "analyze time", num_rows, blocks, avg_row_len

from user_tab_pending_stats

where table_name = '&1' and partition_name is null;

-- indexes

select index_name, last_analyzed "analyze time", num_rows,

leaf_blocks, distinct_keys

from user_ind_pending_stats

where table_name = '&1' and partition_name is null

order by index_name;

-- columns

select column_name, last_analyzed "analyze time", num_distinct,

num_nulls, density

from user_col_pending_stats

where table_name = '&1' and partition_name is null

order by column_name;

注意，现在不存在正在审核的统计信息，因为它们已经发布。