Browsing Tag: database

    Database

    ORA-ERRORS

    August 31, 2012

    ORA-ERRORS – Numpang naro catetan kode error oracle, biar gak jauh2 carinya klo lg butuh & mumpung msh login.. 😀

    ora errors

    source : ordba

    ORA-0000: normal, successful completion
    ORA-00001: unique constraint (.) violated
    ORA-00017: session requested to set trace event
    ORA-00018: maximum number of sessions exceeded
    ORA-00019: maximum number of session licenses exceeded
    ORA-00020: maximum number of processes () exceeded
    ORA-00021: session attached to some other process; cannot switch session
    ORA-00022: invalid session ID; access denied
    ORA-00023: session references process private memory; cannot detach session
    ORA-00024: logins from more than one process not allowed in single-process mode
    ORA-00025: failed to allocate
    ORA-00026: missing or invalid session ID
    ORA-00027: cannot kill current session
    ORA-00028: your session has been killed
    ORA-00029: session is not a user session
    ORA-00030: User session ID does not exist.
    ORA-00031: session marked for kill
    ORA-00032: invalid session migration password
    ORA-00033: current session has empty migration password
    ORA-00034: cannot in current PL/SQL session

    Continue Reading…

    Database, Software, Tutorial - Tips & Trik

    How To Optimizing MySQL Server

    May 6, 2009

    Source : dhika.cikul.or.id

    How To Optimizing MySQL Server

    For the web server that using mysql as a database engine. Sometimes the process in mysql need a large resource, especially if

    server has a high traffic. According to my experience, to the high traffic server, the MySQL process itself can spend more than 30% of server resources. So, I will give you tips for optimizing mysql on the server that has high traffic.
    Continue Reading…

    Database, Software, Tutorial - Tips & Trik

    Optimasi SQL

    April 1, 2009

    Source : pcmedia.

    optimasi sql

    Optimasi SQL – Database administrator dan programer sering menggunakan SQL (Structured Query Language) untuk memberikan instruksi kepada database. Tetapi hati-hati, berikan instruksi yang tepat agar database Anda tidak ngambek. Joko Nurjadi

    JIKA DIIBARATKAN manusia, database adalah sahabat yang patuh dan mengerti pada setiap perintah yang diberikan, sayangnya terkadang tidak berlaku sebaliknya, kita tidak patuh dan tidak mengerti pada “perintah” yang diberikan database.