Site Index

Browse all posts on Oracle Apps DBA, organized by topic. Click any post title to read it, or jump to a category using the buttons below.

Exadata Oracle Cloud Performance and Tuning Oracle Database E-Business Suite Scripts and Tools Miscellaneous

Exadata

Post Title	What It Covers
Oracle Exadata Smart Scan Explained Smart Scan	How Smart Scan offloads SQL processing to storage cells, enabling full table scans to execute directly on Exadata storage nodes.
Exadata X8M : Cell Disks and ASM Disks Overview Storage	Overview of Cell Disks and ASM Disk Groups on the Exadata X8M platform and how storage is configured.
Exadata X8M : Storage High Availability Demo Storage HA	Demonstration of Exadata built-in storage high availability and how the platform handles storage cell failures.
Exadata X8M Machine - Background Processes Architecture	Walk-through of key Exadata background processes running on compute and storage nodes.
Exadata X8M Smart Flash Cache : Write Back and Write Through Mode Conversion Flash Cache	How to convert Exadata Smart Flash Cache between Write Back and Write Through modes.

Back to top

Oracle Cloud (OCI)

Post Title	What It Covers
Create Oracle Cloud Free Tier Account Getting Started	Step-by-step guide to signing up for OCI Always Free tier.
Autonomous Database Creation on OCI Free Tier Autonomous DB	How to provision an Oracle Autonomous Database on OCI Free Tier.
Data Safe - Introduction Security	Introduction to Oracle Data Safe for risk assessment, data masking, and database activity auditing on OCI.
Connect to Private Instance in OCI Using Bastion Service Bastion	How to use OCI Bastion Service to securely connect to private compute instances without a public IP.
Allow Port in Firewall - Linux - OCI Networking	Opening specific ports in Linux firewall on OCI compute instances including Security List configuration.
IPSec Site-to-Site VPN Demo Using Libreswan as CPE on OCI Free Tier VPN	Building a site-to-site IPSec VPN tunnel on OCI using Libreswan as the Customer Premises Equipment.
Create New OS User, Enable SSH and Generate Key Pair in OCI Compute	Creating OS users on OCI compute instances and enabling SSH key-based access.
Increase SGA in OCI VMDB Systems with Huge Pages Setup VMDB	How to increase Oracle SGA on OCI VM Database Systems and configure Linux Huge Pages.
OCI VMDB System : Upgrade Database from 12c to 19c Using dbcli VMDB	Full walkthrough of upgrading Oracle Database from 12c to 19c on OCI VM Database System using dbcli.
OCI VMDB System : Delete Old Oracle Home Post Database Upgrade Using dbcli VMDB	Cleanup steps after database upgrade on OCI VMDB - removing the old Oracle Home using dbcli.
OCI VMDB System : Apply GI PSU Using dbcli VMDB	Applying Grid Infrastructure Patch Set Update on OCI VM Database System using dbcli utility.
EBS Cloud Backup Module Backup	Setting up the Oracle E-Business Suite Cloud Backup Module on OCI for automated EBS backups.

Back to top

Performance and Tuning

Post Title	What It Covers
AWR Comparison Report AWR	How to generate and interpret AWR Comparison Reports to identify performance regressions.
AWR Baselines AWR	Creating and using AWR Baselines to capture normal performance metrics for comparison.
Modify AWR Interval and Retention Periods in 12C AWR	Adjusting AWR snapshot interval and retention settings in Oracle 12c.
PLAN TABLE in Oracle Execution Plans	Understanding Oracle PLAN_TABLE - how to use EXPLAIN PLAN and analyze SQL execution paths.
Using Parallelism in Oracle Database 12C Parallelism	How to leverage Oracle parallel query execution for large analytical queries.
Check the Performance of Index Skip Scan Index	Testing and validating Index Skip Scan behavior in Oracle 19c.
Column Order in Composite Index Index	Why column order in a composite index matters with practical performance examples.
Testing Different Access Paths : With and Without Index Index	Side-by-side comparison of query performance with and without an index via execution plans.
Testing Different Access Paths : Compare Single Column Index Access Index	Comparing single-column index access patterns - full scan vs range scan vs unique scan.
Testing Different Access Paths : Concatenated Index Index	How Oracle uses concatenated indexes for different query patterns.

