ORACLE

OutOfMemoryError error may be received because of inadequate memory when running addnode.sh or during Oracle database installation. addnode.sh is terminated as follows when the error …

When connecting to Oracle 12.2 databases from different databases with db link, reco process terminates unexpectedly. This problem is caused by bug 27544973. In order …

Prior to the Oracle 12c version, droping an index was an offline process that put a lock on the original table in exclusive mode. Exclusive …

We often need to get information about existing sessions in databases. We can find the below details with the help of the following query. Which …

If a user want to drop a DB link belonging to a schema in Oracle databases, it searches for that DB link under the schema …

The most recent password change date for users in the Oracle database is in the ptime field in the sys.user $ table. With a query …

Any problem with multicast traffic between Oracle RAC database servers can cause network heartbit problems between servers. In this case you need to see the …

In the database, it may sometimes be necessary to disable system triggers during operations such as java installation, downgrade, or upgrade. An error in a …

While current transaction waiting for a lock in a session, the following error will occur in the database when the corresponding session terminated unexpectedly with …

When a user tries to create a materialized view in a different schema, if the user of that schema does not have create table authority, …