Arvind Toorpu

Blog Posts

  • Efficient Management of Bigfile Tablespaces in Oracle Database

    Efficient Management of Bigfile Tablespaces in Oracle Database

    In modern database management, efficiency and optimization are pivotal, especially when dealing with large datasets in Oracle Database. This article provides a comprehensive guide on how to create, analyze, and manage a bigfile tablespace effectively, with particular emphasis on shrinking operations to reclaim unused space. Setup: Creating a Tablespace and User First, we need to…

  • Unlocking Powerful Database Object Metadata with Oracle’s DBMS_DEVELOPER Package

    Unlocking Powerful Database Object Metadata with Oracle’s DBMS_DEVELOPER Package

    Enhancing Database Management with Oracle’s DBMS_DEVELOPER Package In the world of database management, having access to metadata is crucial for maintaining and optimizing database performance. Oracle’s `DBMS_DEVELOPER` package, newly introduced in Oracle Database 23ai, provides robust tools for retrieving detailed metadata about database objects in a structured JSON format. This article will explore the functionality…

  • Detailed Step-by-Step Guide for Oracle Database Migration Using RMAN Transportable Tablespaces

    Detailed Step-by-Step Guide for Oracle Database Migration Using RMAN Transportable Tablespaces

    This article guides you through migrating Oracle databases from Windows to Linux using RMAN Transportable Tablespace by detailing the process from setting the source database to read-only, creating a transportable tablespace set, transferring files, and importing metadata. Additionally, it briefly outlines alternatives such as full export/import with Data Pump and using cross-platform transportable tablespaces for…

  • High Level Guide to Implementing a Physical Standby Database Using Data Guard Broker in Oracle 21c

    High Level Guide to Implementing a Physical Standby Database Using Data Guard Broker in Oracle 21c

    High Level Guide to Implementing a Physical Standby Database Using Data Guard Broker in Oracle 21c Introduction Oracle Data Guard is a vital feature for high availability, data protection, and disaster recovery in enterprise databases. In Oracle 21c, setting up a physical standby database is streamlined with the Data Guard Broker, making management and monitoring…

  • Oracle Database 23 AI for DBAs: Top 10 Performance-Boosting Features

    Oracle Database 23 AI for DBAs: Top 10 Performance-Boosting Features

    Oracle Database 23 AI is set to revolutionize the way database administrators optimize performance. This article dives into the top 10 new features—from JSON Relational Duality and native JSON data types to automatic indexing and integrated machine learning—that empower DBAs to streamline operations, reduce query latency, and bolster system reliability even under heavy workloads

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