ORACLE

You can access summary information about the status of Data Pump Master and worker processes with the following query. [crayon-6742a61ea8a23517997169/] 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. …

Since Oracle 11g version, Data Pump allows to compress the backup before writing to dump file with “compression” parameter. The Compression parameter takes 4 values. …

In the Oracle 12c version, during database creation with dbca, this error is received because the shmall kernel parameter is not set correctly. The problem …

ASM Failure group is defined as protection against the problems in disk in ASM disk groups. Oracle provides disk redundancy with failure groups. If the …

In Oracle RAC databases, for cluster operations, errors can be received because the crsd process is stopped or suspended. In this case, it should check …