Services Blogs Case Studies Research Free Tools About Schedule Consultation

⚠ Oracle's LMS scripts log every option and pack ever touched — including the ones a DBA enabled by accident. Get an independent feature-usage review before Oracle runs theirs.

White Paper — Database Options Trap

The Accidental Option: How Oracle Bills You for Features You Never Switched On

Last updated: June 2026

Oracle Database ships with options and management packs that switch themselves on the moment a DBA runs a routine command, builds an index, or opens a tuning screen. You never bought them. You never meant to use them. But Oracle's scripts recorded every event — and at audit time, each one becomes a back-licence claim. This white paper shows you exactly which features detonate, how Oracle proves usage, and how to shut the exposure down before an auditor ever asks.

34 pages
Option auto-enable matrix
DBA_FEATURE_USAGE query
Pre-audit remediation steps

Why this matters now: Oracle's own feature-tracking view, DBA_FEATURE_USAGE_STATISTICS, records option use whether or not you ever licensed it — and it cannot be retroactively cleaned without leaving a trail. A single accidental Partitioning, Diagnostics Pack, or Tuning Pack flag on a multi-core Enterprise Edition server can generate a six- or seven-figure claim. The time to find these is before Oracle's script does, not after.

What's Inside

  • The complete list of Database options and management packs that auto-enable from ordinary DBA activity — and the exact commands that trip each one
  • How Oracle's LMS scripts and DBA_FEATURE_USAGE_STATISTICS prove you "used" a feature, even for a single index or a one-off query
  • The packs most often caught in audits — Diagnostics Pack, Tuning Pack, Partitioning, Advanced Compression, and the In-Memory trap on 12c+
  • Why default-on parameters and OEM console clicks create exposure your DBAs don't even register as "usage"
  • The remediation playbook: how to disable, document, and defensibly demonstrate non-use before an audit lands
  • What you are — and are not — obligated to hand Oracle when they ask for feature-usage output

Inside the Field Guide

Section 01
How Options Differ From the Database You Bought
Section 02
The Auto-Enable Mechanics — What Trips Each Option
Section 03
DBA_FEATURE_USAGE_STATISTICS — Oracle's Evidence Trail
Section 04
The Packs Most Often Caught at Audit
Section 05
Self-Assessment: Running the Check Yourself
Section 06
Remediation & Defensible Non-Use

Sample Insights from the Field Guide

Insight 01 — The One-Click Pack

"A DBA who opens the Performance or AWR pages in Oracle Enterprise Manager has, in Oracle's view, used the Diagnostics Pack — a separately licensed option. No purchase, no warning, no confirmation dialog. The console simply works, the feature flag is set, and the usage is logged. At audit, Oracle does not ask whether you meant to use it. They ask how many cores the database runs on, and they multiply."

Insight 02 — Partitioning By Accident

"Partitioning is the option enterprises most often deploy without realising it costs extra. A developer partitions one large table for performance, or a vendor's schema ships partitioned objects, and Enterprise Edition cheerfully creates them. The feature is licensed per processor across the entire database — not per partitioned table. One accidental partition exposes every core on the server."

Insight 03 — You Can't Just Delete the Evidence

"DBAs who discover accidental usage often want to reset the feature-usage history. Oracle's view retains historical samples, and a sudden gap is itself a flag. The defensible path is not erasure — it is documented remediation: disable the feature, record the date and reason, and build a contemporaneous evidence file showing the use was incidental and has stopped. That file is what protects you when Oracle disputes the timeline."

Free Download

Download the Accidental Option Field Guide

34 pages. Immediate access. No spam — only relevant Oracle licensing intelligence from our advisory team.

You'll be redirected to the download immediately. We'll also email you the link.

Not affiliated with Oracle
100% confidential
Former Oracle insiders
40%+
Of enterprise databases show accidental Diagnostics Pack usage
3–5×
Typical Oracle audit claim vs. what the customer actually owes
$500M+
Verified client savings across engagements
25+
Years of Oracle licensing expertise on our team

Find the Accidental Options Before Oracle Does

Our Audit Defense team runs an independent, forensic review of your feature-usage data, identifies accidental option and pack exposure, and builds the contemporaneous evidence file that lets you remediate defensibly. Start with our Oracle Database Licensing Guide or review a client case study.