Demantra Solutions - EBS (MOSC)

MOSC Banner

Help required in table reorg

edited Sep 1, 2017 5:00AM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered

Hi All,

I could see some recommendation in LOG_TABLE_REORG as reorg program were run with "Q" (Quick Check) parameter.

Those recommendation includes some temp table also.

High recommendation: Gather statistics with estimate_percent = dbms_stats.auto_sample_size on XXXXXXX

--this recommendation has been given to below tables,

ENG_<host>_IN, ENG_<host>_OUT, DEM_APPSERV_IN, DEM_APPSERV_OUT

T_SRC_ITEM_TMPL_TMP, T_SRC_LOC_TMPL_TMP, T_SRC_SALES_TMPL_TMP

T_DATE_15749_751_638868369

Is it necessary to run Gather stats on those temp and staging tables?

Below recommendations given to promotion_data table.

Recommendation: Based on NULL column distribution of table PROMOTION_DATA, run thorough check

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

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center