title: Oracle manually update statistics on all tables
body: <p>Is there a way to update all statistics for all tables regardless of the owner?</p>
  
  <p>I found this sniplet, but I'm not sure if this will grab all tables....</p>
  
  <pre><code>BEGIN
     FOR A IN ( SELECT owner FROM SYS.all_tables ) LOOP
        execute immediate
          EXEC dbms_stats.gather_schema_stats( 'A.owner', cascade='TRUE');
     END LOOP;
  END;
  </code></pre>