Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
As of Oracle 11g R1, long-running queries or queries that we run with the / * MONITOR * / hint are automatically monitored. During the …
Read More »
ORACLE
How To Change Enterprise Manager Database Express Port in 12c
You can also change the port of Enterprise Manager Database Express 12c after installation. You can find the current port as follows. [crayon-676cef047c5b3458827743/] You can …
Read More »
Grant Read-Only Access To Enterprise Manager Database Express 12c
Oracle Enterprise Manager Database Express, or EM Express, is a web-based tool used to manage Oracle 12c databases. In order to ensure that the user …
Read More »
opidrv aborting process J00n ospid (nnnnn) as a result of ORA-1013
In Oracle 12.2 databases, this error is written in the alertSID.log file when the default maintenance job is timeout and the corresponding job is automatically …
Read More »
How To Find Which Groups(OSDBA,OSASM,OSOPER,DBA) have set During Oracle Database Installation
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 »
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 »