SQL Performance (MOSC)

MOSC Banner

statistics table hang

edited Sep 29, 2017 5:03AM in SQL Performance (MOSC) 1 commentAnswered

using  the below procedure,  for some days the procedure will run for max 10Min, while other days can stay all day running?

how to check what is blocking , or to investigate further the behavior?

  SYS.DBMS_STATS.GATHER_TABLE_STATS(OwnName      => 'Owner1',
                                TabName      => 'table1',
                                PartName     => 'PART_' || DAYID,
                                Granularity  => 'PARTITION',
                                Estimate_Percent => 35,
                                Method_Opt   => 'FOR ALL COLUMNS SIZE AUTO',
                                Degree       => 8,
                                Cascade      => FALSE,
                                No_Invalidate=> FALSE,
                                force =>true);

thanks,

Olta

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