oracle按用户采集信息,oracle 11g 手动收集用户统计信息

oracle 11g 手动收集用户统计信息

2020-07-25

编程之家收集整理的这篇文章主要介绍了oracle 11g 手动收集用户统计信息，编程之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

日常手动收集统计信息，常用参数如下。用户名为ROIDBA

@H_502_2@exec dbms_stats.gather_schema_stats('ROIDBA',estimate_percent=>20,no_invalidate=>DBMS_STATS.AUTO_INVALIDATE,method_opt=>'for all columns size auto',force=>TRUE,cascade=>TRUE,degree=>4);

@H_502_2@GATHER_SCHEMA_STATS Procedures

This procedure gathers statistics for all objects in a schema.

Syntax

DBMS_STATS.GATHER_SCHEMA_STATS (

ownname VARCHAR2,estimate_percent NUMBER DEFAULT to_estimate_percent_type

(get_param('ESTIMATE_PERCENT')),block_sample BOOLEAN DEFAULT FALSE,method_opt VARCHAR2 DEFAULT get_param('METHOD_OPT'),degree NUMBER DEFAULT to_degree_type(get_param('DEGREE')),granularity VARCHAR2 DEFAULT GET_PARAM('GRANULARITY'),cascade BOOLEAN DEFAULT to_cascade_type(get_param('CASCADE')),stattab VARCHAR2 DEFAULT NULL,statid VARCHAR2 DEFAULT NULL,options VARCHAR2 DEFAULT 'GATHER',objlist OUT ObjectTab,statown VARCHAR2 DEFAULT NULL,no_invalidate BOOLEAN DEFAULT to_no_invalidate_type (

get_param('NO_INVALIDATE')),force BOOLEAN DEFAULT FALSE,obj_filter_list ObjectTab DEFAULT NULL);

DBMS_STATS.GATHER_SCHEMA_STATS (

ownname VARCHAR2,no_invalidate BOOLEAN DEFAULT to_no_invalidate_type (

get_param('NO_INVALIDATE'),force BOOLEAN DEFAULT FALSE,obj_filter_list ObjectTab DEFAULT NULL);

Parameters

Table 142-43 GATHER_SCHEMA_STATS Procedure Parame