Release notes

Each Scops release, with what is new, what is better and what is fixed. The newest release is first.

Scops 2.4.2

Latest release 10 November 2026

New

• Ask AI answers more questions about the schema and the accounts: the tables that reference a table, the compile error of an invalid object, the scheduler jobs that are disabled, and all roles and privileges of one account.
• Radar shows an instance restart, a parameter change, a backup of an unusual size and a key metric at a record hour.
• Ask AI can read the dictionary and performance views of a monitored database with a query of its own, when no built-in reading has the answer. The query is read-only, and Scops stops it if it is too large. It never reads an application table, and never a Diagnostics Pack or Tuning Pack view. A switch of its own in Settings > AI sets it on or off. See Ask Scops AI.
• The grant script has a second form, Individual Grants: one GRANT for each view, for a site that does not give the catalog role. See Database user privileges.

Improved

• A SQL analysis in Ask AI gives a rewritten statement that returns the same rows as the original, and the index that fits the filter and the sort of the statement.
• Ask AI connects a plan change to the change made shortly before it, for example an index made invisible, and gives the statement that reverses it.
• Ask AI names each statement with its SQL_ID, its module and its user.
• The incident report of Ask AI is faster on a data warehouse that makes thousands of changes in one night. A question about tonight needs only the start time.
• The session activity of an Active Data Guard standby that is open read-only shows on the Dashboard.
• Radar compares each reading with three usual levels of the database: the same 5 minutes, most days at that time, and the same weekday. See Radar detectors.
• Radar sends a mail for Critical findings by default. A Warning shows on Databases › Issues.

Scops 2.4.0

9 November 2026

New

• The repository can be PostgreSQL. Setup can install PostgreSQL 18.6 with Scops, with no download, also on a server with no internet access. Or use your own PostgreSQL 17 or later. Oracle 12.2 or later is still a choice. See Choose the repository database.
• Settings › Health shows the health of the repository: its writes, response, space, sessions and CPU. Scops mails a critical alert once to the admin address. See Health.
• In Radar Settings, Exclusions shows each pattern on its own line, with what it hides and what it hid in the last 30 days. You add or remove one pattern at a time.

Improved

• Incidents, Radar history and the SQL search show the times on the clock of the database.
• Radar gives SQL alerts to the pluggable database (PDB) that runs the SQL, not to its container root. The root gets the alerts for the instance: CPU, load, waits, memory, ASM and backups.
• Radar's load and wait alerts follow two clear rules: a load three times its usual for the hour, for ten minutes, and sessions that wait for each other (locks, commits, configuration) reaching a quarter of all active sessions.
• On Databases, the Issues list shows the warnings and critical alerts of Radar.
• The usual band of an hourly or daily bar comes from the same hours and days in the past.
• Fields and buttons have one shape and one height. On Databases, the Issues count is red for critical issues and amber for warnings.

Scops 2.3.11

5 November 2026

New

• The Databases list puts first the databases that need a look now: a database that cannot be reached or takes no new sessions, work that has stopped, a stuck archiver, processes or sessions at their limit, sessions blocked by a lock, an unusual wait wave, a RAC instance that is down, a load far over its usual, or a critical error in the alert log. Amber marks what to look at soon.

Improved

• Radar checks each database every 5 minutes.
• Radar keeps each alert on the charts and in its list for a month, at the highest level the alert reached.

Scops 2.3.10

2 November 2026

Improved

• On the Dashboard, the chart by Service, Instance or PDB shows a thin line between the bands.
• Exadata, Health Check and Summary show a good state with a small mark in the main color.

Scops 2.3.9

2 July 2026

Improved

• PDB Breakdown on Metrics opens faster and shows the same bars as the total: hourly for 1D, 4-hour for 1W.
• On Metrics, NOW, AVG, MAX and MIN show the combined value in every view, also with PDB Breakdown or Per Instance on.
• Scops AI answers about the growth of ASM disk groups.
• Health Check reads the backups of a pluggable database with less load on the database.

Scops 2.3.8

27 February 2026

New

• Scops AI. Ask about any database in plain words, through a model that you select. Before a call leaves the server, Scops masks your names and values. See Privacy and data masking.
• AI Trace and AI Knowledge. See each question that Scops AI answered, and give it your runbooks and notes.
• Docs inside Scops. Docs in the top bar opens these docs. The help button beside a page title opens the part about that page. See Help on a page.
• Jobs by database. Settings › Jobs shows what each job does on each database, and what needs you. Job Settings sets all jobs in one panel. See Jobs.
• Force Recompress. Compression can move listed objects again: to decompress, to go to a lower level, or to rewrite segments that DML left partly uncompressed. See Force Recompress.
• More than one physical standby. You can add two or more physical standbys of the same primary.

