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

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

    Continue reading →: Efficient Management of Bigfile Tablespaces in Oracle Database

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

    Continue reading →: Unlocking Powerful Database Object Metadata with Oracle’s DBMS_DEVELOPER Package

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

    Continue reading →: Detailed Step-by-Step Guide for Oracle Database Migration Using RMAN Transportable Tablespaces

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

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

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

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

  • Oracle RMAN Table Point-in-Time Recovery (TSPITR): A Step-by-Step Guide

    Oracle RMAN Table Point-in-Time Recovery (TSPITR): A Step-by-Step Guide

    Oracle RMAN Table Point-in-Time Recovery (TSPITR) is a powerful feature in Oracle 12c that allows you to recover individual tables or partitions to a specific point in time without restoring the entire database. This step-by-step guide walks you through the process, including identifying the recovery point, performing TSPITR, and exporting/importing…

    Continue reading →: Oracle RMAN Table Point-in-Time Recovery (TSPITR): A Step-by-Step Guide

  • Recovery Manager (RMAN) Table Point-in-Time Recovery (PITR) in Oracle Database 12c

    Recovery Manager (RMAN) Table Point-in-Time Recovery (PITR) in Oracle Database 12c

    Oracle Database 12c revolutionizes data recovery with its enhanced RMAN Table Point-in-Time Recovery (PITR) feature. This powerful tool automates the restoration of tables or partitions to a specific SCN, timestamp, or log sequence—eliminating manual cloning and export steps. Whether recovering accidental deletions, corrupted data, or migrating historical datasets, this article…

    Continue reading →: Recovery Manager (RMAN) Table Point-in-Time Recovery (PITR) in Oracle Database 12c

  • Password Strength and Profile Settings in Oracle Databases

    Password Strength and Profile Settings in Oracle Databases

    Enforcing strong password policies is essential for safeguarding Oracle databases. This article explores how to create custom password verification functions using the password_verify.create_verify_function procedure, configure user profiles for password management, and enforce robust password encryption practices. Detailed examples and best practices are provided to help database administrators enhance security and…

    Continue reading →: Password Strength and Profile Settings in Oracle Databases

  • Enforcing Password Strength and Profile Settings in Amazon RDS for Oracle

    Enforcing Password Strength and Profile Settings in Amazon RDS for Oracle

    Enforcing strong password policies is essential for safeguarding Oracle databases in Amazon RDS. This article explores how to create custom password verification functions using the rdsadmin.rdsadmin_password_verify.create_verify_function procedure, configure user profiles for password management, and enforce robust password encryption practices. Detailed examples and best practices are provided to help database administrators…

    Continue reading →: Enforcing Password Strength and Profile Settings in Amazon RDS for Oracle

  • Scheduling a Job to Gather Statistics in Oracle Database Weekly for Stale Statistics

    Scheduling a Job to Gather Statistics in Oracle Database Weekly for Stale Statistics

    Scheduling a Job to Gather Statistics in Oracle Database Weekly for Stale Statistics Scheduling a Job to Gather Statistics in Oracle Database Weekly for Stale StatisticsGathering statistics in Oracle Database is crucial for ensuring the optimizer has up-to-date information to generate efficient execution plans. Stale or outdated statistics can lead…

    Continue reading →: Scheduling a Job to Gather Statistics in Oracle Database Weekly for Stale Statistics

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