Analyze

Hello,

I was wondering whether anyone can give me some guidance regarding Analyze. I have an 8.1.6 database, running on NT4 SP 6.

The analze script that I have been using is as follows.

BEGIN
dbms_utility.analyze_schema(
schema => 'SCHEMENAME',
method => 'DELETE');
dbms_stats.gather_schema_stats(
ownname => 'OWNERNAME',
method_opt => 'FOR ALL COLUMNS SIZE 30', DEGREE => 4,
cascade => TRUE);
end;
/

This has been fine up to now. I find that it helps enquiries run fine, but it has been slowing down other aspects of data input through the app. Was wondering if anyone could suggest a more comprehensive script, or whether it is better to analyze through dba studio using compute/estimate.

Many thanks for your help

Mark F Received on Fri Sep 07 2001 - 06:33:51 CDT