The JagatOCM feed
Articles, tutorials, and case studies from the Oracle community.
Mastering the Oracle 1Z0-071: My SQL Fundamentals Roadmap
A practical, week-by-week study plan that took me from rusty SQL to a passing score on the Oracle Database SQL Associate exam.
PL/SQL: When BULK COLLECT Beats Cursor Loops (and When It Doesn't)
BULK COLLECT can deliver 10x speedups — but only when you understand PGA memory and LIMIT clauses. Here's the breakdown.
Six Months on Oracle Autonomous Database: An Honest Review
I migrated a production OLTP workload to Autonomous Transaction Processing. Here's what surprised me — both good and bad.
Reading EXPLAIN PLAN Like a DBA: A Visual Guide
Stop guessing what your slow query is doing. Learn to read execution plans line by line, with annotated real-world examples.
A Modern RMAN Backup Strategy for 2025
Incrementally updated image copies, block change tracking, and recovery windows — a practical playbook for production.
Oracle SQL Window Functions: The Cheatsheet I Wish I Had
ROW_NUMBER, RANK, LAG, LEAD, and the frame clause — explained with copy-pasteable examples.