Blog Posts

Oracle Table Monitoring – DML ACTIVITY

April 25, 2024

Monitoring 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 can be valuable for performance tuning and decision-making. Here, we walk through how to enable…
Automating AWR Report Delivery via Email with PL/SQL

March 2, 2024

This 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 database maintenance tasks. The script utilizes Oracle’s DBMS_WORKLOAD_REPOSITORY package to generate an HTML-format AWR report…
Disable Table Names Starting with TMP or BAK in Oracle Database

February 25, 2024

Disable 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, such as TMP_ or BAK_. This article demonstrates how to implement a database trigger to…
Connecting to CDB and PDB – Oracle Database 12c

January 24, 2024

Connecting 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 as the CDB. Similarly, when a Pluggable Database (PDB) is created within the CDB, a…
Working with Tables and Materialized Views in Oracle: A Practical Guide

August 17, 2023

“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 tables, especially when underlying data changes. In this guide, we’ll explore the creation and management…