ORACLE

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-676c582875251535153334/] 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 …

What is Endian? Endian is the storage method of multi-byte data types in memory. In other words, it determines the byte order of the data. …

Even if the password (orapwSID) file in the primary database is copied to the standby database side and the you can connect to the primary …

We can use the information in the v$session_longops view to determine the working time and the remaining time of a transaction in an active session. …