Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
We will install Oracle grid infrastructure 11g on linux in this article. We are starting the Grid Infrastructure installation. We do this only on one node. (with grid user) Step1:Before …
Read More »
How To Install Oracle RAC 11g
We will install Oracle RAC 11g in this article. First, We check cluster services before starting Oracle installation. We do this in both nodes. (with oracle user) [crayon-600367552955e725539770/] Oracle RAC …
Read More »
Oracle Date Functions
This article contains information about oracle date functions such as sysdate, last_day, add_months, extract. Date Functions in Oracle Oracle has several functions to operate on date and time data. ADD_MONTHS …
Read More »
What is pg_repack in PostgreSQL
Today, I will introduce you a nice extension that we can use instead of VACUUM FULL in PostgreSQL. I recommend using it in your prod environments. VACUUM FULL command rewrites …
Read More »
Oracle Numeric/Math Functions
This article contains information about oracle numeric/math functions and their usage. Numeric/Math Functions Oracle has several functions for processing numerical data. ABS Function in Oracle Returns the absolute value of …
Read More »
How To Configure Elasticsearch Heap Size to Change Max Memory Size
What is Elasticsearch Heap Size? It is a very important setting for ElasticSearch. In order for this setting to be set correctly, the system must be well monitored. In short, …
Read More »
How To Install Couchbase Server on Ubuntu 16.04
We will install couchbase Server on ubuntu 16.04 in this article. Please visit the link below for minimum system requirements. Link : https://docs.couchbase.com/server/current/install/plan-for-production.html WARNING: Make sure to install Java before installing …
Read More »
How to Install Apache Cassandra on CentOS 7
In this article, we will install apache cassandra on Centos 7 in a Standalone structure. Now let’s start installing our Cassandra NoSQL database on Centos 7 step by step. Step1: …
Read More »
What is Real Time Apply in Dataguard
What is real time apply in dataguard? If media recovery is started with the following command after installing Data Guard in versions prior to Oracle 12c, Media Recovery starts as …
Read More »
Oracle String Functions
This article contains information about oracle string functions such as length, substr, concat, trim in Oracle database management system. What is Oracle string function? Oracle has several functions for manipulating …
Read More »