My Oracle Support Banner

Gathering Database Statistics for Oracle Transportation Management (Doc ID 467668.1)

Last updated on OCTOBER 09, 2022

Applies to:

Oracle Transportation Management - Version 6.2.10 and later
Information in this document applies to any platform.

Symptoms

Oracle Transportation Management database performance degrades gradually over time. 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
 How to determine if your statistics are being analyzed on a regular basis
 10g Recommendations
 11g Recommendations
 Scheduling the OTM gather_table_stats.sql script for 10g and 11g Databases
 Confirm GATHER_STATS_JOB is Disabled (Note: This is for 10g only)
 Confirm GATHER_STATS_JOB is Disabled (Note: This is for 11g only)
 12c and 19c Recommendations

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.