JAVA程序,SESSION没有关闭导致数据库异常

可以看到连接到数据库的机器名为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