Linux

One of the information I needed most is the file version. You can learn this in unix systems with the following command. [crayon-662c605e7cdd6645005522/]

First we go to https://yum.postgresql.org and into PostgreSQL where we will download the repo. Since we will install PostgreSQL 10 in our example, we will …

  In this article, I will share the necessary steps to connect to Oracle through the linux operating system and the solutions to the problems …

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

  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 …

  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) …

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

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

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

  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 …