Berkenalan dengan AWS DynamoDB – Platform NoSQL Database dari Amazon Web Services

Q: What is Amazon DynamoDB? DynamoDB is a fast and flexible nonrelational database service for any scale. DynamoDB enables customers to offload the administrative burdens of operating and scaling distributed databases to AWS so that they don’t have to worry about hardware provisioning, setup and configuration, throughput capacity planning, replication, software patching, or cluster scaling. […]

Best Practice Guide untuk menjalankan JAVA di atas VMware vSphere

vSphere saat ini sudah sangat bisa diandalkan untuk dapat menjalankan berbagai macam Business Critical Applications, dari berbagai macam programming language seperti Java, .NET, dan lain-lain. Database system dengan load yang tinggi seperti Billing, Analytics, dan lain-lain juga dapat didukung dengan sangat baik di vSphere baik menggunakan Oracle Database, SQL Server, dan lain-lain. Selain dapat memberikan performance […]

Oracle Database Standard Edition 2 Compare to other Editions

If you read this blog, I also have specific part talking about Oracle Database. Several years ago actually I was also an Oracle Database Administrator for Oracle 9i, 10gR2, and 11gR2 doing operational such as architecture design, deployment, performance tuning, backup, replication, clustering, and PL/SQL programming. But, currently I found cloud technology is more interesting than on-premise […]

Why do we need to Virtualize our Oracle Database

Usually customer would like to expand the benefits that they already achieved using virtualization (financial, business and operational benefits of virtualization within its operating environment) to another level. For example to Business Critical Applications such as Oracle Database, thereby reaping the many benefits and advantages through its adoption of this infrastructure. Customer aims to achieve […]

What is Hadoop? Why do we need to virtualize it using VMware?

What is Hadoop? Hadoop is an Apache open source project that provides scalable and distributed computing, originally built by Yahoo!. It provides a framework that can process large amounts of data by leveraging the parallel and distributed processing of many compute nodes arrayed in a cluster. These clusters can be configured as a single host […]

Oracle Real Application Cluster Pros-Cons Analysis on vSphere

There are several considerations, whether we want  to implement Oracle Real Application Cluster or not in vSphere environment. These are some simple writings of the Pros and Cons analysis.   Pros Analysis – Oracle RAC on vSphere Cons Analysis – Oracle RAC on vSphere Availability perspective: It will create zero downtime of availability (but VMware […]

Pengetesan Performance untuk Oracle Database (Oracle DB Stress Test)

Pengetesan performance untuk Oracle Database sering diperlukan untuk melakukan benchmark antara system yang ada, atau jika kita ingin mengganti ke system yang baru. Kita tidak ingin performance dengan system yang baru akan lebih buruk dengan system yang lama kan. Berikut ini adalah beberapa cara yang biasa digunakan untuk melakukan pengetesan performance tersebut, selain dari mekanisme […]

Cloning Microsoft SQL Server from a Template

There are several things that we need to do to deploy Microsoft SQL Server database using standardized template. The items can be read fully from these blogs : http://notesfrommwhite.net/2014/07/20/how-to-build-a-windows-2012-r2-vmware-template/ http://vcdx56.com/2014/02/25/create-multiple-vms-from-existing-vsphere-vm-using-powercli/ http://longwhiteclouds.com/2015/01/03/sql-server-templates-with-vmware-dude-wheres-my-drive-letters/ http://longwhiteclouds.com/2015/01/27/nutanix-sql-server-db-vaai-clone-performance/ So, the options are : Run several PowerCLI scripts after the deployment (execute via SysPrep or vRealize Orchestrator) Use VMware Application Service and […]

Fight the FUD – Oracle Licensing and Support on VMware vSphere

In this post I will copy-paste one of the Best reading for Virtualizing Business Critical Applications from Michael Webster’s blog. This can explain that Oracle Database can be virtualized in VMware! Enjoy! These are the source : http://longwhiteclouds.com/2012/07/21/fight-the-fud-oracle-licensing-and-support-on-vmware-vsphere http://longwhiteclouds.com/2013/01/17/return-of-the-fud-oracle-licensing-on-vmware-vsphere/ http://www.vmware.com/files/pdf/techpaper/vmw-understanding-oracle-certification-supportlicensing-environments.pdf —-   I keep hearing stories from Customers and Prospects where Oracle appears to be […]

Oracle Database 11gR2 Performance Tuning di AIX 7.1

Ada beberapa mekanisme untuk melakukan tuning Oracle Database, diantaranya adalah : 1. Oracle with Default Tuning (only Pre-Req, SGA and PGA, or AMM) 2. (+) Tuning OS 3. (+) Tuning Oracle Parameter (spfile / init.ora) 4. (+) Tuning Oracle Datafiles configuration, etc 5. (+) Tuning SQL Query (includes: index, partitioning, profiling, hints, etc) 6. (+) […]

Instalasi PostgreSQL Database di RedHat (all) dan Instalasi EnterpriseDB Database di RedHat for Power

Pada posting kali ini, saya akan membahas lanjutan dari posting sebelumnya mengenai PGBENCH untuk stress test. Kali ini saya akan membahas 2 buah topik mengenai instalasi dan konfigurasi untuk : 1. PostgreSQL Database di REDHAT (x86, ppc) 2. EnterpriseDB Database di REDHAT (ppc) atau bisa juga menggunakan GUI yang bisa di download dari website enterprisedb. […]

Cara Melakukan Stress Test Database PostgreSQL atau EnterpriseDB menggunakan pgbench

Berikut ini adalah langkah demi langkah untuk melakukan Stress Test database PostgreSQL dan EnterpriseDB di LINUX RedHat. 1. Jalankan PostgreSQL atau EnterpriseDB 2. Download paket pgbench (http://www.westnet.com/~gsmith/content/postgresql/pgbench-tools.htm) 3. Unzip pgbench 4. Change Owner dari direktori hasil ekstrak ke enterprisedb:enterprisedb, jika tadi anda melakukan ekstraksi menggunakan user root 5. login menggunakan user enterprisedb atau postgres (tergantung) […]

Oracle RMAN Cheat Sheet

RMAN> CONNECT TARGET / RMAN> SHOW ALL; CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u01/app/rmanbackup/%F’; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE […]

Cara Singkat untuk Instalasi Oracle11gR2 on AIX 7.1

           Berikut ini adalah mekanisme untuk melakukan Instalasi Oracle11gR2 di AIX 7.1. Mekanisme untuk instalasi Oracle di AIX ini lebih simple daripada instalasi di RedHat atau SUSE (http://bicarait.com/2013/04/28/step-by-step-cara-instalasi-database-oracle-10g-atau-11g-di-linux-red-hat-atau-fedora/). Anyway, here you go : (saya belum sempat rapihkan tulisannya, jadi silahkan disimak dengan baik2) 1. Check real memory dan processor : /usr/sbin/lsattr […]

Understanding ORACLE AWR Repor

Understanding AWR Report Posted by Mich Talebzadeh in Oracle. trackback In the post Automatic Workload Repository  (AWR) Performance Monitoring Tool Basics , I described the basic set up and report generation for AWR. In this post we will try to understand the AWR report itself. Before going further I must emphasise that this report was generated by running a PL/SQL […]