select username,count(username) from v$session where username is not null group byusername2、缺省从 v$session 中不能直接获得客户端 IP,可以在数据库中创建一个追踪客户端 IP地址的触发器:create or replace trigger on_logon_trigger after logon on databasebegindbms_application_info.set_client_info(sys_context('userenv', 'ip_address'));end;/3、比较常用的显示客户端信息的sql:select sid,serial#,username,program,machine,client_infofrom v$sessionwhere username is not nullorder by username,program,machine;显示结果:1 102 2986 AMS_TEST JDBC Thin Client MICROSO-V22G1JA 192.168.0.922 375 10078 AMS_TEST JDBC Thin Client MICROSO-V22G1JA 192.168.0.923 858 1751 AMS_TEST JDBC Thin Client MICROSO-V22G1JA 192.168.0.924 761 5406 AMS_TEST JDBC Thin Client MICROSO-V22G1JA 192.168.0.925 803 3590 AMS_TEST JDBC Thin Client MICROSO-V22G1JA 192.168.0.926 448 2525 AMS_TEST JDBC Thin Client MICROSO-V22G1JA 192.168.0.927 654 10009 HDCZOA JDBC Thin Client WWW-18843A7DA64 192.168.0.1158 659 9547 HDCZOA JDBC Thin Client WWW-18843A7DA64 192.168.0.1159 664 7554 HDCZOA JDBC Thin Client WWW-18843A7DA64 192.168.0.11510 693 6960 HDCZOA JDBC Thin Client WWW-18843A7DA64 192.168.0.11511 714 3672 HDCZOA JDBC Thin Client WWW-18843A7DA64 192.168.0.11512 724 13457 HDCZOA JDBC Thin Client WWW-18843A7DA64 192.168.0.1154、查看当前Oracle 的连接数select count(*) from v$process;5、查看数据库允许的最大连接数select value from v$parameter where name='processes';6、修改最大连接数
取消
评论