Resources

Articles

Looking for one error? Oracle problems covers more than forty of them, from ORA-01653 and ORA-00257 to blocking sessions, ORA-04031, ORA-01555 and a plan that changed, each with the query to run and the fix in order.

• Oracle MCP Server vs Scops AI: Raw SQL or 40+ DBA Tools
  Oracle's MCP servers hand an AI model a SQL connection to your database. Scops AI gives it 40+ read-only DBA tools, masked data and changes only by click.
• Oracle Root Cause Analysis: From the Symptom to the Cause, Fast
  Find the root cause of an Oracle slowdown in five steps: the window, the load, the wait class, the statement, what changed. By hand in SQL, and in Scops.
• Oracle Database Anomaly Detection: How Radar Learns What Is Usual
  Anomaly detection for Oracle: learn the usual level of every hour, weekdays and weekends apart, and flag what is far from it. How Radar Engine does it.
• Average Active Sessions in Oracle: What It Means, How to Read It
  Average active sessions is DB time divided by elapsed time: how many sessions work at once. How to read it against the CPU count, and the waits.
• The Most Capable Oracle Monitoring Platform: Why AI-Driven Monitoring Leaves Traditional Tools Behind
  Where a threshold loses the hour, shown on a real Scops case: two plan changes on SALESPRD, found in minutes and put back with one click.
• Scops vs Enterprise Manager, SolarWinds DPA, Foglight and Datadog: Oracle Monitoring in One Table
  Five products on detection, AI, automation, agents, Oracle packs, Standard Edition 2, price, interface and scope, every competitor cell from its own documentation, every row to Scops.
• Oracle Monitoring Tools Pricing: What Five Tools Really Cost
  Enterprise Manager, SolarWinds DPA, Quest Foglight, Datadog and Scops on one scale, from each vendor's price list, worked through for five and fifty databases over five years.
• A SolarWinds DPA Alternative for Oracle: More Detection, Less to Run, a Public Price
  What DPA needs by its own documentation, a utility package in every instance, a repository database and a quote, against one Windows server, 75+ detectors, Scops AI and a price on the website.
• A Foglight for Oracle Alternative: Less to Run, More Detection
  What Foglight needs by Quest's own deployment guide, a Management Server, a Database Repository, an Agent Manager and a SQL PI Repository, against one Windows server, nothing on the hosts, 75+ detectors, Scops AI and a public price.
• A Datadog Alternative for Oracle: No Agent on the Host, No SaaS
  What Datadog's Oracle integration needs by its own documentation, the Agent on the database host, a user and a view created as SYSDBA, data sent to Datadog's backend and $70 per host a month, against one Windows server inside your network and a price per database.
• The Oracle Diagnostics Pack Cost, and What You Get Without It
  $7,500 per processor and 22% a year, the Tuning Pack on top, a worked example for one server and for five, what the licensing manual puts in the pack, and session history without it.
• Standard Edition 2 Limits: 2 Sockets, 16 Threads, and No Packs
  Every SE2 limit from Oracle's data sheet and licensing manual in one list, the feature table row by row, what each limit means in practice, and how Scops monitors SE2 in full.
• Is AWR Free? Is ASH Licensed? The Answer in Oracle's Own Manual
  What Oracle's licensing manual puts in the Diagnostics Pack and what it leaves free, object by object, the Standard Edition 2 answer, Statspack, and session history without the pack.
• Is Oracle Enterprise Manager Free? The Base, the Packs, the Price
  What the free base installation includes by Oracle's own manual, what moves to the Diagnostics and Tuning Packs, notifications included, the list price per processor, and what the free part costs to run.
• Oracle Diagnostics Pack Usage: How to Check It, How to Stop It
  The switch, the record in DBA_FEATURE_USAGE_STATISTICS, what the licensing manual counts as pack use, the nightly advisor that uses the Tuning Pack by itself, and monitoring without the packs.
• Enterprise Manager 13.5 Support Ends on 31 December 2026
  Oracle's own dates, what the out-of-place upgrade to 24ai and its 19c repository require, what the packs still lock, and the agentless alternative that takes an afternoon.
• Why Scops Is the Best Oracle Monitoring Tool
  No agents, no Oracle packs, Standard Edition 2 in full, 75+ detectors, Scops AI with 40+ tools and automation, checked against the other tools' own documentation.
• The Best Oracle Database Monitoring Tools in 2026: 14 Compared
  What each tool's documentation states on agents, the Diagnostics Pack, Standard Edition 2, session history, detection, AI and price.
• Scops vs Oracle Enterprise Manager
  What each needs to run, what the Diagnostics Pack locks in Enterprise Manager, Standard Edition 2 in each, and why Scops wins.
• The Best AI Assistant for Oracle DBAs
  Three tests a DBA assistant must pass, and how Scops AI, chatbots, Oracle Select AI, the SQLcl MCP server and observability copilots do on them.
• Oracle Standard Edition 2 Monitoring Without the Packs
  What SE2 cannot use, the free views you can still query, a session sampler to build, and how Scops monitors SE2 fully.
• How Scops Archives Old Rows in Oracle Without Downtime
  Why Oracle data archiving ends in fragile scripts, and how Scops moves old rows online in rowid chunks, with copy and delete in one transaction.
• Catching Oracle Problems Before They Become Outages
  How we built 75+ Oracle detectors: what each clock checks, how a finding earns Critical, how noise is cut, and how a finding names its cause.
• What We Learned Giving an AI Agent 40+ Oracle Tools
  How we let an AI agent read Oracle safely with 40+ tools, how we grade it on 200 expert questions against planted incidents, and what the numbers show.
• Oracle Session History Without the Diagnostics Pack
  What the Oracle licensing manual puts in the Diagnostics Pack, what stays outside it, and how to sample V$SESSION into your own history table.