Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
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 »
ORACLE
Data Dictionary Views For Backup and Recovery
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 »
How To Find Query History On Oracle
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 »
How To Find Process Informations of a Session(Kill Oracle Session)
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 »
Profile password verify function issue(FROM ROOT)
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 »
How To Fix The SQL Plan in Oracle Databases
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 »
Displaying Errors in Oracle Services With ADRCI
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 »
How To Move All Objects of a Schema to a Different Tablespace
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 »
How To Move Datafile Online in Oracle 12c
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 »
Data Pump Import/Export is Running Slow or Hangs
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 »