Most read
RMAN's MAXPIECESIZE, SECTION SIZE and MAXSETSIZE
The smallest example that demonstrates each of these three RMAN parameters, with the trade-offs.
Oracle Database
Architecture, backup & recovery, PL/SQL and day-to-day DBA scenarios — 12c through 19c. Every page is written from real production work, not paraphrased docs.
Start here
About Oracle Database — architecture, files, processes
SGA, PGA, control files, processes — the mental model every DBA needs.
Scenario
Recovering a single table from RMAN in a PDB
One command, no full restore — when it works, when it doesn't, and what happens behind the scenes.
Fundamentals
5 articlesAbout Oracle Database
Architecture, files, memory, processes — the mental model every DBA needs.
About SQL*Plus
Connection screens, scripts, formatting, and the flags you'll wish you knew sooner.
About Oracle PL/SQL
Blocks, packages, exceptions, cursors — the shape of every PL/SQL program.
Oracle Instance Recovery, explained
What happens between SHUTDOWN ABORT and the next OPEN — redo, checkpoint, SMON.
Connecting MS Access to Oracle
ODBC setup, the few settings that matter, and a working linked-table example.
Backup & recovery
4 articlesAbout backup, recovery and RMAN
What RMAN actually does, why it beats user-managed backups, and how to connect.
RMAN's MAXPIECESIZE, SECTION SIZE & MAXSETSIZE
Three parameters DBAs reach for when backups don't fit, parallelize, or finish.
"Recover Table" feature in Oracle 12c (PDB)
Single-table recovery from RMAN backup, when full restore isn't an option.
Flashback techniques using UNDO
Recover deleted rows without restoring from backup — query, version, transaction.
PL/SQL
3 articlesWrite to a file from PL/SQL with UTL_FILE
Directory objects, permissions, line breaks, error handling — a full working example.
Using DBMS_APPLICATION_INFO
How to tag long-running sessions so you can spot them in V$SESSION.
Refresh a remote table
DB links, materialized views, and when to use which.
Errors & troubleshooting
2 articlesCertification
3 articlesCurrent Oracle Database certifications, mapped
OCA, OCP, OCM — what's required, what each is worth on a CV.
Tips for Oracle certification preparation
Study plan that worked, the materials that didn't, and how to time the exam.
DBA or PL/SQL — which path should you choose?
How the day-to-day work differs, and how the careers shape up over time.