Scops Docs
Docs Download

Statistics

Add a database to Statistics, and Scops gathers its stale and missing optimizer statistics with DBMS_STATS inside the window that you set.

The Statistics page on All Databases, with the totals of the day and the list of databases

Before you begin

  • View Statistics opens the page. Manage Statistics changes databases and profiles. Run Statistics starts, stops and gathers.
  • The monitoring account needs the Statistics grants, such as ANALYZE ANY, and ALTER SYSTEM to stop a gather. See Feature grants.
  • Compression and Statistics use one license. A database in both counts once. See When you reach a limit.

Add a database

  1. Open Add-ons › Statistics and click Add Database.

  2. Select the Database.

  3. Set When, the scope and the Profile. See Settings.

    Statistics Settings for ORDERS, with a night window, two schemas in scope and the Default Profile

  4. Click Add. Within a minute, Scops reads the database and fills its queue.

  5. If the badge next to the title shows Stopped, click Start Job.

Set the window

  1. Click the database, then Settings.

  2. Set When to In a window.

  3. Set the Window times, on the clock of the Scops server, and the Days.

  4. Click Save.

A gather starts only inside the window. A gather that runs when the window closes continues to the end.

Change a profile

The profile part of Statistics Settings for LEDGER: partition by partition, incremental, dictionary statistics every week

  1. Click the database, then Settings.

  2. Change the profile settings. Scops shows how many other databases use the profile.

  3. To change only this database, click Save as a New Profile Instead.

  4. Click Save.

The button next to Profile has New Profile, Rename and Delete This Profile. You cannot delete a profile in use.

Gather a table now

The Queue tab of ORDERS with 124 tables waiting in run order, each with a bolt button
To gatherDo this
A table in the queueOn Queue, move the pointer over its row, then click the bolt.
A table or partition not in the queueClick More, then Gather a Table Now.
Oracle's own objectsClick More, then Gather Dictionary Statistics Now or Gather Fixed Objects Statistics Now.

A table that you ask for starts within a minute, also outside the window or while Statistics is stopped. Scops never gathers a table with locked statistics.

Update or empty the queue

The card of LEDGER, with Settings, Stop, Discover and More, the tables gathered per day and four health tiles
  • Scops reads each database every hour. To read it now, click Discover. Discover All reads all databases that are on.
  • To remove all waiting gathers, click More, then Empty the Queue. The next read adds back what is still stale or missing.

Retry failed gathers

The History tab of ERPPRD, with a failed gather opened on its statement and error

  1. Click the database and open History.

  2. Open a Failed row to see the call and the error. Correct the cause.

  3. Click Retry Failed. Scops puts all failed tables at the front of the queue.

A gather that runs for 4 hours stops and fails. Without a retry, a failed table waits 12 hours before the next read queues it again.

Skipped is not a failure: the statistics were locked, or the table was dropped. Scops keeps the history for 90 days.

Stop and start

To stopClickTo start again
All databasesStop JobStart Job
One database and its hourly readStop on the databaseStart

Scops kills the running gathers at once and queues them again. Without ALTER SYSTEM, a gather continues, and the log says so.

Remove a database

Click More on the database, then Remove From Statistics. Scops keeps its history.

Settings

SettingWhat it doesDefault
WhenAny time, or In a window. A window that ends after midnight belongs to the day it starts on.Any time
Only these, Leave outThe scope: SCHEMA or SCHEMA.TABLE. Oracle's own schemas are never in scope.All schemas
ProfileThe settings below.Default Profile
GatherStale and missing, Stale only, Missing only, or Every table, once a day.Stale and missing
SampleAutomatic (recommended), or A fixed percent from 1 to 100.Automatic
HistogramsThe METHOD_OPT: Automatic, Only skewed columns, None, Indexed columns only or Custom.Automatic
Index statisticsGathers the indexes with the table.On
CursorsInvalidated gradually, Never invalidated, or Invalidated at once, which can cause many hard parses.Invalidated gradually
DegreeParallel servers for a table, 0 to 64. 0 lets Oracle select.4
Tables at onceGathers at the same time on the database, 1 to 16.2
Partitioned tables › GatherThe whole table, or Partition by partition and then the Global statistics.The whole table
IncrementalSets INCREMENTAL to TRUE on partitioned tables. The preference stays if you switch it off.Off
Partitioned tables › DegreeParallel servers for a partitioned table.8
Dictionary, Fixed objectsNever, Every week or Every month.Never

At most 256 databases gather at the same time: At once of the Statistics job in Job Settings.

Feature grantsThe grants that Statistics needs. CompressionCompress tables and indexes in a window. Editions and activationThe databases that your key covers.

Updated November 3, 2026