SQL常用字段及脚本081010

TCH占用及话务 tch_call_req tch_norm_seiz TCH_HO_SEIZ TCH_RE_EST_ASSIGN ave_tch_busy_full ave_tch_busy_half TCH的掉话 CLEAR_REQUEST_BY_BSC_ON_TCH TCH_RF_FAIL TCH_RF_OLD_HO TCH_ABIS_FAIL_CALL TCH_ABIS_FAIL_OLD TCH_A_IF_FAIL_CALL TCH_A_IF_FAIL_OLD
TW_ACT+SDCCH_ABIS_FAIL_CALL+SDCCH_ABIS_FAIL_OLD+SDCCH_BTS_FAIL+SDCCH_LAPD_FAIL+SDCCH_A_IF_FAIL_CALL
+SDCCH_A_IF_FAIL_OLD)/SUM(SDCC
tch))/sum(a.tch_call_req)) from p_nbsc_res_avail p,p_nbsc_traffic a,p_nbsc_ho b
EQ_UL_QUAL0+a.FREQ_UL_QUAL1+a.FREQ_UL_QUAL2+a.FREQ_UL_QUAL3+a.FREQ_UL_QUAL4+a.FREQ_UL_QUAL5+a.FREQ_UL_QUAL6+a.FREQ_UL_QUAL7),0,0,10
,100*sum(a.freq_reports)/b.all_occur) from p_nbsc_timing_advance
质量&电平
质量0~2级比例：decode(sum(a.FREQ_UL_QUAL0+a.FREQ_UL_QUAL1+a.
ຫໍສະໝຸດ Baidu
TA测量
TA比例：decode(b.all_occur,0,0,100*sum(a.freq_reports)/b.all
信道配置
ave_avail_TCH_sum ave_permanent_GPRS_ch_sum AVE_TCH_AVAIL_HALF
H_A_IF_FAIL_OLD)/SUM(SDCCH_ASSIGN+SDCCH_HO_SEIZ)) from p_nbsc_traffic,p_nbsc_service
FAIL_OLD+ A.TCH_A_IF_FAIL_CALL+ A.TCH_A_IF_FAIL_OLD+ A.TCH_TR_FAIL+ A.TCH_TR_FAIL_OLD+ A.TCH_LAPD_FAIL+ A.TCH_BTS_FAIL+ A.TCH_USER_
_SDCCH_CON),0,0,100*SUM(A.TCH_RADIO_FAIL+ A.TCH_RF_OLD_HO+A.TCH_ABIS_FAIL_CALL - B.SPARE002072+ A.TCH_ABIS_FAIL_OLD+ A.TCH_A_IF_FAIL
h_at+ cell_sdcch_tch_at+ cell_sdcch_at),0,0,100*sum(msc_o_tch_tch_at+msc_o_sdcch_tch_at+msc_o_sdcch_at+bsc_o_tch_tch_at+bsc_o_sdcch_
RM_SEIZ+C.MSC_I_SDCCH_TCH+ C.BSC_I_SDCCH_TCH+ C.CELL_SDCCH_TCH- A.TCH_SUCC_SEIZ_FOR_DIR_ACC+A.TCH_SEIZ_DUE_SDCCH_CON),0,0,100*SUM(A
ch_tch_at+msc_o_sdcch_tch_at+msc_o_sdcch_at+bsc_o_tch_tch_at+bsc_o_sdcch_tch_at+bsc_o_sdcch_at+cell_tch_tch_at+ cell_sdcch_tch_at+
TCH_TR_FAIL TCH_TR_FAIL_OLD TCH_LAPD_FAIL TCH_BTS_FAIL TCH_USER_ACT TCH_BCSU_RESET TCH_NETW_ACT TCH_ACT_FAIL_CALL 切换 msc_o_tch_tch_at msc_o_sdcch_tch_at msc_o_sdcch_at bsc_o_tch_tch_at bsc_o_sdcch_tch_at bsc_o_sdcch_at cell_tch_tch_at cell_sdcch_tch_at cell_sdcch_at FREQ_DL_QUAL0 FREQ_DL_QUAL1 FREQ_DL_QUAL2 FREQ_DL_QUAL3 FREQ_DL_QUAL4 FREQ_DL_QUAL5 FREQ_DL_QUAL6 FREQ_DL_QUAL7 class_upper_range freq_reports
TCH信道数 CDED信道数 半速率信道数
TCH可用率：decode(SUM(AVE_AVAIL_TCH_SUM/AVE_AVAIL_TCH_DEN+ A
其他
_PAGING_LOAD_AIR_DEN),0,0,sum(AVE_PAGING_LOAD_AIR_SUM)/sum(AVE_PAGING_LOAD_AIR_DEN)) from p_nbsc_res_access
IGN+SDCCH_HO_SEIZ),0,0,100*SUM(SDCCH_RADIO_FAIL+SDCCH_RF_OLD_HO+SDCCH_USER_ACT+SDCCH_BCSU_RESET
+SDCCH_NETW_ACT+SDCCH_ABIS_FAIL_CA
_denom14,0,0,p.ave_busy_tch/p.res_av_denom14)) h_call_req),0,0,(sum(a.tch_call_req-a.tch_norm_seiz)-sum(b.msc_o_sdcch_tch+b.bsc_o_sdcch_tch+b.cell_sdcch_tch))/sum(a.tch_call_req)
TCH TR失败掉话 TCH TR切换掉话 TCH LAPD失败掉话 TCH BTS失败掉话 TCH 用户操作掉话 TCH BCSU重启掉话 TCH 网络操作掉话 TCH操作掉话
MSC控制的TCH出切换 切换失败率：decode(sum(msc_o_tch_tch_at+msc_o_sdcch_tch_at+m MSC控制的DR MSC控制的SD出切换 BSC控制的TCH出切换 BSC控制的DR BSC控制的SD出切换 小区内切换 小区DR数 小区SD切换 下行质量等级0 下行质量等级1 下行质量等级2 下行质量等级3 下行质量等级4 下行质量等级5 下行质量等级6 下行质量等级7 等级范围 报告次数
相关指标 寻呼
相关字段 PAGING_MSG_SENT PS_PAGING_MSG_SENT CS_PAGING_MSG_SENT DELETE_PAGING_COMMAND AVE_PCH_LOAD PEAK_PCH_LOAD MIN_PAGING_BUF MAX_PAGING_BUFFER_CAPA CH_REQ_MSG_REC IMM_ASSGN_SENT IMM_ASSGN_REJ DEL_IND_MSG_REC SUCC_SEIZ_ORIG SUCC_SEIZ_TERM SDCCH_CALL_RE_EST SDCCH_EMERG_CALL SDCCH_LOC_UPD SUCC_SDCCH_SMS_EST UNSUCC_SDCCH_SMS_EST sdcch_assign T3101_EXPIRED sdcch_new_call_assign SDCCH_SEIZ_ATT SDCCH_ASSIGN SDCCH_HO_SEIZ SDCCH_MOC_SEIZ_ATT SDCCH_MTC_SEIZ_ATT SDCCH_UNSUCC_IMM_ASSIGN_ATT SDCCH_BUSY_ATT SDCCH_DYNAMIC_RECONF_ATT SDCCH_RADIO_FAIL SDCCH_RF_OLD_HO SDCCH_USER_ACT SDCCH_BCSU_RESET SDCCH_NETW_ACT SDCCH_ABIS_FAIL_CALL SDCCH_ABIS_FAIL_OLD SDCCH_BTS_FAIL SDCCH_LAPD_FAIL SDCCH_A_IF_FAIL_CALL SDCCH_A_IF_FAIL_OLD
SD的占用
SD请求数 SD拥塞率：DECODE(sum(SDCCH_SEIZ_ATT),0,0,sum(SDCCH_BUSY_ATT) SD指配数 SD切换数 SD主叫请求数 SD被叫请求数 不成功的SD分配数在立即指配请求过程中 SD请求遇忙次数 动态SD分配次数
SD掉话
SD无线掉话 SD掉话率：decode(SUM(SDCCH_ASSIGN+SDCCH_HO_SEIZ),0,0,100*SUM SD切换掉话 SD用户操作掉话 SD BCSU重启掉话 SD 网络操作掉话 SD ABIS失败掉话 SD abis切换掉话 SD bts原因掉话 SD LAPD掉话 SD A口失败掉话 SD A口切换掉话 TCH请求数 TCH占用数 切换TCH占用数 呼叫重建数 全速率话务 半速率话务
L_TCH_SUM/AVE_AVAIL_TCH_DEN+ AVE_GPRS_CHANNELS_SUM/AVE_GPRS_CHANNELS_DEN+AVE_NON_AVAIL_TCH),0,0,100*SUM(AVE_AVAIL_TCH_SUM/AVE_AVAIL
_overload_deleted_rach)/sum(a.ch_req_msg_rec+b.packet_ch_req)) from p_nbsc_res_access
TCH话务量：sum(decode(p.res_av_denom14,0,0,p.ave_busy_tch/p. TCH拥塞率：100*decode(sum(a.tch_call_req),0,0,(sum(a.tch_cal
2071掉话数 800掉话率：decode(SUM(A.TCH_NORM_SEIZ+C.MSC_I_SDCCH_TCH+ C.B TCH无线掉话 TCH无线切换掉话 TCH ABIS失败掉话 TCH切换掉话 TCH A口失败掉话 TCH A口切换掉话
st_ccch_res - a.rej_seiz_att_due_dist + a.bcsu_overload_lower_limit + a.bcsu_overload_upper_limit + a.bcsu_overload_deleted_rach)/s
Z_ATT),0,0,sum(SDCCH_BUSY_ATT)/sum(SDCCH_SEIZ_ATT)*100) from P_NBSC_TRAFFIC
6+a.FREQ_UL_QUAL7),0,0,100*sum(a.FREQ_UL_QUAL0+a.FREQ_UL_QUAL1+a.FREQ_UL_QUAL2)/sum(a.FREQ_UL_QUAL0+a.FREQ_UL_QUAL1+a.FREQ_UL_QUAL2+
E_AVAIL_TCH_SUM/AVE_AVAIL_TCH_DEN+ AVE_GPRS_CHANNELS_SUM/AVE_GPRS_CHANNELS_DEN)/SUM(AVE_AVAIL_TCH_SUM/AVE_AVAIL_TCH_DEN+ AVE_GPRS_CH
相关解释 相关公式 SQL脚本附件 寻呼信息，LAC级 平均UM寻呼负荷：decode(sum(AVE_PAGING_LOAD_AIR_DEN),0,0,sum( 数据寻呼信息 语音寻呼信息 寻呼删除命令 平均PCH负荷 峰值PCH负荷 最小寻呼缓存 最大寻呼缓存容量
RACH接入
通过RACH发起的请求数 随机接入失败率：100*(sum(a.ghost_ccch_res - a.rej_seiz_att_d 立即指配数 立即指配拒绝数 由于AG buffer溢出而删除指示数 成功主叫SD占用数 成功被叫SD占用数 SD呼叫重建数 SD紧急呼叫数 SD位置更新数 成功SD短信建立数 不成功SD短信建立数 SD指配数 T3101超时数 呼叫所占用SD的数