【资料名称】：诺西统计脚本

【资料作者】：--

【资料日期】：--

【资料语言】：中文

【资料格式】：DOC

【资料目录和简介】：

select 地市,START_TIME,BSC_NAME,a.cell_id,a.BCF,bcf_type,SEG_ID,SEG_NAME
,round(tch_traffic,2) TCH话务量
,round(decode(avail_ftch_nbr,0,0,tch_traffic/avail_ftch_nbr),2) 每线话务量
,tch_drop_call"2071掉话次数"
,tch_call_req_nhoTCH请求次数
,tch_seize_nhoTCH占用次数
,f_tch_ass_nhoTCH失败次数
,att_tch_ovrfl_nhoTCH溢出次数
,att_tch_ovrfl"TCH溢出次数(含切)"
,round(decode(tch_call_req_nho,0,0,100*att_tch_ovrfl_nho/tch_call_req_nho),2) TCH拥塞率
,round(decode(tch_seize,0,0,100*tch_drop_call/tch_seize),2)"TCH掉话率(含切)"
,round(decode(tch_seize_nho,0,0,100*tch_drop_call/tch_seize_nho),2) "TCH掉话率(不含切)"
,drop_call_sdcchSD掉话次数
,T3101T3101超时
,round(decode((sdcch_seiz-SDCCH_ACT_FAIL_CALL),0,0,100*drop_call_sdcch/(sdcch_seiz-SDCCH_ACT_FAIL_CALL)),2) SD掉话率
,att_sdcch_seizSD请求次数
,sdcch_seizSD占用次数
,sdcch_failSD失败次数
,SDCCH_UNSUCC_IMM_ASSIGN_ATTSD溢出次数
,round(decode(att_sdcch_seiz,0,0,100*SDCCH_UNSUCC_IMM_ASSIGN_ATT/att_sdcch_seiz),2) SD拥塞率
,LU_ATT位置更新请求
,LU_FAIL位置更新失败
,round(decode(att_sdcch_seiz*tch_call_req_nho,0,0,100*tch_seize_nho*sdcch_seiz/(att_sdcch_seiz*tch_call_req_nho)),2) 无线接入性
,round(decode(ho_req,0,0,100*s_ho/ho_req),2) 切换成功率
,ho_req切换请求
,s_ho 切换成功
,ho_req-s_ho切换失败
,ho_drop 切换失败掉话
,att_o_ho切出尝试
,f_o_ho_interbsc+f_o_ho_intrabsc切出失败
,att_i_ho 切入尝试
,f_i_ho_interbsc+f_i_ho_intrabsc切入失败
,f_ho_intracell小区内失败
,req_ho_intracell小区内请求
,td_req"3G切入请求"
,td_suc"3G切入成功"
,round(decode((ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5),0,0,100*ave_idle_f_tch_2/(ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5)),2) "2级干扰比例"
,round(decode((ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5),0,0,100*ave_idle_f_tch_3/(ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5)),2) "3级干扰比例"
,round(decode((ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5),0,0,100*ave_idle_f_tch_4/(ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5)),2) "4级干扰比例"
,round(decode((ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5),0,0,100*ave_idle_f_tch_5/(ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5)),2) "5级干扰比例"
,ave_idle_f_tch_1+ave_idle_f_tch_2+ave_idle_f_tch_3+ave_idle_f_tch_4+ave_idle_f_tch_5干扰采样时隙
,decode(tch_nbr,0,0,100*avail_ftch_nbr/tch_nbr) "TCH可用率"
,round(tch_traffic_f,2)全速率话务量
,round(tch_traffic_h,2)半速率话务量
,round(sdcch_traffic,2)SD话务量
,PEAK_SD
,static_sdcch_nbr 静态SDCCH信道可用数
,dynamic_sdcch_nbr动态SDCCH信道可用数
---------
,round(nvl(ULEGPRSPld,0)+nvl(ULCS34Payload,0)+nvl(GPRS_ULPld,0),2)"上行流量(KByte/h)"
,round(nvl(DLEGPRSPld,0)+nvl(DLCS34Payload,0)+nvl(GPRS_DLPld,0),2)"下行流量(KByte/h)"
,round(nvl(DLCS34Payload,0)+nvl(GPRS_DLPld,0),2)"下行GPRS流量(KByte/h)"
,round(nvl(DLEGPRSPld,0),2)"下行EGPRS流量(KByte/h)"
,UL_TBF_SUCCESS_RATEas上行TBF成功率
,DL_TBF_SUCCESS_RATEas下行TBF成功率
,EDGE高编码比例
,PDCH分配成功率
,PS_AG溢出
,tbf38c
,tbf38d
,tbf38e
,round(decode(TSL_REQ,0,0,100-100*TSL_ALC/TSL_REQ),2) BLCK_33
,ul时隙分配拒绝率
,dl时隙分配拒绝率
,tbf17上TBF释放MS无响应
,tbf18下TBF释放MS无响应
,UL_PDCH_use UL_PDCH_使用数
,DL_PDCH_use DL_PDCH_使用数
,ava_16a PDCH激活平均数
,peak_GPRS PEAK_GPRS时隙
,U_TBF请求数
,上行TBF建立失败次数
,U_TBF拥塞数
,D_TBF请求数
,下行TBF建立失败次数
,D_TBF拥塞数
,csw_pdch TCH争夺PDCH次数
,gprs_upgrade_rej_total GPRS域升级拒绝
,gprs_upgrade_rej_csw"GPRS域升级拒绝(语音)"
,gprs_upgrade_rej_psw"GPRS域升级拒绝(数据)"
,gprs_upgrade_rej_pcu"GPRS域升级拒绝(PCU)"
,上行TBF平均持续时长
,下行TBF平均持续时长
,EGPRS_TBFS_UL
,EGPRS_TBFS_DL
,上行TBF异常中断次数
,下行TBF异常中断次数

---------
from
------------------------------------------------------------------------ a ---------------------------------------------------------
(