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

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 …

Even if the password_verify_function limit of a profile is changed in Oracle databases, it does not change as requested and changes to “FROM ROOT”. The …

IntelliSense was introduced with SQL Server 2008. With this feature, we can now write TSQL Code in a more practical way. So where can we …

In some cases in Oracle databases, the optimizer may make the wrong decision and cause this query to run with the wrong query plan. If …