q_sess_summary

admin

1. BREAK on report
   
2. COMPUTE sum OF num_user_sess count_a count_i ON report
   
3. 
   
4. SELECT
   
5.     lpad(nvl(sess.username, '[B.G. Process]'), 15) username
   
6.   , count(*) num_user_sess
   
7.   , nvl(act.count, 0)   count_a
   
8.   , nvl(inact.count, 0) count_i
   
9. FROM
   
10.     v$session sess
    
11.   , (SELECT    count(*) count, nvl(username, '[B.G. Process]') username
    
12.      FROM      v$session
    
13.      WHERE     status = 'ACTIVE'
    
14.      GROUP BY  username)   act
    
15.   , (SELECT    count(*) count, nvl(username, '[B.G. Process]') username
    
16.      FROM      v$session
    
17.      WHERE     status = 'INACTIVE'
    
18.      GROUP BY  username) inact
    
19. WHERE
    
20.          nvl(sess.username, '[B.G. Process]') = act.username (+)
    
21.      and nvl(sess.username, '[B.G. Process]') = inact.username (+)
    
22. GROUP BY
    
23.     sess.username
    
24.   , act.count
    
25.   , inact.count
    
26. /

复制代码