Hadoop has many distributions and every distribution has a stack or you can say a collection of technologies/framework that work in conjunction with Hadoop and is knows as HADOOP ECOSYSTEM. Below is the hadoop ecosystem. Please note there are a plethora of technologies and distributions… Read More

MySQL : Installing Multiple MySQL

Installing Multiple MySQL   The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines.   MySQL provides a tool to facilitate the execution of… Read More

Oracle: Different options in Export and Imports

Different options in Export and Imports   Schema export and import using remap_schemas.   1) create directory dpump as ‘/u02/dpump’; 2) grant read,write on directory dpump to system; expdp user/password directory=dpump dumpfile=export.dup logfile=export.log schemas=scott For importing schema :   1) Cretae directory dpump as ‘/u02/DATAPUMP’;… Read More

MySQL : About MySQL

MySQL     MySQL belongs to relational database management system (RDBMS Software). MySQL is one of the most widely using open source relational database. MySQL was started developing by Michael Widenius “Monty” in the year 1979. At that time it named as UNIREG.  It’s an in-house database… Read More

Automate CPU utilization metrics (from SAR)

Table has to be created for capturing the CPU Utilization and save it to Database. CREATE TABLE “SCOTT”.”UTILIZATIONS” (“DATE_ID” DATE DEFAULT SYSDATE, “TIME_ID” VARCHAR2(15 BYTE), “CPU” VARCHAR2(5 BYTE), “USER_PCT” NUMBER(4,2), “NICE_PCT” NUMBER(4,2), “SYSTEM_PCT” NUMBER(4,2), “IOWAIT_PCT” NUMBER(4,2), “STEAL_PCT” NUMBER(4,2), “IDLE_PCT” NUMBER(4,2), “INST_NAME” VARCHAR2(10 BYTE) ) SEGMENT… Read More

More Latest News »