Diary Coding

Code your application with heart

Code your application with heart

Recent Posts

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

Recent Comments

    Archives

    • 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
    • Tools
    • Tunning
    • TypeScript
    • Uncategorized

    Month: March 2018

    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

    Location Log Linux OS

    By admin in Linux, Oracle March 14, 2018 0 Comment

    Location logging file OS (Operating System) on linux generate to directory :

    # cd /var/log/ 

    Continue reading

    Create Stored Procedure MySql

    By admin in SQL March 13, 2018 0 Comment

    How to add stored procedure on your database, first you must prepare query will included to procedure. For the example :

    Create Procedure :

    DELIMITER //
    CREATE PROCEDURE diarycoding_proc
    (IN param CHAR(20))
    BEGIN
      SELECT Name, category FROM Post
      WHERE category = param;
    END //
    DELIMITER ;

    Continue reading




    . Theme: by Diary Coding.