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

In Oracle 12.2 databases, this error is written in the alertSID.log file when the default maintenance job is timeout and the corresponding job is automatically …

ACID is the four main rules that relational database management systems (RDBMS) must provide. For more detailed information about relational databases and SQL Server, you …

What groups selected during Oracle binary installation may not be remembered after installation. Or it may be necessary to determine which groups are selected for …

We can easily perform point-in-time recovery with Database Recovery Advisor. For example, we have a Full backup that has taken at 14:00 PM and we …

The data dictionary views that contain information about the backups and recovery of Oracle databases are as follows. We can get detailed or summary information …

User Defined Function is a feature of SQL Server that takes parameters like a programming language functions and returns a result or result set. With …

The DBA_HIST_ACTIVE_SESS_HISTORY data dictionary view can be used to find queries executed in the Oracle database. Historical information is available. You can use the V$ACTIVE_SESSION_HISTORY …

Before you read this article, I recommend that you read the article “What is Data-Tier Application” to avoid confusion. In the article I mentioned above, …

You can access the process information of a session in the Oracle database with the following query. Sometimes it is not possible to terminate a …

Data-Tier Application Version 1.1 (DAC) was introduced with SQL Server 2008 R2. With Data-Tier Application, we are able to transfer the databases of our applications …