-
Oracle Table Monitoring – DML ACTIVITY
Continue reading →: Oracle Table Monitoring – DML ACTIVITYMonitoring 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…
-
Automating AWR Report Delivery via Email with PL/SQL
Continue reading →: Automating AWR Report Delivery via Email with PL/SQLThis 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…
-
Disable Table Names Starting with TMP or BAK in Oracle Database
Continue reading →: Disable Table Names Starting with TMP or BAK in Oracle DatabaseDisable 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,…
-
Connecting to CDB and PDB – Oracle Database 12c
Continue reading →: Connecting to CDB and PDB – Oracle Database 12cConnecting to CDB and PDB in Oracle Using Easy Connect Syntax Connecting to CDB and PDB in Oracle Using Easy Connect Syntax When a Container Database (CDB) is created in Oracle, a service is automatically created with the same name…
-
Working with Tables and Materialized Views in Oracle: A Practical Guide
Continue reading →: Working with Tables and Materialized Views in Oracle: A Practical Guide“Materialized views are a powerful feature in Oracle databases that enhance performance by storing query results, making data retrieval faster and more efficient. However, one key aspect often overlooked is the need to keep these views synchronized with the base…
-
Create Oracle Control file manually
Continue reading →: Create Oracle Control file manuallyWhen to create control files ? Create control files in situations when : 1. You have lost all your control files. 2. When you want to rename your database name (db_name); Note :although we can use utility called DBNEWID to…
-
Oracle Database files to be excluded in Anti-virus or any third party tools scan
Continue reading →: Oracle Database files to be excluded in Anti-virus or any third party tools scanOracle Database Files to Exclude from Antivirus and Third-Party Scans Oracle Database Files to Exclude from Antivirus and Third-Party Scans Properly managing antivirus and third-party scans is critical for maintaining the stability and performance of your Oracle Database. Failing to…
-
QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE Database
Continue reading →: QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE DatabaseFinding Archive gap between PRIMARY and STANDBY A Physical Standby database syncs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby is less than 10-15 numbers, We can…
-
Working with Oracle Database Flashback Recovery
Continue reading →: Working with Oracle Database Flashback RecoveryConfiguring Flashback Recovery in Oracle Database Flashback Database is a powerful feature in Oracle that allows you to rewind your database to a previous state without requiring traditional point-in-time recovery. Starting from Oracle 11g R2, enabling Flashback Database no…
-
Audit Failed Logon Attempts in Oracle Database
Continue reading →: Audit Failed Logon Attempts in Oracle DatabaseAudit Failed Logon Attempts in Oracle Database. Failed logon attempts can cause account locks, resulting in disruptions for users and increased workload for DBAs. Identifying the source of failed logon attempts is crucial for troubleshooting and preventing further…
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.
