Linux

  You are processing in psql, but you need to look at something on the operating system side, so you must exit from the psql and connect to Psql again. …

  To trap Ctrl-C in a shell script, we will need to use the trap shell builtin command. When a user sends a Ctrl-C interrupt signal, the signal SIGINT (Signal …

  The error ORA-04031 occurs on the shared pool which can indicate one of two things: 1) Insufficient space for the shared pool OR 2) Although there is enough memory, …

  Most of the cases we need to monitor the space of the FileSystem while data is growing in the database. And if there are any delete operations performed on …

  Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB size. Total DB size is …

  Below is a simple script which backup Mysql users & grants into separate sql file. So,if you are taking particular database backup then this script might be useful for …

  Below is the simple script for monitoring & auditing mysql general logs.This can be set as per the need(eg. daily,horly).It will help in capturing both DDL & DML Operations …

  Below is the simple script for monitoring mysql error logs. You can set the cron jobs as per your need(eg. daily,hourly) [crayon-6003a2ca99d19601321689/] Hope this helps !

HADOOP MULTI NODE INSTALLATION PROCESS [ Note: I am creating multi node in most easiest way by creating and using everything in root mode on default users like (master, slave1, …

  You can login to a remote Linux server without entering password in 3 simple steps using ssky-keygen and ssh-copy-id as explained in this article. ssh-keygen creates the public and private …