weiranjie
===========================================================
解决最大连接数得问题
===========================================================
解决最大连接数得问题

查询出哪个程序占用得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

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

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

weiranjie 发表于:2008.02.18 11:20 ::分类: ( oracle 技术 ) ::阅读:(581次) :: 评论 (25)
Simply Perfectly, Buy Viagra, >:-), Order Viagra, 0525, Buy Viagra, onf, Buy Viagra, :-O, Order Viagra, 4564, [回复]

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

Viagra 评论于: 2009.07.04 10:05
Good Job, Viagra, :DD, Buy Viagra, rlphal, Buy Viagra, 11522, Buy Viagra, vjk, Order Viagra, 872989, [回复]

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

Buy Viagra 评论于: 2009.07.04 10:51
Pigment red [回复]

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

Pigment red 评论于: 2009.07.04 11:05
polo t shirts [回复]

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

polo t shirts 评论于: 2009.07.04 11:08
Your Site Is Great, Buy Viagra, =-[[, Viagra, dyjqdv, Buy Viagra, hlp, Order Viagra, :-DD, Buy Viagra, =-(, [回复]

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

Order Viagra 评论于: 2009.07.04 11:37
Hi There, Order Viagra, =-[[[, Buy Viagra, 002067, Order Viagra, %[[, Buy Viagra, =DD, Buy Viagra, 97212, [回复]

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

Buy Viagra 评论于: 2009.07.04 12:23
Coolest Site, Order Viagra, >:-[, Order Viagra, 8-(((, Viagra, =PPP, Viagra, lrltd, Viagra, 159, [回复]

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

Order Viagra 评论于: 2009.07.04 13:09
Respect Work, Viagra, >:[[[, Order Viagra, %(((, Viagra, 087, Buy Viagra, 0969, Viagra, izo, [回复]

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

Viagra 评论于: 2009.07.04 13:55
Hello Everybody, Buy Viagra, >:-]]], Buy Viagra, inhikk, Order Viagra, 3317, Buy Viagra, >:-(((, Buy Viagra, mfcu, Buy Viagra, 571, Viagra, 19071, [回复]

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

Order Viagra 评论于: 2009.07.04 14:26
Interesting Site, Viagra, hxjs, Viagra, namyz, Buy Viagra, jws, Viagra, uqduir, Buy Viagra, :), Buy Viagra, 8]]], Order Viagra, 219, [回复]

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

Viagra 评论于: 2009.07.04 15:12
Hello Everybody, Order Viagra, >:))), Buy Viagra, 87356, Viagra, =-OOO, Viagra, :(((, Viagra, 8-], Viagra, 77326, Buy Viagra, >:[[[, [回复]

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

Buy Viagra 评论于: 2009.07.04 15:59
Hi All, Order Viagra, mhhr, Viagra, %OOO, Viagra, 12634, Order Viagra, nrffup, Order Viagra, jfcaqc, Buy Viagra, >:[, Buy Viagra, 8(((, [回复]

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

Viagra 评论于: 2009.07.04 16:46
Good Work, Buy Viagra, 8))), Buy Viagra, 721453, Buy Viagra, oilc, Viagra, qdj, Viagra, %-P, Viagra, :)), Order Viagra, fyeoj, [回复]

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

Order Viagra 评论于: 2009.07.04 17:32
Good Design, Buy Viagra, 9381, Viagra, iermyi, Order Viagra, dzp, Buy Viagra, bwc, Viagra, =), Buy Viagra, 863939, Viagra, mspyz, [回复]

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

Viagra 评论于: 2009.07.04 18:19
Wonderfull Site, Viagra, 2191, Viagra, awqhp, Viagra, fdzlyv, Viagra, >:(((, Buy Viagra, 511677, Buy Viagra, wtyj, Viagra, ivn, [回复]

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

Viagra 评论于: 2009.07.04 19:06
Coolest Site, Buy Viagra, 425224, Viagra, >:D, Buy Viagra, djdh, Viagra, 8-D, Viagra, 8-)), Viagra, weun, Order Viagra, 131, [回复]

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

Order Viagra 评论于: 2009.07.04 19:53
Wonderfull Site, Buy Viagra, 947, Order Viagra, joc, Order Viagra, ndra, Order Viagra, :-O, Viagra, twkman, Buy Viagra, >:), Viagra, jlbvp, [回复]

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

Viagra 评论于: 2009.07.04 20:39
Beautiful Site, Viagra, 176722, Viagra, =-[[, Order Viagra, ofcd, Order Viagra, 713, Buy Viagra, 797890, Viagra, =OO, Buy Viagra, %((, [回复]

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

Order Viagra 评论于: 2009.07.04 21:26
Nise Site, Order Viagra, =PPP, Buy Viagra, egtx, Order Viagra, 8-[, Buy Viagra, 2851, Order Viagra, =((, Order Viagra, 811887, Buy Viagra, 3014, [回复]

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

Viagra 评论于: 2009.07.04 22:13
Good Job, Buy Viagra, zgzkc, Buy Viagra, 88116, Buy Viagra, 096963, Order Viagra, =-]]], Viagra, stlmx, Viagra, uqohnn, Viagra, aow, [回复]

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

Buy Viagra 评论于: 2009.07.04 23:00
Nise Site, Viagra, jzjvkl, Buy Viagra, >:-OOO, Buy Viagra, cuuz, Buy Viagra, 932230, Buy Viagra, atcm, Buy Viagra, %-((, Buy Viagra, 108975, [回复]

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

Viagra 评论于: 2009.07.04 23:46
Good Work, Viagra, 443, Viagra, 4417, Buy Viagra, =DDD, Order Viagra, 61786, Buy Viagra, 68182, Viagra, %), Buy Viagra, hwoae, [回复]

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

Viagra 评论于: 2009.07.05 00:33
Thanks Site, Viagra, 948784, Viagra, :-[[, Buy Viagra, :-PP, Order Viagra, >:PPP, Viagra, 913753, Buy Viagra, mjgiil, Order Viagra, kvn, [回复]

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

Buy Viagra 评论于: 2009.07.05 02:07
Interesting Site, Viagra, 718193, Viagra, lhuerp, Viagra, 1444, Buy Viagra, 8-PP, Viagra, 467343, Buy Viagra, >:PP, Buy Viagra, 51048, [回复]

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

Viagra 评论于: 2009.07.05 02:54
Congratulations, Buy Viagra, 8))), Buy Viagra, 283753, Buy Viagra, yrlgl, Viagra, 28521, Order Viagra, cbt, Viagra, >:-]], Viagra, 74386, [回复]

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

Order Viagra 评论于: 2009.07.05 03:40

发表评论
标题

在此添加评论
表情符号: smile laughing tongue angry crying sad wassat wink

称呼

邮箱地址(可选)

个人主页(可选)




切换风格
新闻聚合
博客日历
文章归档...
最新发表...
博客统计...
网站链接...