Database Tuning (MOSC)

MOSC Banner

Ask about statistics on partition table ?

edited Jun 19, 2012 5:51PM in Database Tuning (MOSC) 5 commentsAnswered
Hi all,

   With partition table, Can we use script on single table to gather statistics such as ?:

begin
  dbms_stats.gather_table_stats(
        ownname                 => 'XBANK',
        tabname                   => 'T_PRODUCT',
        estimate_percent     => dbms_stats.auto_sample_size,
        method_opt              => 'for all columns size auto',
        cascade                  => true
   );
end;

  My DB is 9.2.0.4

  Thanks.

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