Database Tuning (MOSC)

MOSC Banner

Ask about METHOD_OPT in 9i

edited May 29, 2012 12:54PM in Database Tuning (MOSC) 6 commentsAnswered
Hi all,

   I have some confuse about METHOD_OPT. If my db just have some table configured monitoring. And I use script 1:

begin
  dbms_stats.gather_schema_stats(
      ownname          => 'USER_A',
      estimate_percent => dbms_stats.auto_sample_size,
      method_opt       => 'for all columns size auto',             
      cascade          => true
   );
end;

   If have a highly skewed data distribution, I can use option METHOD_OPT to create histogram for these columns (And seem as this option just effect to only tables that configured monitoring). Normally, if I had not yet determine which columns, I can use script 2:

begin
  dbms_stats.gather_schema_stats(
      ownname          => 'USER_A',

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