Database Tuning (MOSC)

MOSC Banner

gather partition table in schema !

edited Jul 19, 2012 10:00PM in Database Tuning (MOSC) 16 commentsAnswered
Hi all,

   When there are not partition tables, I usually use bellow script to gather statistics of schema:

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

   But now, I have some partition tables and can I  use above script with granularity => 'DEFAULT' to gather statistics for schema XBANK ? It look like:

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

   And last question: I was partitioning table A when a session sess_1 accessed and updated data of table A ==> Which errors that I can meet ?

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