-
Auditing Enhancements in Oracle Database 21c: A New Era of Governance and Security
Continue reading →: Auditing Enhancements in Oracle Database 21c: A New Era of Governance and SecurityAuditing Enhancements in Oracle Database 21c 🔐 Auditing Enhancements in Oracle Database 21c Oracle Database 21c introduces powerful auditing improvements designed to increase real-time observability, enhance security compliance, and support modern enterprise governance strategies. This article covers all major enhancements…
-
Mastering Concurrent Materialized View Refreshes in Oracle Database 23ai: A Deep-Dive for Experienced DBAs
Continue reading →: Mastering Concurrent Materialized View Refreshes in Oracle Database 23ai: A Deep-Dive for Experienced DBAsMastering Concurrent Materialized View Refreshes in Oracle Database 23ai: A Deep-Dive for Experienced DBAs Materialized views serve as a keystone for performance tuning in Oracle databases, offering a persistent, precomputed store for results of resource-intensive queries. By using materialized views,…
-
Turbocharging Oracle Data Loads: A DBA’s Field Guide
Continue reading →: Turbocharging Oracle Data Loads: A DBA’s Field GuideAfter 15 years optimizing database performance, I’ve found that few improvements deliver more business value than accelerating data loader jobs. Whether you’re running nightly ETL processes or real-time data integration, slow data loads can bottleneck your entire operation. Here’s my…
-
Efficient Management of Bigfile Tablespaces in Oracle Database
Continue reading →: Efficient Management of Bigfile Tablespaces in Oracle DatabaseIn 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…
-
Unlocking Powerful Database Object Metadata with Oracle’s DBMS_DEVELOPER Package
Continue reading →: Unlocking Powerful Database Object Metadata with Oracle’s DBMS_DEVELOPER PackageEnhancing 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…
-
Detailed Step-by-Step Guide for Oracle Database Migration Using RMAN Transportable Tablespaces
Continue reading →: Detailed Step-by-Step Guide for Oracle Database Migration Using RMAN Transportable TablespacesThis 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…
-
High Level Guide to Implementing a Physical Standby Database Using Data Guard Broker in Oracle 21c
Continue reading →: High Level Guide to Implementing a Physical Standby Database Using Data Guard Broker in Oracle 21cHigh 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…
-
Oracle Database 23 AI for DBAs: Top 10 Performance-Boosting Features
Continue reading →: Oracle Database 23 AI for DBAs: Top 10 Performance-Boosting FeaturesOracle 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…
-
Oracle RMAN Table Point-in-Time Recovery (TSPITR): A Step-by-Step Guide
Continue reading →: Oracle RMAN Table Point-in-Time Recovery (TSPITR): A Step-by-Step GuideOracle 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…
-
Recovery Manager (RMAN) Table Point-in-Time Recovery (PITR) in Oracle Database 12c
Continue reading →: Recovery Manager (RMAN) Table Point-in-Time Recovery (PITR) in Oracle Database 12cOracle 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…
Oracle ACE Pro · AWS Community Builder
Arvind Toorpu
Oracle Certified Professional and Cloud Ops Database Manager at a financial services firm. Fourteen years architecting and running Oracle, SQL Server, PostgreSQL and MySQL estates, including migrations of hundreds of databases to AWS, Azure and OCI.
This blog is the tuning, recovery, security and migration work behind that — written up as it actually happened, errors included.
Oracle ACE Pro 2026 · AWS Community Builder 2026 · Oracle Certified Professional
Oracle · SQL Server · PostgreSQL · MySQL | AWS · Azure · OCI | Awards · Publications
Browse by topic
Oracle · Backup & Recovery · Administration & Maintenance · Security & Auditing · Cloud & Migration · Performance & Tuning · SQL Server · PostgreSQL & Aurora · All topics →
Latest writing
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.
