Admin: Grafische weergave connectie activiteit

select t.teller
,      sum(decode(sign(teller - trunc(last_call_et/60/60)),'0',1,0)) aantal
,      rpad('*',sum(decode(sign(teller - trunc(last_call_et/60/60)),'0',1,0))/5,'*') leuke_sterretjes
from v$session
,    (select rownum-1 teller
      from dba_objects
      where rownum <= (select trunc(max(last_call_et/60/60))+1
                         from v$session where username is not null)
     ) t
where username is not null
and machine like 'bbapp%'
group by t.teller order by 1,2;

No feedback yet
Comments are closed for this post.
Trackback address for this post
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case insensitive)