shr1.sql for MTS or Shared server configuration

set lines 120 pages 200

select status, count(1) from v$shared_server group by status;

select * from v$shared_server_monitor;

select dispatcher, count(1) from v$circuit group by dispatcher;

select * from v$sgastat where name like ‘%free memory%’;