Parellel Concurrent Processor

Doc ID:185489.1

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

Gather Schema Statistics Manual Script:

Please find the below reference Metalink Note ID: 190177.1 , part of Information is mentioned below :

OVERVIEW:
coe_stats.sql verifies the statistics in the data dictionary for all tables
owned by installed Oracle Apps modules. It generates a dynamic script
coe_fix_stats.sql and a report coe_stats.log.
The generated report coe_stats.log contains the list of tables that need
to be analyzed, including the actual (former) number of rows and the
suggested sample size for the next statistics gathering.
The dynamic script generated coe_fix_stats.sql includes the commands to
execute the FND_STATS packege to gather the statistics based on the number
of days since last analyzed and the size of the table.

INSTRUCTIONS:
Run coe_stats.sql with no parameters and review coe_stats.log file. If
output is approved, remove comment line on '-- @coe_fix_stats' at the end
of this script and run it again, or run coe_fix_stats.sql manually.
This coe_stats.sql script should be run once per week.

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

Recompile Invalids:

exec utl_recomp.recomp_parallel(3); recompile invalid objects;
exec dbms_utility.compile_schema('any schema');
Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

You MUST shutdown the concurrent manager BEFORE you run cmclean.sql....WHY?

sqlplus apps/apps @cmclean

You MUST shutdown the concurrent manager BEFORE you run cmclean.sql
If you dont, what will happen is that currently running jobs will be marked as COMPLETED even though they are still running, and any dependent job will startup, possibly corrupting your data. Additionally, the internal manager might get confused as to how many jobs are running and might misallocate jobs to managers, basically a mess for job scheduling.
Once you shutdown the concurrent managers, cmclean.sql will mark all jobs that were in the running state as completed.
It is safe to do, since no jobs are running and they should be marked as completed.

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”