Hyperion Financial Close Management (FCM) (MOSC)

MOSC Banner

Best practices for gathering stats on ERPi schema for improvement in ARM data loads

We've observed variation in table stats due to dynamic nature of some volatile tables used in ARM loads e.g. TDATASEG_T. Our auto gather stat window typically start at 10 PM each night & if we run our ARM loads at same time, we observed that optimizer collects stats for TDATASEG_T table when there are few hundrard thousand rows in it, however after completion of ARM load, this table gets truncated & will have zero records.

On next run of ARM load, optimizer considers those few hundred thousand records as per table stats & creates SQL execution plan according to it; which proved to be worse plan & our loads were getting delayed.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center