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

    Month: March 2018

    Error PS_TXN in Oracle Database

    By admin in Oracle, SQL March 29, 2018 0 Comment

    In Oracle database if you find message => JBO-28030: Could not insert row into table PS_TXN, please fix error with :

    Last Sequence :

    CREATE SEQUENCE PS_TXN_SEQ MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE;
    

    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.