查询出哪个程序占用得session 比较多

select program,count(*) from v$session
group by program
order by count(*) desc

杀掉 过期得session
select 'kill -9 '||b.spid
--,a.sid,a.program,a.LOGON_TIME
from v$session a,v$process b
where a.program ='tb-smbc-d@sd_db (TNS V1-V3)' and a.logon_time < to_date('20080216','yyyymmdd')
and a.paddr = b.addr

解决问题得关键还是从应用，

让开发人员看看为啥连接不释放

Simply Perfectly, Buy Viagra, >:-), Order Viagra, 0525, Buy Viagra, onf, Buy Viagra, :-O, Order Viagra, 4564,

Good Job, Viagra, D, Buy Viagra, rlphal, Buy Viagra, 11522, Buy Viagra, vjk, Order Viagra, 872989,

Pigment red pigment red 112 pigment red 3 Pigment yellow 12 pipe cutter planetary gearbox plastic business card Plastic molding Plastikkarten plate heat exchange

polo t shirts Portable DVD players poster printing posters printing power leveling power leveling power leveling power leveling power leveling power leveling

Your Site Is Great, Buy Viagra, =-[[, Viagra, dyjqdv, Buy Viagra, hlp, Order Viagra, :-DD, Buy Viagra, =-(,

Hi There, Order Viagra, =-[[[, Buy Viagra, 002067, Order Viagra, %[[, Buy Viagra, =DD, Buy Viagra, 97212,

Coolest Site, Order Viagra, >:-[, Order Viagra, 8-(((, Viagra, =PPP, Viagra, lrltd, Viagra, 159,

Respect Work, Viagra, >:[[[, Order Viagra, %(((, Viagra, 087, Buy Viagra, 0969, Viagra, izo,

Hello Everybody, Buy Viagra, >:-]]], Buy Viagra, inhikk, Order Viagra, 3317, Buy Viagra, >:-(((, Buy Viagra, mfcu, Buy Viagra, 571, Viagra, 19071,

Interesting Site, Viagra, hxjs, Viagra, namyz, Buy Viagra, jws, Viagra, uqduir, Buy Viagra, , Buy Viagra, 8]]], Order Viagra, 219,

Hello Everybody, Order Viagra, >)), Buy Viagra, 87356, Viagra, =-OOO, Viagra, ((, Viagra, 8-], Viagra, 77326, Buy Viagra, >:[[[,

Hi All, Order Viagra, mhhr, Viagra, %OOO, Viagra, 12634, Order Viagra, nrffup, Order Viagra, jfcaqc, Buy Viagra, >:[, Buy Viagra, 8(((,

Good Work, Buy Viagra, 8))), Buy Viagra, 721453, Buy Viagra, oilc, Viagra, qdj, Viagra, %-P, Viagra, ), Order Viagra, fyeoj,

Good Design, Buy Viagra, 9381, Viagra, iermyi, Order Viagra, dzp, Buy Viagra, bwc, Viagra, =), Buy Viagra, 863939, Viagra, mspyz,

Wonderfull Site, Viagra, 2191, Viagra, awqhp, Viagra, fdzlyv, Viagra, >((, Buy Viagra, 511677, Buy Viagra, wtyj, Viagra, ivn,

Coolest Site, Buy Viagra, 425224, Viagra, >, Buy Viagra, djdh, Viagra, 8-D, Viagra, 8-)), Viagra, weun, Order Viagra, 131,

Wonderfull Site, Buy Viagra, 947, Order Viagra, joc, Order Viagra, ndra, Order Viagra, :-O, Viagra, twkman, Buy Viagra, >, Viagra, jlbvp,

Beautiful Site, Viagra, 176722, Viagra, =-[[, Order Viagra, ofcd, Order Viagra, 713, Buy Viagra, 797890, Viagra, =OO, Buy Viagra, %((,

Nise Site, Order Viagra, =PPP, Buy Viagra, egtx, Order Viagra, 8-[, Buy Viagra, 2851, Order Viagra, =((, Order Viagra, 811887, Buy Viagra, 3014,

Good Job, Buy Viagra, zgzkc, Buy Viagra, 88116, Buy Viagra, 096963, Order Viagra, =-]]], Viagra, stlmx, Viagra, uqohnn, Viagra, aow,

Nise Site, Viagra, jzjvkl, Buy Viagra, >:-OOO, Buy Viagra, cuuz, Buy Viagra, 932230, Buy Viagra, atcm, Buy Viagra, %-((, Buy Viagra, 108975,

Good Work, Viagra, 443, Viagra, 4417, Buy Viagra, =DDD, Order Viagra, 61786, Buy Viagra, 68182, Viagra, %), Buy Viagra, hwoae,

Thanks Site, Viagra, 948784, Viagra, :-[[, Buy Viagra, :-PP, Order Viagra, >:PPP, Viagra, 913753, Buy Viagra, mjgiil, Order Viagra, kvn,

Interesting Site, Viagra, 718193, Viagra, lhuerp, Viagra, 1444, Buy Viagra, 8-PP, Viagra, 467343, Buy Viagra, >:PP, Buy Viagra, 51048,

Congratulations, Buy Viagra, 8))), Buy Viagra, 283753, Buy Viagra, yrlgl, Viagra, 28521, Order Viagra, cbt, Viagra, >:-]], Viagra, 74386,