Tunning Oracle Database with Build Table

For good performance in oracle need tunning your database. Can use Build Table for the example :

Build Table :

BEGIN
  SYS.DBMS_STATS.GATHER_TABLE_STATS (
      OwnName        => 'DIARYCODING_DB'
     ,TabName        => 'TRANSACTION'
    ,Estimate_Percent  => 0
    ,Degree            => 4
    ,Cascade           => FALSE
    ,No_Invalidate     => FALSE);
END;

Do build some table in database until finish.

 

www.diarycoding.com

Leave a Comment.