共有サーバ　共有サーバの情報を表示する

set heading off;
pro+----+-----------+----------------+---------+-------+;
pro|name|   requests|status          |     busy|busy(%)|;
pro+----+-----------+----------------+---------+-------+;
select
       '|'||rpad(name,4)||
       '|'||lpad(requests,11)||
       '|'||rpad(status,16)||
       '|'||lpad(busy,9)||
       '|'||lpad(to_char(busy*100/(busy+idle), '990.0'),7)||
       '|'
from v$shared_server
where status != 'QUIT';
pro+----+-----------+----------------+---------+-------+;