Database code and query output displayed on a developer screen
Oracle Compliance Scripts

Oracle license compliance scripts. Read the output before Oracle does.

A buyer side guide to Oracle license compliance scripts in 2026. What the LMS measurement script collects, why feature usage history drives the cost, and how to run and read the output before Oracle ever asks.

Contact Us Oracle Practice
500+Enterprise clients
$2B+Under advisory
Industry Recognized
500+ Enterprise Clients
$2B+ Under Advisory
11 Vendor Practices
100% Buyer Side Independent

Oracle license compliance scripts are the data collection programs Oracle uses to measure your database usage during an audit. The most important is the LMS measurement script, and it reports far more than installation. It captures options and management packs that may have been used once, by accident, and never disabled.

Key takeaways

  • The Oracle LMS script collects database configuration, options usage, and feature history.
  • Options usage is the costly part. A feature touched once still shows as used.
  • You can and should run the script yourself before Oracle does. Read the output first.
  • DBA_FEATURE_USAGE_STATISTICS is the view that drives most options findings.
  • Never send raw output to Oracle without expert review. Context changes the number.
  • Many findings are remediable. Disable unused options and document the date.

This guide is for DBAs and procurement leaders facing an Oracle measurement request in 2026. Read it with the LMS audit script analysis guide, the script output interpretation guide, and the audit triggers guide.

What are Oracle license compliance scripts?

They are SQL collection programs that read internal data dictionary views and produce a usage report. Oracle's License Management Services team provides them during a formal review. The output becomes the basis of the compliance position.

What does the LMS measurement script collect?

The script captures the database version and edition, installed options, management pack usage, and feature history. It reads views the application layer never touches. The detail surprises most teams the first time.

Why is feature usage history so important?

Oracle counts a feature as used if it was ever activated, even briefly. The DBA_FEATURE_USAGE_STATISTICS view records this history and drives most options findings.

  • Partitioning: one partitioned table can flag the option as used.
  • Diagnostics and Tuning Pack: a single AWR report can trigger a finding.
  • Advanced Compression: compressing one tablespace counts.

Can you run the scripts yourself?

Yes. The collection scripts can be run by your own DBA team against your databases. Doing so before Oracle asks gives you time to read the output, disable unused options, and prepare context.

How do you read the script output?

The raw output is a list of findings, not a bill. Each line needs context: was the feature used in production, was it a one time accident, is it covered by the contract. That context changes the number.

Common script findings and the buyer side response

Finding Where it comes from Often accidental? Buyer side response
Diagnostics Pack usedAWR or ADDM reportsYesDisable, document date.
Tuning Pack usedSQL Tuning AdvisorYesRestrict access, evidence.
Partitioning usedPartitioned objectsSometimesConfirm need, repartition.
Advanced CompressionCompressed segmentsSometimesUncompress if not needed.
Developer reading database query results on a dark terminal screen
The script output reads as fact, but each feature usage line is a claim that needs context before it becomes a number you owe.

How do you use the scripts in your defense?

Run them early, read them honestly, and remediate what you can. A clean position you built yourself is far stronger than a reaction to Oracle's version of the same data.

What can you remediate before an audit?

Disable options you do not use and stop the usage at the source. Document the date you disabled each one. Future collections then show the option as no longer in use.

  1. Identify every option flagged as used in the output.
  2. Confirm whether each is needed in production.
  3. Disable the unneeded ones and timestamp the change.

Should you send raw output to Oracle?

No. Never hand over raw collection output without review. Provide a reconciled position with context. Raw data invites the highest possible interpretation of every line.

When do you bring in expert help?

Before you respond to a formal measurement request. The interpretation of the output, not the collection of it, decides the cost. That is where experienced review pays for itself.

The script does not produce a bill. It produces a list of claims. Whoever reads those claims first, with context, controls the number, and that should be you, not the auditor.

What to do next

  1. Run the Oracle collection scripts against your own databases now.
  2. Review DBA_FEATURE_USAGE_STATISTICS for accidental options usage.
  3. Separate genuine production use from one time activations.
  4. Disable unused options and document each change with a date.
  5. Build a reconciled position with contract context, not raw output.
  6. Never submit unreviewed data to Oracle.
  7. Engage independent review before responding to any measurement request.

Frequently asked questions

What is the Oracle LMS script?

The Oracle LMS measurement script is a SQL collection program that reads internal database views to report version, edition, installed options, and feature usage history. Its output forms the basis of an Oracle compliance review.

Can I run the Oracle compliance scripts myself?

Yes. Your own DBA team can run the collection scripts. Running them before Oracle requests data lets you read the findings and remediate unused options first.

What is DBA_FEATURE_USAGE_STATISTICS?

It is the data dictionary view that records which database features have been used and when. It drives most Oracle options findings because it captures even brief or accidental usage.

Does using a feature once count as using the option?

Yes. Oracle generally treats any activation as usage. A single AWR report or one partitioned table can flag a chargeable option as used.

Should I send the raw script output to Oracle?

No. Provide a reconciled position with context instead. Raw output invites the highest interpretation of every line and removes your chance to explain accidental usage.

Can options findings be remediated?

Often yes. Disable the unused option, stop the activity at the source, and document the date. Later collections then show the option as no longer in use.

How much can expert review reduce a finding?

In our reviews, context and remediation commonly reduced raw exposure by 25 to 50 percent, depending on how much of the usage was accidental and how clean the contract terms were.

When should I get help with script output?

Before responding to a formal measurement request. The interpretation of the data, not its collection, determines the cost, so independent review pays off at that stage.

Oracle ULA Decision Framework

The full oracle ula decision framework framework from the Oracle Practice.

Oracle ULA exit moves, Java audit defense posture, certification framework, and the buyer side moves across the Oracle Database, Java, middleware, and EBS estate.

Used across more than five hundred enterprise engagements. Independent. Buyer side. Built for procurement leaders running the next renewal cycle.

No spam. We will only email you about this download. Privacy.
Run the software spend health check on your Oracle estate in under five minutes.
Open the Tool →
30-60%
From accidental options
25-50%
Cut by expert review
8-12wk
Self collection runway
1
View that drives findings
100%
Buyer Side

The standard advice is to wait for Oracle to run the scripts and then respond. We disagree. In the measurement reviews we have run, the teams that collected and read the output first cut their exposure by a quarter to a half. The buyer side move is to never let the auditor read your data before you do.

Fredrik Filipsson
Co Founder and Group CEO. Ex Oracle, IBM, SAP.
Deep Library

More on this topic.

Oracle Practice →
Database query output on a screen
Oracle
Oracle LMS Audit Script Analysis
How the LMS scripts work, what they read, and how to analyze the results.
11 min read
Analyst reviewing data tables
Oracle
Interpreting LMS Script Output
A SAM manager guide to reading and reconciling Oracle script results.
12 min read
Compliance review meeting
Oracle
What Triggers an Oracle LMS Audit
The events and signals that invite an Oracle measurement request.
9 min read
Editorial boardroom interior

The advisor your vendors do not want.

500+ enterprise clients. 11 vendor practices. Industry recognized. One conversation can change what you pay for the next three years.

Oracle brief. Once a week.

One short note on Oracle licensing moves, audit posture, partitioning policy, and the buyer side levers we are running in client engagements. No noise.