【资料名称】：诺西常用数据语音无线指标脚本

【资料作者】：12345

【资料日期】：2012

【资料语言】：中文

【资料格式】：DOC

【资料目录和简介】：

select a.datetime,
-- 掉话率超过3%
sum(case when decode(tchdn,0,0,tchdc/tchdn*100)>3 then 1 else 0 end) tchdc,
-- 接入成功率低于95%
sum(case when decode((rachreq1+rachreq2)*sdblden*tchblden,0,0,(100-100*rachblk/(rachreq1+rachreq2))*(1-sdblnom/sdblden)*(1-tchblnom/tchblden))<95 then 1 else 0 end) accpct,
-- GPRS（含EGPRS）的TBF拥塞率超过2%
sum(case when decode(blkdenom,0,0,blknom/blkdenom*100)>2 then 1 else 0 end) tbfblock,
-- 下行>2 TBF/TSL
sum(case when decode(tbf38cden,0,0,tbf38cnom/tbf38cden/100)>2 then 1 else 0 end) tslblock,
-- 下行>4 TBF/TSL
sum(case when decode(tbf38cden,0,0,tbf38cnom/tbf38cden/100)>4 then 1 else 0 end) tslbad,
-- 话音拥塞小区: 话音拥塞率大于3%
sum(case when decode(tchblden,0,0,(tchblnom*100/tchblden))>3 then 1 else 0 End) tchblock,
-- 数据拥塞小区: GPRS（含EGPRS）的TBF拥塞率超过2% or 下行>2 TBF/TSL小区数量
sum(case when decode(tbf38cden,0,0,tbf38cnom/tbf38cden/100)>2 Or decode(blkdenom,0,0,blknom/blkdenom*100)>2 then 1 else 0 end) datablock,
-- 话音最坏小区: 掉话率超过3% or 接入成功率低于95%
sum(case when decode(tchdn,0,0,tchdc/tchdn*100)>3 or decode((rachreq1+rachreq2)*sdblden*tchblden,0,0,(100-100*rachblk/(rachreq1+rachreq2))*(1-sdblnom/sdblden)*(1-tchblnom/tchblden))<95 then 1 else 0 end) csbad,
-- 数据最坏小区: GPRS（含EGPRS）的TBF拥塞率超过2% or 下行>4 TBF/TSL小区数量
sum(case when decode(tbf38cden,0,0,tbf38cnom/tbf38cden/100)>4 Or decode(blkdenom,0,0,blknom/blkdenom*100)>2 then 1 else 0 end) tbf38cab,