Database DataWarehousing (MOSC)

MOSC Banner

Gather Schema Stats | schema have 1 Big partition table

edited Mar 12, 2013 8:35PM in Database DataWarehousing (MOSC) 5 commentsAnswered
Team,

We do have a Table which is partition which we use to gather table stats with these options (estimate_percent => 30,
    method_opt       => 'FOR ALL COLUMNS SIZE AUTO',     cascade          => TRUE,
    no_invalidate    => FALSE,     degree=>10,     GRANULARITY => 'GLOBAL AND PARTITION'  )

But we had a issue when we ran gather schema stats we didn't give these above options and the Performance was bad for the Process they were running.

So whats the best way to run the Schema stats if i have a schema with 1 partition table and others are normal table.

Will this help for Both partition table and Normal Tables? Please advise else what is the best option.

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