-
Efficiently Managing Columns in Oracle: Marking and Dropping Unused Columns
Continue reading →: Efficiently Managing Columns in Oracle: Marking and Dropping Unused ColumnsEfficiently Managing Columns in Oracle: Marking and Dropping Unused Columns Efficiently Managing Columns in Oracle: Marking and Dropping Unused Columns There may be situations where you need to drop a column containing a large amount of data, such as 10…
-
PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing – Oracle installation requires old rpm versions, what to do?
Continue reading →: 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.…
-
LAST DDL change time on a table in ORACLE Database
Continue reading →: LAST DDL change time on a table in ORACLE DatabaseA 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…
-
Oracle Virtual Columns: A Powerful Feature in Database Design
Continue reading →: Oracle Virtual Columns: A Powerful Feature in Database DesignOracle 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…
-
Configure Putty tunnel
Continue reading →: Configure Putty tunnelHow 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…
-
Oracle Database DBMS_SCHEDULER: Creating and Managing Jobs
Continue reading →: Oracle Database DBMS_SCHEDULER: Creating and Managing JobsOracle 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…
-
Oracle Table Monitoring – DML ACTIVITY
Continue reading →: Oracle Table Monitoring – DML ACTIVITYMonitoring 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…
-
Automating AWR Report Delivery via Email with PL/SQL
Continue reading →: Automating AWR Report Delivery via Email with PL/SQLThis 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…
-
Disable Table Names Starting with TMP or BAK in Oracle Database
Continue reading →: Disable Table Names Starting with TMP or BAK in Oracle DatabaseDisable 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,…
-
Connecting to CDB and PDB – Oracle Database 12c
Continue reading →: Connecting to CDB and PDB – Oracle Database 12cConnecting 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…



