当前连接情况

SQL> select state,curr_sch,CLNT_IP,count(1) from v$sessions group by state,CLNT_IP,curr_sch;

LINEID     STATE  CURR_SCH CLNT_IP              COUNT(1)
---------- ------ -------- -------------------- --------------------
1          IDLE   HIDC     ::ffff:10.132.*   5
2          IDLE   HIDC     ::ffff:10.132.* 46
3          IDLE   HIDC     ::ffff:10.132* 43
4          IDLE   HIDC     ::ffff:10.132*  57
5          IDLE   HIDC     ::ffff:10.132*  76
6          ACTIVE HIDC     ::ffff:10.132.9.238  3
7          ACTIVE HIDC     ::ffff:10.132.9.239  1
8          ACTIVE HIDC     ::ffff:10.132.9.237  1
9          ACTIVE HIDC     ::ffff:10.132.9.240  1
10         IDLE   HIDC     ::ffff:127.0.0.1     1
11         ACTIVE SYSDBA   ::1                  1

11 rows got
2.历史慢SQL查询

select top 20 sql_text,EXEC_TIME,finish_time from v$long_exec_sqls order by finish_time desc;

3.正在执行SQL

select SESS_ID,datediff(ss,last_recv_time,sysdate) as last_time,dbms_lob.substr(sf_get_session_sql(sess_id)),sql_text from v$sessions where state='ACTIVE' order by 2;