Diary Coding

Code your application with heart

Code your application with heart

Recent Posts

  • How To Install Tibero 6 Database Linux
  • How to Setup Network on RHEL/CentOs 7
  • How To Install EDB Database on Linux
  • Resize tablespace Oracle
  • How to check datafiles tablespace location

Recent Comments

    Archives

    • April 2022
    • March 2019
    • January 2019
    • August 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • November 2016

    Categories

    • Angular
    • Java
    • Linux
    • Network
    • Oracle
    • Security
    • Spring
    • SQL
    • Tibero
    • Tools
    • Tunning
    • TypeScript
    • Uncategorized

    Category Archives: Tunning

    Tunning Oracle Database with Build Index

    By admin in Oracle, SQL, Tunning March 28, 2018 0 Comment

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

    Build Index :

    BEGIN
      SYS.DBMS_STATS.GATHER_INDEX_STATS (
          OwnName        => 'DIARYCODING_DB'
         ,IndName        => 'DIARY_REASON_PK'
        ,Estimate_Percent  => 0
        ,Degree            => 4
        ,No_Invalidate     => FALSE);
    END;

    Continue reading




    . Theme: by Diary Coding.