Oracle – Sihendri

SGA and PGA in Oracle Database Configuration

Posted on March 20, 2023 by sihendri

In Oracle database configuration, SGA (System Global Area) and PGA (Process Global Area) are two important memory areas that affect the performance of the database. SGA is a shared memory region that stores data and control information for the Oracle instance. It includes the database buffer cache, shared pool, redo log buffer, and other memory…

How To Substring Until First Space in Oracle String

Posted on March 8, 2023 by sihendri

To substring until the first space in an Oracle VARCHAR2 column, you can use the SUBSTR and INSTR functions together. The SUBSTR function extracts a substring from a string, and the INSTR function finds the position of a substring within a string. Here’s an example: SELECT SUBSTR(your_column, 1, INSTR(your_column, ‘ ‘) – 1) AS result…

Oracle WebLogic Server and Docker: Building Scalable Java Applications

Posted on February 22, 2023February 22, 2023 by sihendri

To get started with building scalable Java applications with Oracle WebLogic Server and Docker, you can follow these steps: Install Docker on your development machine and make sure it is running correctly. Download the official Oracle WebLogic Server Docker image from Docker Hub. Create a Dockerfile that extends the WebLogic Server Docker image and includes…

Building Scalable Applications with Oracle and Docker

Posted on February 22, 2023February 22, 2023 by sihendri

Building scalable applications with Oracle and Docker involves leveraging the power of containerization to create microservices-based architectures that can be easily deployed and scaled to meet changing demand. Here are some steps involved in this process:

Cara menghubungkan host dengan oracle yang ada di docker

Posted on February 20, 2023February 28, 2023 by sihendri

Untuk menghubungkan host dengan Oracle yang berjalan di Docker, Anda dapat mengikuti langkah-langkah berikut: Pastikan Docker dan Oracle telah terpasang di host Anda. Jalankan container Oracle menggunakan perintah Docker run, dengan menetapkan port untuk koneksi. Contoh perintah untuk menjalankan container Oracle 12c: docker run -d -it –name oracle12c -p 1521:1521 -p 5500:5500 -e ORACLE_SID=ORCL -e…

Catatan Oracle di Docker dan cara import dump file

Posted on October 25, 2021October 25, 2021 by sihendri

Apa itu docker? Docker adalah, ah males ngetiknya, baca aja disini. Kebutuhan saat ini adalah menjalankan oracle database di docker dan import schema yang udah di dump ke docker. Pertama yang pasti bikin dulu akun di docker, setelah itu download dulu docker for dekstop app: Sesuaiin aja ama OS nya. Setelah selesai download, ya pasti…