Back to top

Oracle Database

Post Title	What It Covers
Oracle Database 23ai - New Features for DBAs 23ai	Key new features in Oracle Database 23ai - AI Vector Search, True Cache, JSON Relational Duality, and more.
Database Replay - Real Application Testing (RAT) Testing	Using Oracle Database Replay to capture and replay production workloads on a test system.
Bitmap Index Use Case Index	When and why to use Bitmap indexes for low-cardinality columns in data warehouse scenarios.
Create SQL Plan Baselines for High Resource Intensive SQL Plan Management	Locking in stable execution plans using SQL Plan Baselines via DBMS_SPM.
19C : Pluggable Database in Restricted Mode Due to Datapatch PDB / Patching	Diagnosing and resolving a PDB stuck in restricted mode after patching in Oracle 19c.
Change CDB and PDB Names in 12c PDB	Step-by-step procedure for renaming a Container Database and Pluggable Databases in Oracle 12c.
Queries on Locks and Blocks Troubleshooting	SQL queries to identify locking and blocking sessions - find blockers, waiters, and the SQL causing locks.
APEX, ORDS and TOMCAT Setup APEX	Full setup guide for Oracle APEX with ORDS deployed on Apache Tomcat.
Script to Monitor Dataguard Log Gap Data Guard	Shell script to monitor and alert on Data Guard redo log apply gap.

Back to top

E-Business Suite

Post Title	What It Covers
Provision EBS Instance Using EBS Cloud Manager Cloud Manager	How to provision Oracle E-Business Suite 12.2 on OCI using the EBS Cloud Manager console.
Launch EBS 12.2.11 Vision Demo Image on OCI Demo	Launching the Oracle EBS 12.2.11 Vision Demo pre-built image on OCI for testing.
EBS R12.2 : Managed Servers Failed to Start After Server Crash Troubleshooting	Diagnosing and fixing WebLogic Managed Server startup failures in EBS R12.2 after server crash.
fs_clone Issue R12.2	Troubleshooting common fs_clone errors in EBS R12.2 during online patching.
EBS Cloud Backup Module Backup	Configuring the EBS Cloud Backup Module on OCI for automated scheduled backups.

Back to top

Scripts and Tools

Post Title	What It Covers
Script to Monitor ORA Errors in Alert Log Monitoring	Shell script to scan Oracle alert log for ORA- errors with optional email alerts for cron use.
Script to Monitor Dataguard Log Gap Data Guard	Monitoring script to detect and alert on Data Guard redo apply lag with email notification.
Sample RMAN Backup Script Backup	Ready-to-use RMAN backup script covering full database backup, archived log backup, and retention policy.
Queries on Locks and Blocks SQL Scripts	Collection of SQL scripts to identify blocking sessions, lock holders, and long-running transactions.

Back to top

Miscellaneous

Post Title	What It Covers
Excel : Highlight Matching or Unique Values in Two Columns Excel	Using conditional formatting in Excel to highlight matching or unique values across two columns.
Create New OS User, Enable SSH and Generate Key Pair in OCI Linux	Creating OS-level users on OCI compute with SSH key-based authentication.
Create SQL Plan Baselines DBA Tips	Using DBMS_SPM to create, verify, and evolve SQL Plan Baselines for stabilizing execution plans.
APEX, ORDS and TOMCAT Setup Web Stack	Complete setup of Oracle APEX with ORDS middleware on Apache Tomcat servlet container.
Increase SGA in OCI VMDB Systems with Huge Pages Memory	Configuring Linux Huge Pages and increasing Oracle SGA on OCI VM Database Systems.

Back to top