Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

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 …

This article contains information about what is elasticsearch heap size, garbage collector and elasticsearch heap size recommended. What is Elasticsearch Heap Size? It is a …

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 …

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 …

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 …

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 …

In Oracle databases, when the downgrade operation or “migrate schema” operation is done through adrci, when using the adrci, ORA-48318 error is received when the …

We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG from V$DATAGUARD_STATS View. [crayon-6741596d61e8b526826703/] [crayon-6741596d61e8f814790701/] …

You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-6741596d62463955828374/] or [crayon-6741596d62467842494709/] Standby -> …

Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-6741596d6271c650238440/] Data Guard Recovery Modes …