====== Oracle STATS (schema,table) ======

**Stats for a complete schema e.g. SYSADM**\\
<code>
BEGIN
   DBMS_STATS.GATHER_SCHEMA_STATS( OWNNAME => 'SYSADM', ESTIMATE_PERCENT => NULL, BLOCK_SAMPLE => FALSE, DEGREE => 32, GRANULARITY => 'ALL', CASCADE => TRUE );
END;
/
</code>
**Stats for a table e.g. PS_R_PER507**\\
<code>
BEGIN
   DBMS_STATS.GATHER_TABLE_STATS( OWNNAME => 'SYSADM', TABNAME => 'PS_R_PER507', ESTIMATE_PERCENT => NULL, BLOCK_SAMPLE => FALSE, DEGREE => 32, GRANULARITY => 'ALL', CASCADE => TRUE );
END;
/
</code>
**Stats for Dictionary Objects - helps with Cost Based Optimizer**\\
<code>
BEGIN
   DBMS_STATS.GATHER_SCHEMA_STATS('SYS');
   DBMS_STATS.GATHER_DATABASE_STATS(gather_sys => TRUE);
   DBMS_STATS.GATHER_DICTIONARY_STATS;
   DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;   
END;
/
</code>