PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Statistics on temporary table

edited May 15, 2013 4:15AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered
After installing PSCBO_STATS, it seem that PSCBO_STATS.GATHER_TABLE_STATS(P_TABLE_NAME=>'PS_TL_PMTCH2_TMP5', P_LEVEL=>'LOW') does not gather stats on my temporary table.  In the time admin process, temporary table are fill with 200,00 row ans still no stats are done on those tables.

I see in the log that recstats is running, but at the end there is no stat and the performance is not there (full table scan)...  when I use the older :

DBMS_STATS.GATHER_TABLE_STATS (ownname=> [DBNAME], tabname=>[TBNAME], estimate_percent=>1, method_opt=> 'FOR ALL INDEXED COLUMNS SIZE 1',cascade=>TRUE);

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