ORACLE

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 …

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 …

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 …

ADRCI (ADR Command Interpreter) can be used to display errors in services such as Oracle database, grid, asm, listener. In all ADRCI-defined homes, you can …

To move all objects in a schema to a different schema, the following steps must be followed. The following queries prepare the queries required for …

In Oracle 12c databases, datafile can be moved online. In earlier versions this was not possible. With 12c, a datafile can now be moved from …

When Data pump is running slowly or when it is hanging, determining which query is currently running will help in understanding the problem. The following …

You can access summary information about the status of Data Pump Master and worker processes with the following query. [crayon-67d4244d42ba3106021039/] You can also find out …

We can receive this error in the case of many sorting or join operations in 12c databases. The reason for the error is the memory …

On Linux systems running Oracle database, the following error messages are displayed due to bug 17186167. The problem is fixed in version 18.1. The problem …