Oracle Dispatcher Statistics Report

This script displays Oracle dispatcher statistics used in shared server configurations. It queries the V$DISPATCHER view to show dispatcher status, message and byte counts, circuit ownership, idle/busy time, and calculated load, helping monitor dispatcher performance and workload.

oraclesqlmonitoring-alertsv1.0.0

0 stars0 downloads12 views0 comments

By OracleDba • Created 2/23/2026

Code

(26 lines)

-- -----------------------------------------------------------------------------------
-- File Name    : https://oracle-base.com/dba/monitoring/dispatchers.sql
-- Author       : Tim Hall
-- Description  : Displays dispatcher statistics.
-- Requirements : Access to the v$ views.
-- Call Syntax  : @dispatchers
-- Last Modified: 15/07/2000
-- -----------------------------------------------------------------------------------
SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF

SELECT a.name "Name",
       a.status "Status",
       a.accept "Accept",
       a.messages "Total Mesgs",
       a.bytes "Total Bytes",
       a.owned "Circs Owned",
       a.idle "Total Idle Time",
       a.busy "Total Busy Time",
       Round(a.busy/(a.busy + a.idle),2) "Load"
FROM   v$dispatcher a
ORDER BY 1;

SET PAGESIZE 14
SET VERIFY ON

Oracle Dispatcher Statistics Report

Code

General Comments(0)