8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: dispatchers.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- 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