【資料名稱】：小區(qū)指標提取（全）

【資料作者】：W

【資料日期】：2013

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

select to_char(tra.period_start_time,'yyyymmdd') "統(tǒng)計時間",
to_char(tra.period_start_time,'hh24')stime,
o_bsc.namebsc_name,
c_bts.cell_idcell_id,
tra.segment_id seg_id,
round(sum(ave_avail_tch_sum/ave_avail_tch_den),0)"工作信道數",
round(sum(ave_avail_tch_sum/ave_avail_tch_den)+sum(ave_non_avail_tch),0)"配置信道數",
round(100*decode(sum(ave_avail_TCH_sum/ave_avail_TCH_den)+sum(ave_non_avail_TCH),0,0,
sum(ave_avail_TCH_sum/ave_avail_TCH_den)/
(sum(ave_avail_TCH_sum/ave_avail_TCH_den)+sum(ave_non_avail_TCH))),2)"信道完好率",
round(sum(ava.ave_avail_full_tch/ava.res_av_denom2),0)"tchf信道數",
round(sum(ave_sdcch_sub/res_av_denom3),0) "SD信道數",
round(sum(ave_busy_tch/res_av_denom14),2) "TCH erl",
round(sum(ava.ave_tch_busy_full),2) "全速率erl",
round(sum(ava.ave_tch_busy_half),2) "半速率erl",
round(sum(ava.ave_busy_sdcch/ava.res_av_denom15),2)"sd erl",
sum(tra.tch_call_req-tra.tch_norm_seiz)-
sum(ho.msc_o_sdcch_tch+ho.bsc_o_sdcch_tch)-sum(ho.cell_sdcch_tch)+
sum(tra.tch_succ_seiz_for_dir_acc)-
sum(tra.tch_rej_due_req_ch_a_if_crc-
(ho.bsc_i_unsucc_a_int_circ_type+ho.msc_controlled_in_ho+
ho.ho_unsucc_a_int_circ_type))"tch擁塞次數",
decode(sum(tra.tch_call_req)-sum(tra.tch_rej_due_req_ch_a_if_crc
-(ho.bsc_i_unsucc_a_int_circ_type+ho.msc_controlled_in_ho
+ ho.ho_unsucc_a_int_circ_type)),0,0,
round(100*(sum(tra.tch_call_req - tra.tch_norm_seiz)
- sum(msc_o_sdcch_tch + bsc_o_sdcch_tch + cell_sdcch_tch)
+ sum(tra.tch_succ_seiz_for_dir_acc)
- sum(tra.tch_rej_due_req_ch_a_if_crc
-(bsc_i_unsucc_a_int_circ_type
+ msc_controlled_in_ho
+ ho_unsucc_a_int_circ_type)))/(sum(tra.tch_call_req)
- sum(tra.tch_rej_due_req_ch_a_if_crc
-(ho.bsc_i_unsucc_a_int_circ_type
+ ho.msc_controlled_in_ho
+ ho.ho_unsucc_a_int_circ_type)))),2)"tch擁塞率",
sum(tra.sdcch_busy_att) "sd原始擁塞次數",
sum(tra.sdcch_busy_att-tra.tch_seiz_due_sdcch_con) "sd擁塞次數",
round(100*decode(sum(tra.sdcch_seiz_att),0,0,sum(tra.sdcch_busy_att)/sum(tra.sdcch_seiz_att)),2) "sd原始擁塞率",
round(100*decode(sum(tra.sdcch_seiz_att),0,0,
sum(tra.sdcch_busy_att-tra.tch_seiz_due_sdcch_con)/sum(tra.sdcch_seiz_att)),2)"sd擁塞率",
sum(tra.tch_norm_seiz)-sum(tra.tch_succ_seiz_for_dir_acc) + sum(ho.msc_i_sdcch_tch+ho.bsc_i_sdcch_tch)+
sum(ho.cell_sdcch_tch)+ sum(tra.tch_seiz_due_sdcch_con)"試呼次數",
sum(tra.tch_radio_fail+tra.tch_rf_old_ho+tra.tch_abis_fail_call+tra.tch_abis_fail_old+tra.tch_a_if_fail_call+
tra.tch_a_if_fail_old+tra.tch_tr_fail+tra.tch_tr_fail_old+tra.tch_lapd_fail+tra.tch_bts_fail+tra.tch_user_act+
tra.tch_bcsu_reset+tra.tch_netw_act+tra.tch_act_fail_call)"TCH掉話數",
round(decode((sum(tra.tch_norm_seiz) /*(normal calls)*/
+sum(msc_i_sdcch_tch+bsc_i_sdcch_tch+cell_sdcch_tch) /* ;(DR calls)*/
-sum(tra.tch_succ_seiz_for_dir_acc) /*;ref.2*/
+ sum(tra.tch_seiz_due_sdcch_con)/*calls started as FACCH call setup*/
- sum(serv.tch_re_est_assign)),0,0,
100*(sum(tch_radio_fail+tch_rf_old_ho+tch_abis_fail_call+
tch_abis_fail_old+tch_a_if_fail_call+tch_a_if_fail_old+
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)
-sum(serv.tch_re_est_assign))/*(call re-establishments)*/ /(sum(tra.tch_norm_seiz) /*(normal calls)*/
+sum(msc_i_sdcch_tch+bsc_i_sdcch_tch+cell_sdcch_tch) /* ;(DR calls)*/
-sum(tra.tch_succ_seiz_for_dir_acc) /*;ref.2*/
+sum(tra.tch_seiz_due_sdcch_con)/*calls started as FACCH call setup*/
-sum(serv.tch_re_est_assign))),2)/*(call re-establishments)*/"掉話率dcr_3j",
sum(ho.msc_i_tch_tch_at+ho.msc_i_sdcch_tch_at