set line 999
select event,count(*) from gv$session where wait_class<>'Idle' group by event order by 2;
select event,count(*) from gv$session where wait_class<>'Idle' group by event order by 2;
select inst_id,username,event,count(*) from gv$session where wait_class<>'Idle' group by inst_id,username,event order by 4;
select inst_id,sid,username,event,count(*) from gv$session where wait_class<>'Idle' group by inst_id,sid,username,event order by 4;
alter system set commit_logging='BATCH';