create table session_num( num number(6), username varchar2(30), machine varchar2(30), reportdate date ) pctfree 1 pctused 99 tablespace users.
create public synonym session_num for sys.session_num.
2.写一个存储过程0select_sessionnum.sql
create or replace procedure 0select_sessionnum is begin insert into session_num(num,username,machine,reportdate) 0select count(*),username,machine,sysdate from v$session where username is not null group by username,machine. commit. exception when others then rollback. raise. end. /
set pagesize 1000. set linesize 100. column username format a15. column machine format a30. 0select * from session_num where num>50. 0select * from v$license.