Arvind Toorpu

Database Administration & Architecture

Hi, I’m Arvind Toorpu.

I’m a Database Admin/Architect with 14+ years managing Oracle, SQL Server, and cloud (AWS/RDS) systems. This blog covers the cloning, tuning, security, and migration work that keeps databases running.

Read the blog
About me
Arvind Toorpu

  • The Importance of Data Compression in Oracle Databases

    The Importance of Data Compression in Oracle Databases

    Maximizing Storage Efficiency with Advanced Database Compression: Benefits, Challenges, and Implementation StrategiesIntroductionThe exponential growth of data presents increasing challenges for organizations in managing storage, performance, and backup operations efficiently. Advanced database compression is a powerful solution that enables businesses to optimize their database environments by reducing storage requirements, improving query…

    Continue reading →: The Importance of Data Compression in Oracle Databases

  • Efficiently Managing Columns in Oracle: Marking and Dropping Unused Columns

    Efficiently Managing Columns in Oracle: Marking and Dropping Unused Columns

    Efficiently 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 million rows. Dropping such a column can take significant time,…

    Continue reading →: Efficiently Managing Columns in Oracle: Marking and Dropping Unused Columns

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

    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

    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 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

    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 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

    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

    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

        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

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts