Scops Docs
Docs Download

Multi-SQL

Run one SQL statement or PL/SQL block on the databases that you select, and compare the answers in one table.

Tools › Multi-SQL, with a query on ten production databases: nine answered and one failed
Values that differ from the rest are bold.

Before you begin

  • You need Run scripts.
  • The monitoring account only reads. A change needs a stored credential with the grants for it.
  • Multi-SQL does not refuse Diagnostics or Tuning Pack views. Your Oracle licenses must cover what you read.

Run a statement

  1. Open Tools › Multi-SQL and select the databases. The search box and the filters select nothing.

  2. Write one statement or one PL/SQL block.

  3. Under As, keep Own account, or select a credential.

  4. Click Run on n, or press Ctrl+Enter.

  5. Check the statement, the account and the databases in the confirmation. Click Run on n.

The confirmation Run on 4 databases?, with the statement, the account and the databases by environment
Every run asks first, also a SELECT.

Scops runs the statement on one database after the other, and logs the run in the Multi-SQL category of Logs.

Selected databases that the filters hide also run. Scops commits a change on each database, and a failure does not undo the others.

Read the results

You ranWhat you see
A queryOne table, with Database first. A value that differs from most rows is bold. Filter keeps the rows that contain your text.
Another statementDone lists each database with its time, or the rows changed.
An ALTER SYSTEM statement done on 4 databases, with the time of each

Export the results

  1. Run a query.

  2. Click the download button above the table.

The Excel file has all rows, also the rows that Filter hides.

Group the results by a column

The results grouped by VERSION_FULL, with 19.24 on 5 databases opened

  1. After a query, select a column under Group by. Scops counts the databases for each value.

  2. Click a value to see its rows.

Run again on the failed databases

  1. Click the failure line, such as 1 failed · ORA-12170 on 1, to see each error.

  2. Correct the cause.

  3. Click the select button at the end of the error, then Run on n.

Limits

LimitWhat happens
One statementScops refuses two or more. Put them in one PL/SQL block. A ; at the end, or a / on the last line, is correct.
5,000 rowsBy default, when a query reaches 5,000 rows in total, the next databases do not run.
Time10 seconds to connect, 10 minutes for a statement.
SessionParallel query, DML and DDL are off. Dates are DD-MM-YYYY HH24:MI:SS. The module is SCOPS.
ReportsRun a saved query on many databases. Database user privilegesWhat the monitoring account can do.

Updated October 31, 2026