Arvind Toorpu

Blog Posts

  • 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 response times, and minimizing backup…

  • 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, and Oracle will lock the…

  • 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: File not found by glob:…

  • 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 test1 (id number); table TEST1…

  • 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 highly useful for specific use…

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