可以看到连接到数据库的机器名为perass:

PROCESS 1234表示是JDBC的进程

查询SQL:

select username,

        machine,

        status,

        prev_sql_addr,

        prev_hash_value,

        prev_sql_id,

        process,

        count(*)

        from v$session

        group by

         username,

        machine,

        status,

        prev_sql_addr,

        prev_hash_value,

        prev_sql_id,

        process

        order by count(*) desc