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

What is Diagsnap in Oracle 12c Diagsnap is a new feature introduced in 12.1.0.2 GI, which manages the diagsnap resource, which collects additional operating system …

You can list applied patches in Oracle by query except for “opatch”. You can use DBA_REGISTRY_HISTORY for databases 11g and earlier, and DBA_REGISTRY_SQLPATCH for databases …

You may want to read the following articles about replication before reading this article. “How To Install PostgreSQL Replication By using archive_command On Centos“, “How …

First of all, we must install PostgreSQL on Primary Server and perform initdb operations. You can find out how to do this in the article …

What is pgBackRest pgBackRest is a backup/restore tool in postgresql. PostgreSQL Backup Types In Postgresql, we create backups in two ways: logical and physical. Logical …

If you have created and enabled a new service and then created a pluggable database, you may receive this error if you want to switch …

We can reset the ILOM SP of compute nodes and cell nodes as follows: You can connect to the Ilom IP via ssh and run …

Connect to Root Container The connection to the root container is the same as connecting to the database instance in previous versions. Connection can be …

Suppose that we created a table in the database by following the normalization rules for our application. However, we realized that the data type of …

Disk scrubbing exists on Exadata cell nodes to automatically repair the failed sector of the disk when the system is idle without compromising system performance. …