oracle查询链接占用数
select b.MACHINE, b.PROGRAM, b.USERNAME, count() from v\(process a, v\)session b
where a.ADDR = b.PADDR and b.USERNAME is not null
group by b.MACHINE, b.PROGRAM, b.USERNAME
order by count() desc
select b.MACHINE, b.PROGRAM, b.USERNAME, count() from v\(process a, v\)session b
where a.ADDR = b.PADDR and b.USERNAME is not null
group by b.MACHINE, b.PROGRAM, b.USERNAME
order by count() desc