Oracle 19c introduces the MAX_DATAPUMP_PARALLEL_PER_JOB parameter to control and limit the number of parallel threads a single Data Pump job can use. This parameter enhances resource management, preventing a single Data Pump job from monopolizing the system.

Oracle Linux provides the yum utility which you can use to install or upgrade RPM packages. The […]

vi (pronounced “vee-eye,” short for visual display editor) is the standard SunOS text editor. vi is not window […]

The content outlines various vi commands for text editing in a file. It covers cursor movement, text insertion, substitution, deletion, undoing changes, and copying or moving text. Key commands include navigating the cursor, inserting text, changing or deleting words and lines, and utilizing yank and put for copying and moving text effectively.

How to resolve Patch Conflict error while applying patches in Oracle database.

Active Session History

The error related to the memory_target parameter during Oracle Database upgrades is due to insufficient size of /dev/shm, which must be at least 1.125GB. To resolve the issue, adjust the /etc/fstab entry, remount /dev/shm, and restart the database. In Docker, increase size with ‘–shm-size=2.00gb’.

Cluster Domain consists of a single Domain Services Cluster (DSC) and one or more Member Clusters. DSC provides many services which can be utilized by Member Clusters.

How the query optimizer chooses the a specific plan to execute SQL? A SQL Statement […]

This feature enables you to upgrade an existing installation of Oracle database to Oracle Database 11g Release 2 (11.2.0.4) into the