1
          
          
            、查詢(xún)oracle的連接數(shù)


          
          
            select
          
          
            count
          
          (
          
            *
          
          ) 
          
            from
          
          
             v$session;


          
          
            2
          
          
            、查詢(xún)oracle的并發(fā)連接數(shù)


          
          
            select
          
          
            count
          
          (
          
            *
          
          ) 
          
            from
          
           v$session 
          
            where
          
           status
          
            =
          
          
            '
          
          
            ACTIVE
          
          
            '
          
          
            ;


          
          
            3
          
          
            、查看不同用戶(hù)的連接數(shù)


          
          
            select
          
           username,
          
            count
          
          (username) 
          
            from
          
           v$session 
          
            where
          
           username 
          
            is
          
          
            not
          
          
            null
          
          
            group
          
          
            by
          
          
             username;


          
          
            4
          
          
            、查看所有用戶(hù)：


          
          
            select
          
          
            *
          
          
            from
          
          
             all_users;


          
          
            5
          
          
            、查看用戶(hù)或角色系統(tǒng)權(quán)限(直接賦值給用戶(hù)或角色的系統(tǒng)權(quán)限)：


          
          
            select
          
          
            *
          
          
            from
          
          
             dba_sys_privs;


          
          
            select
          
          
            *
          
          
            from
          
          
             user_sys_privs;


          
          
            6
          
          
            、查看角色(只能查看登陸用戶(hù)擁有的角色)所包含的權(quán)限


          
          
            select
          
          
            *
          
          
            from
          
          
             role_sys_privs;


          
          
            7
          
          
            、查看用戶(hù)對(duì)象權(quán)限：


          
          
            select
          
          
            *
          
          
            from
          
          
             dba_tab_privs;


          
          
            select
          
          
            *
          
          
            from
          
          
             all_tab_privs;


          
          
            select
          
          
            *
          
          
            from
          
          
             user_tab_privs;


          
          
            8
          
          
            、查看所有角色：


          
          
            select
          
          
            *
          
          
            from
          
          
             dba_roles;


          
          
            9
          
          
            、查看用戶(hù)或角色所擁有的角色：


          
          
            select
          
          
            *
          
          
            from
          
          
             dba_role_privs;


          
          
            select
          
          
            *
          
          
            from
          
          
             user_role_privs;


          
          
            10
          
          
            、查看哪些用戶(hù)有sysdba或sysoper系統(tǒng)權(quán)限(查詢(xún)時(shí)需要相應(yīng)權(quán)限)


          
          
            select
          
          
            *
          
          
            from
          
           V$PWFILE_USERS;