Code Snippet

Just another Code Snippet site

[Oracle] table stats

BEGIN
  SYS.DBMS_STATS.GATHER_TABLE_STATS (
      OwnName        => '<schema_name>'
     ,TabName        => '<table_name>'
    ,Degree            => 4
    ,Cascade           => FALSE
    ,No_Invalidate     => FALSE);
END;
/

,


One thought on “[Oracle] table stats

  • For complete schema:

    BEGIN
      SYS.DBMS_STATS.GATHER_SCHEMA_STATS  (
          OwnName        => '<SCHEMA_NAME>'
        ,Degree            => 4
        ,Cascade           => FALSE
        ,No_Invalidate     => FALSE);
    END;
    

Leave a Reply to OLIVIER COMBE Cancel reply

Your email address will not be published. Required fields are marked *