ORACLE

To perform various operations on database objects, system and object privileges must be assigned to users. Each system privilege allows a user to perform certain …

You can find the undo usage of a session with the following query. Historical information is also available. You can find the undo usage of …

You may need to enable trace for a session for many reasons. For example, you may need to determine which queries run in a session. …

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-6742c763e6bb5181286132/] 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 …