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

    Resize tablespace Oracle

    By admin in Oracle, SQL, Tunning January 8, 2019 0 Comment

    When tablespace full in schema, you need to resize tablespace. This query will resize tablespace (resize to 20 Gb) :

    Query Alter

    alter database datafile ‘+DATA/DIARYCODING/DATAFILE
    /diarycoding.305.978198771’ resize 20G ;
    

    Continue reading

    Tunning Oracle Database with Gather Schema

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

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

    Gather Schema :

    BEGIN
      SYS.DBMS_STATS.GATHER_SCHEMA_STATS (
         OwnName           => 'DIARYCODING_DB'
        ,Granularity       => 'DEFAULT'
        ,Options           => 'GATHER'
        ,Gather_Temp       => FALSE
        ,Estimate_Percent  => 0
        ,Degree            => 4
        ,Cascade           => FALSE
        ,No_Invalidate     => FALSE);
    END;

    Continue reading

    Tunning Oracle Database with Build Table

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

    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;

    Continue reading




    . Theme: by Diary Coding.