Author: dbapranjan

Oracle Data Pump – New Diagnostic V$ Views For Performance Issues in 23ai

Oracle 23c AI introduces new V$ views to diagnose Data Pump performance issues. These views help monitor and troubleshoot Data Pump activities by providing detailed insights into job execution, resource usage, and potential bottlenecks. Key V$ Views: These views enable administrators to efficiently manage and optimize Data Pump tasks. The outputs will be needed, along […]

Postgres dB Installation in Linux

Red Hat Enterprise Linux 8 Step 1: Set up the EDB repository To determine if your repository exists, enter this command: If no output is generated, the repository isn’t installed. To set up the EDB repository: Install the EPEL repository: Enable additional repositories to resolve dependencies: Disable the built-in PostgreSQL module: Install the package Where <xx> is […]

NetworkManager tool in Linux

NetworkManager is a utility in Linux that simplifies the management of network connections and devices. It provides both command-line and graphical interfaces for configuring and controlling network settings. Two of the key tools associated with NetworkManager are nmtui and nmcli. 1. NetworkManager (nmcli): 2. NetworkManager TUI (nmtui): 3. Advantages of NetworkManager, nmtui, and nmcli:

CentOS 7 to Oracle Linux 8

CentOS 7 and Oracle Linux 8 are both popular Linux distributions that serve different purposes within the open-source community. CentOS 7: 1. Origin and Community-driven: Oracle Linux 8: Origin and Enterprise Focus: Transition from CentOS 7 to Oracle Linux 8: This guide explains how to combine a software upgrade and migration into a single process, […]

Basic SRVCTL Commands

SRVCTL, short for Server Control Utility, is a command-line tool, used to manage various entities in an Oracle Cluster environment, including databases, instances, listeners, services, and more. It allows you to perform various tasks like starting, stopping, modifying. Common Basic SRVCTL Commands: Start a database instance: SYNTAX – srvctl start database -d db_name [-o start_options] start_option – […]

Profile Metadata

Run this query first, so that it will print the complete metadata Now use DBMS_Meta_Data

Real Application Testing – Database Reply

Oracle Real Application Testing (RAT) was created to give DBAs the ability to make preemptive modifications while also knowing exactly what to expect when a change is done. It considerably reduces the possibility of any harmful consequences. Oracle RAT is made up of two major parts. The first component is referred to as Database Replay. […]