User Tools

Site Tools


concurrentstatistics

This is an old revision of the document!


Concurrent Statistics

Utilises three components

  • Scheduler
  • Advanced Queueing
  • Resource Manager

The maximum number of concurrent jobs depends on the value of JOB_QUEUE_PROCESSES parameter.

Enabling

  • JOB_QUEUE_PROCESSES parameter must be set to at least 4
  • Resource Manager must be enabled
  • CONCURRENT preference of the DBMS_STATS.SET_GLOBAL_PREFS must be MANUAL, AUTOMATIC or ALL
concurrentstatistics.1440491335.txt.gz · Last modified: 2025/03/08 22:23 (external edit)