共有サーバのディスパッチャの状態を表示する

set heading off;
pro+----+--------+--------+---------+;
pro|name|status  | clients| BusyRate|;
pro+----+--------+--------+---------+;
select
       '|'||rpad(name,4)||
       '|'||rpad(status,8)||
       '|'||lpad(sum(owned),8)||
       '|'||lpad(to_char(SUM(busy)*10000/(SUM(busy)+SUM(idle)), '990.0'),9)||
       '|'
from v$dispatcher
group by name,status;
pro+----+--------+--------+---------+;