Improved

• Scops AI prepares a change card when you ask for a change. Nothing changes until you press the button on the card.
• Each job keeps its schedule on every database, also when one database is slow.
• Archiving, Compression and Statistics work on up to 256 databases at once.
• A change to At once applies from the next run: a copy, a move or a gather that runs goes on, with no restart.
• Health Check, Backup: the backups of the database itself show first. Open a run to see its RMAN output.
• The panel of a database on Databases shows the Data Guard members next to the nodes.
• Automatic datafiles also grows a bigfile tablespace that has autoextend on. Scops raises its MAXSIZE.
• Add Database recognizes Oracle Database 26ai.

Fixed

• A grid went back to its first page when its data refreshed.

Scops 2.3.1 to 2.3.7

Scops 2.3.0

19 June 2023

New

• Memory. How the SGA and PGA of a database are sized and how they behave. The Live tab shows the instance as an animated diagram.
• Services. Which database service carries the load, and how one service behaves on each instance.
• Objects. The tables, views, indexes and code of the application schemas, with the statement that repairs an invalid object.
• Overview. The last 30 days of a database: load, growth, availability and backups.
• Causes in Radar. For a finding about load, waits or statements, Radar shows what added the extra time and what changed. See Causes.

Improved

• Health Check opens with a verdict and four cards: Tablespaces, ASM, Backup and Standby.
• Metrics: each chart shows the normal of the metric for those hours.
• Summary has two tabs, Overview and Inventory.

Scops 2.2.0

16 February 2023

New

• Archiving. Copy old rows from a production database into an archive database. If you choose, Scops deletes the rows from the source in the same transaction.
• Automatic plan fix. The SQL Plan Change alert can set a slow statement back to its best recent plan, with a SQL profile.
• Exadata. The storage cells under a database: capacity, disks and flash cards, load, temperature and alerts.

Improved

• SQL details: Set SQL Plan and SQL Tuning Advisor are on the sheet of the statement.
• Multi-SQL can group the results by a column, for example by version.

Scops 2.1.0

14 October 2022

New

• Compression. Move the tables, partitions, indexes and LOBs that you choose to a compression level, inside the window of each database.
• Automatic datafiles. The Tablespace Usage alert can add a datafile on ASM within a daily limit.

Improved

• Statistics has profiles, so different tables can use different gather settings.

Scops 2.0.0

14 June 2022

New

• Radar Engine. Detectors that report problems that occur now, such as a blocking chain, and problems that will occur, such as a full tablespace.
• Incidents. The alerts and the Radar findings on one page, the worst and newest first.
• Weekly performance report. One mail for each database every week, with its health and eight daily charts.

Improved

• A new interface. The top bar is on the pages for all databases, and the database bar is on the pages of one database.
• Migrations shows each change to the repository schema after an upgrade.

Scops 1.6

February 2022 to May 2022

Improved

• Import and export moves database definitions to another Scops server.
• Maintenance mode in Settings › About keeps users out during maintenance.

Scops 1.5

October 2021 to January 2022

New

• Statistics. Scops finds stale and missing optimizer statistics every hour, and gathers them inside the window of each database.
• Summary. All your databases in numbers: count, size, load, backups and growth.
• License. The Oracle packs and options that your databases report as used.

Scops 1.4

June 2021 to September 2021

New

• Reports. Write a query once, run it on many databases and mail the results on a schedule.
• Multi-SQL. Run one statement on the databases that you select.

Improved

• Multi-Activity shows up to six databases next to each other.
• Scops can send alerts to your incident system as traps.

Scops 1.3

February 2021 to May 2021

New

• Insights. A day or a week of one database: the users, services and modules that kept it busy, and the statements that need attention.
• Sizing. Where the space of a database is, and which segments grew.

Scops 1.2

October 2020 to January 2021

New

• Health Check. Tablespaces, ASM, backups and the standby of one database on one page.
• Metrics. The database's metrics over time.
• RAC and pluggable databases.

Scops 1.1

June 2020 to September 2020

New

• Alert policies and alert rules, with mail.
• SQL details.
• Users, roles and LDAP sign-in.

Scops 1.0.0

February 2020

The first release of Scops.

• Databases, Dashboard and Live Activity for Oracle Database 12.2 and later.

Upgrade

To upgrade an installation to the newest release, see Install Scops. Setup keeps your settings.

Updated November 10, 2026