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

This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-6741548fd7b70598754897/] or [crayon-6741548fd7b76645694890/]

This article contains information about revoke command usage in PostgreSQL. You may want to revoke permissions of users. In this case, you can use the …

Conversion operations in datetime data types often cause poor performance but they are always the ones that are overlooked. We will examine the Cast and …

What is Barman? Barman is an open source backup / restore management tool in PostgreSQL. What can you do with Barman? You can create backups …

In this article, we will upgrade PostgreSQL 11 to 12. If you want to upgrade PostgreSQL 10 to 11 you should read the article “Upgrade …

You can read this document to access the tables in the MSSQL database using the DBLINK architecture from the Oracle database. Please test in the …

When you create backups with rman in Oracle 12.2 databases, an “RMAN-10038: database session for channel d1 terminated unexpectedly” error occurs. You see the error …

You can run rman in debug mode to get more detailed information about Rman operations. In this way, we get more detailed information about a …

With the new feature that introduced with Oracle 18c, it is now possible to stop the running query in a session without terminating session. You …

In Oracle 12c and later versions, auditing is possible with Unified audit as well as standard auditing. This feature allows role-based auditing. It is possible …