【資料名稱】：諾西統(tǒng)計腳本

【資料作者】：--

【資料日期】：--

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

select 地市,START_TIME,BSC_NAME,a.cell_id,a.BCF,bcf_type,SEG_ID,SEG_NAME
,round(tch_traffic,2) TCH話務(wù)量
,round(decode(avail_ftch_nbr,0,0,tch_traffic/avail_ftch_nbr),2) 每線話務(wù)量
,tch_drop_call"2071掉話次數(shù)"
,tch_call_req_nhoTCH請求次數(shù)
,tch_seize_nhoTCH占用次數(shù)
,f_tch_ass_nhoTCH失敗次數(shù)
,att_tch_ovrfl_nhoTCH溢出次數(shù)
,att_tch_ovrfl"TCH溢出次數(shù)(含切)"
,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掉話次數(shù)
,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請求次數(shù)
,sdcch_seizSD占用次數(shù)
,sdcch_failSD失敗次數(shù)
,SDCCH_UNSUCC_IMM_ASSIGN_ATTSD溢出次數(shù)
,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小區(qū)內(nèi)失敗
,req_ho_intracell小區(qū)內(nèi)請求
,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)全速率話務(wù)量
,round(tch_traffic_h,2)半速率話務(wù)量
,round(sdcch_traffic,2)SD話務(wù)量
,PEAK_SD
,static_sdcch_nbr 靜態(tài)SDCCH信道可用數(shù)
,dynamic_sdcch_nbr動態(tài)SDCCH信道可用數(shù)
---------
,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無響應(yīng)
,tbf18下TBF釋放MS無響應(yīng)
,UL_PDCH_use UL_PDCH_使用數(shù)
,DL_PDCH_use DL_PDCH_使用數(shù)
,ava_16a PDCH激活平均數(shù)
,peak_GPRS PEAK_GPRS時隙
,U_TBF請求數(shù)
,上行TBF建立失敗次數(shù)
,U_TBF擁塞數(shù)
,D_TBF請求數(shù)
,下行TBF建立失敗次數(shù)
,D_TBF擁塞數(shù)
,csw_pdch TCH爭奪PDCH次數(shù)
,gprs_upgrade_rej_total GPRS域升級拒絕
,gprs_upgrade_rej_csw"GPRS域升級拒絕(語音)"
,gprs_upgrade_rej_psw"GPRS域升級拒絕(數(shù)據(jù))"
,gprs_upgrade_rej_pcu"GPRS域升級拒絕(PCU)"
,上行TBF平均持續(xù)時長
,下行TBF平均持續(xù)時長
,EGPRS_TBFS_UL
,EGPRS_TBFS_DL
,上行TBF異常中斷次數(shù)
,下行TBF異常中斷次數(shù)

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