ORACLE

The PDB$SEED or SEED database is a pluggable database template for pluggable databases to be created by users. Used as a template to create new …

Steps to Apply Patch on DB Home This document shows how to apply patch on Oracle home / databases. July 2019 PSU for Oracle databases. …

You can query the CDB column in the V$DATABASE view to see if a database is CDB. If the current database is CDB, the column …

As of Oracle 11g R1, long-running queries or queries that we run with the / * MONITOR * / hint are automatically monitored. During the …

You can also change the port of Enterprise Manager Database Express 12c after installation. You can find the current port as follows. [crayon-67d4eda584c7f330671832/] You can …

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 …

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 …

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 …

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 …

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 …