Upgrade Error In Collect Statistics Script (Doc ID 981166.1)

Last updated on MAY 31, 2013

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 to 6.3.1 [Release 6.3]
Information in this document applies to any platform.
***Checked for relevance on 31-May-2013***

Symptoms

You need to upgrade Provisioning on production from version B162 to version B188.
In the release notes you have the next step:

"When you have completed the above steps, execute the following script against the OSM schema:
\Database\provisioning\maintenance\stats\collect_stats.txt"

In that collect_stats.txt we have 2 scripts. You need to know which one we must run, we have on production oracle 10 g.

/*

begin
dbms_stats.gather_schema_stats
( '<%provisioning owner schema%>', 1, block_sample=>true, granularity=>'ALL', cascade=>true);
end;
/

*/

begin
dbms_utility.ANALYZE_SCHEMA(USER, 'ESTIMATE', ESTIMATE_PERCENT=>1);
end;
/


But in Oracle Oracle Database PL/SQL Packages and Types Reference 10g Release 2 (10.2) you have following note for ANALYZE_SCHEMA procedure.

Note:

This subprogram is obsolete with Oracle Database Release 10g. It is retained in documentation for reasons of backward compatibility. For current functionality, see Chapter 103, "DBMS_STATS".
This procedure runs the ANALYZE command on all the tables, clusters, and indexes in a schema. Use this procedure to collect nonoptimizer statistics. For optimizer statistics, use the DBMS_STATS.GATHER_SCHEMA_STATS procedure.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms