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

You can find the undo usage of a session with the following query. Historical information is also available. You can find the undo usage of …

This is very interesting case. One day we saw that a database is not accessible in a failover cluster due to an offline disk. And …

Its is a feature announced with SQL Server 2014. It can be very useful if you have a partition in your database. If you don’t …

You may need to enable trace for a session for many reasons. For example, you may need to determine which queries run in a session. …

COLUMNSTORE_ARCHIVE option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress our columnstore tables or indexes …

The PDB$SEED or SEED database is a pluggable database template for pluggable databases to be created by users. Used as a template to create new …

WAIT_AT_LOW_PRIORITY is a feature introduced with SQL Server 2014. We can control the Online Index Rebuild and switch partition operations. For example, suppose we perform …

Steps to Apply Patch on DB Home This document shows how to apply patch on Oracle home / databases. July 2019 PSU for Oracle databases. …

You can query the CDB column in the V$DATABASE view to see if a database is CDB. If the current database is CDB, the column …

Delayed Durability is a feature that introduced with SQL Server 2014. It is a feature that flexs Durability, a common feature of advanced relational databases. …