【資料名稱】：NSN CELL BSC SQL

【資料作者】：--

【資料日期】：--

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡(jiǎn)介】：

---------------------小區(qū)級(jí)小時(shí)級(jí)指標(biāo) ----------------

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請(qǐng)求次數(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超時(shí)
,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請(qǐng)求次數(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位置更新請(qǐng)求
,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_re