Home

PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing – Oracle installation requires old rpm versions, what to do?

Below packages can usually be ignored as oracle installer thinks they are not available and are still needed while they already exists. [root@rac2 Desktop]# yum install libaio-0.3.105-2.i386.rpm Loaded plugins: refresh-packagekit, security Setting up Install Process No package libaio-0.3.105-2.i386.rpm available. Error: Nothing to do [root@rac2 Desktop]# rpm -ivh compat-libstdc++* error:…
Continue reading →: PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing – Oracle installation requires old rpm versions, what to do?
LAST DDL change time on a table in ORACLE Database

A general question among most of developers is ” HOW can I know when LAST DDL was done??” The best option will be to go and look at the table details. While you can also query the same details from user_objects/dba_objects. Lets create a table test1 sql > create table…
Continue reading →: LAST DDL change time on a table in ORACLE Database
Oracle Virtual Columns: A Powerful Feature in Database Design

Oracle Virtual Columns: A Powerful Feature in Database Design Oracle Virtual Columns: A Powerful Feature in Database Design Oracle 11g introduced the concept of Virtual Columns, a unique feature that allows dynamic calculations within a table. These columns behave like regular table columns but with some significant differences, making them…
Continue reading →: Oracle Virtual Columns: A Powerful Feature in Database Design
Configure Putty tunnel

How to Configure WinSCP and PuTTY for SSH Tunneling Setting up WinSCP and PuTTY to use SSH tunneling ensures secure and efficient connections to your servers through an intermediate host. This guide provides step-by-step instructions for configuring both tools. WinSCP Configuration The WinSCP configuration is straightforward, leveraging its “tunnel” feature.…
Continue reading →: Configure Putty tunnel
Oracle Database DBMS_SCHEDULER: Creating and Managing Jobs

Oracle DBMS_SCHEDULER: Creating and Managing Jobs The DBMS_SCHEDULER package in Oracle is a powerful tool for scheduling and automating tasks. Unlike its predecessor, DBMS_JOB, it provides advanced features such as calendaring expressions, better logging, and robust error handling. This article explores the key operations you can perform with DBMS_SCHEDULER, including…
Continue reading →: Oracle Database DBMS_SCHEDULER: Creating and Managing Jobs
Oracle Table Monitoring – DML ACTIVITY

Monitoring Table DML Activity in Oracle Monitoring Table DML Activity in Oracle: Inserts, Updates, and Deletes Monitoring Data Manipulation Language (DML) activity in Oracle provides insights into the volume of INSERT, UPDATE, and DELETE operations on a table. This information can be valuable for performance tuning and decision-making. Here, we…
Continue reading →: Oracle Table Monitoring – DML ACTIVITY
Automating AWR Report Delivery via Email with PL/SQL

This is a fantastic script originally shared by Gokhan Atil (ORACLE ACE) that automates the generation and delivery of AWR (Automatic Workload Repository) reports via email. I’ve adapted and shared it here as it can be extremely helpful in daily database maintenance tasks. The script utilizes Oracle’s DBMS_WORKLOAD_REPOSITORY package to…
Continue reading →: Automating AWR Report Delivery via Email with PL/SQL
Disable Table Names Starting with TMP or BAK in Oracle Database

Disable Table Names Starting with TMP or BAK in Oracle Database In certain scenarios, you may want to enforce a naming convention in your Oracle Database to prevent tables from being created with names starting with specific prefixes, such as TMP_ or BAK_. This article demonstrates how to…
Continue reading →: Disable Table Names Starting with TMP or BAK in Oracle Database
Connecting to CDB and PDB – Oracle Database 12c

Connecting to CDB and PDB in Oracle Using Easy Connect Syntax Connecting to CDB and PDB in Oracle Using Easy Connect Syntax When a Container Database (CDB) is created in Oracle, a service is automatically created with the same name as the CDB. Similarly, when a Pluggable Database (PDB) is…
Continue reading →: Connecting to CDB and PDB – Oracle Database 12c
Working with Tables and Materialized Views in Oracle: A Practical Guide

“Materialized views are a powerful feature in Oracle databases that enhance performance by storing query results, making data retrieval faster and more efficient. However, one key aspect often overlooked is the need to keep these views synchronized with the base tables, especially when underlying data changes. In this guide, we’ll…
Continue reading →: Working with Tables and Materialized Views in Oracle: A Practical Guide