set pagesize 30000
select inst_id,count(1) from gv$session group by inst_id order by inst_id;
select inst_id,username,count(1) from gv$session where username like upper('&1') group by inst_id,username order by inst_id,username;
select inst_id,username,count(1) from gv$session where username like upper('&1') group by username,inst_id order by username,inst_id;