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 …
Read More »
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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »