1、查看各帐户的连接总数
select username,count(username) from v$session where username is not null group by username
缺省从 v$session 中不能直接获得客户端 IP,可以在数据库中创建一个追踪客户端IP地址的触发器:
- create or replace trigger on_logon_trigger after logon on database
- begin
- dbms_application_info.set_client_info(sys_context('userenv', 'ip_address'));
- end;
- /
2、查看当前Oracle的连接数
select count(*) from v$process;
3、V$sqltext
添加新评论0 条评论