General Ledger - EBS (MOSC)

MOSC Banner

Table stats gathered without data changes

Version: 19.23 EE

I imported stats into a database from a well tested database for all the tables under a owner where there was no data load yet (0 rows for all the tables).

However, I checked today and 3 tables still with 0 rows but got reanalyzed with 0 rows.

Without data change (default stale percent: 10%), wonder why only a few tables stats got gathered, but the rest are still with imported stats.

Details: We have not set table_prefs for any tables. No high frequency stats turned on. overnight auto stats gathering.

Looking for ideals as to why only a few tables stats regathered without data changes.

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