Diagnostics Pack alternative

Session history without the Diagnostics Pack

ASH, AWR and ADDM belong to the Oracle Diagnostics Pack, which needs Enterprise Edition and its own license. Scops collects session history and SQL statistics itself, so you can see what happened without them.

What you get without the pack

Session history: Scops reads sessions every 5 seconds and keeps them in its own repository.
SQL statistics: read every 10 minutes, with the heaviest SQL ranked.
Plan changes: every plan change and every new statement.
Radar Engine: 75+ detectors and forecasts.
Scops AI: ask why a database was slow, on this same data.

Standard Edition 2

Packs need Enterprise Edition, so Standard Edition 2 cannot use ASH or AWR at all. Scops gives it all monitoring, alerts, reports, Scops AI and Statistics. Keep the Diagnostics and Tuning Pack switch off.

A license switch for Oracle's packs

Scops never uses an Oracle pack unless you turn on the switch and confirm the license. The one feature that uses the packs, automatic plan fix with SQL profiles, waits behind it, so a pack is never used by accident.

Your license exposure, visible

The License page shows which packs and options each database has already used, and any new use in the last 90 days, so you see it before an audit does.
It also counts the processor licenses each database needs.

Questions

Does monitoring use ASH or AWR?
No. Monitoring uses the session history and SQL statistics that Scops collects itself.

How far back does the history go?
As your retention policies set in Professional, and 15 days in Community.

Does it replace the pack for monitoring?
Yes. Session history, top SQL, plan changes, metrics and the detectors all come from data Scops collects itself, on every edition. The only Scops feature that uses the packs, automatic plan fix with SQL profiles, sits behind a license switch.

Is it free?
Community is free for up to 2 databases. Professional is $499 per database a year.

Start

Open the live demo, or download Scops. See Supported databases and License.