20120729数据库连接池满 pool is full

问题描述：dealerweb创建酬金申请失败，报错pool is full

解决办法：用以下方法查询出原因，kill掉锁表的session，其他session正常结束，连接池释放

 

--查询某个用户有多少个连接池
select logon_time, last_call_et, username, status, t2.SQL_TEXT
  from V$session t1
  left join v$sql t2 on t1.PREV_SQL_ID = t2.SQL_ID
 where username = 'YY0A'  AND status='ACTIVE'　
 order by username, logon_time, last_call_et;

--检查哪些被锁
select * from v$locked_object c;--89617
--查询被锁对象名
select * from dba_objects a where a.object_id=89617;--CH_INFO_COMMISSION_REQUEST
--查询session
select *
  from v$session b
 where b.SID in ('2316', '2318', '2322', '2352', '2372', '2406', '2454',
        '2482', '2483', '2493', '2493', '2515', '2534', '2556',
        '2564', '2621',