EGPRS优化.doc

EGPRS优化 /* add the rlc_61 */ Select b.Rpdate, b.Bsc, b.Lacid, b.Rac_Id, b.Cell_Id, b.Bcf_Id, b.Bts_Id, b.Bts_Name, Dap_Id, b.Hop, b.p_Nsei Nsei, b.Gena, b.Egena, b.Cs34enabled Cs34, e.Trxnum, e.Gtrxnum, e.Tchch, e.Gtchch, b.Cded, b.Cdef, b.Cmax, e.Gtchch * e.Cded / 100 Cded_Tsl, e.Gtchch * e.Cdef / 100 Cdef_Tsl, --b.cmax, To_Char(a.Traf, 990.99) Traf, To_Char(Sd_Traf, 990.99) Sd_Traf, Ava_16, Ava_16a, --ava_16_omc, --ava_16a_omc, a.Peak_Gprs_Ch, Msl_14, Nvl(d.Trf_233a, 0) Gprs上行单时隙速率, Nvl(d.Trf_235b, 0) Gprs下行单时隙速率, Nvl(c.Trf_234, 0) Edge上行每时隙吞吐率, Ul_Ts_Ave_Per 上行每用户占用时隙数, Ul_Tbf_Per_Tsl 上行每时隙tbf数, Nvl(c.Trf_236, 0) Edge下行每时隙吞吐率, Dl_Ts_Ave_Per 下行每用户占用时隙数, Dl_Tbf_Per_Tsl 下行每时隙tbf数, Nvl(Gprs12ulpayload + Gprs12dlpayload, 0) + Nvl(Ulcs34payload + Dlcs34payload, 0) + Nvl(Ulegprspayload + Dlegprspayload, 0) 数据业务总流量, Nvl(Gprs12ulpayload, 0) + Nvl(Ulcs34payload, 0) 上行gprs流量, Nvl(Gprs12dlpayload, 0) + Nvl(Dlcs34payload, 0) 下行gprs流量, Nvl(c.Ulegprspayload, 0) 上行egprs流量, Nvl(c.Dlegprspayload, 0) 下行egprs流量, Nvl(Gprs12ulpayload, 0) + Nvl(Ulcs34payload, 0) + Nvl(Ulegprspayload, 0) 上行数据业务总流量, Nvl(Gprs12dlpayload, 0) + Nvl(Dlcs34payload, 0) + Nvl(Dlegprspayload, 0) 下行数据业务总流量, --ava_16a, 100 * Decode(Ava_16, 0, 0, Busygprsdlch / Ava_16) Dlusage, Busygprsdlch, p_Ass_Nack, p_Ass_Msg, p_Ass_Rej, Rej_Rate, Nvl(Gprs12ulpayload + Gprs12dlpayload, 0) + Nvl(Ulcs34payload + Dlcs34payload, 0) + Nvl(Ulegprspayload + Dlegprspayload, 0) Pspld, Dl_Tbf_Per_Tsl Tbf_38c, --max_dl_tbf MAX_SIM_DL_TBF, --llc_3a, Trf_236, Hard_Blocking_Tbf_16, Soft_Blocking_Blck_33, --GPRS12ULPayload, --GPRS12DLPayload, --ULCS34Payload, --DLCS34Payload, --ULEGPRSPayload, --DLEGPRSPayload, -- TBFFR_customer_old, --DL_TBF_Rel_Fail_Rate, --DL_TBF_Est_Fail_Rate, Gprs_Block_Tbf_Fr, --d.EDA_all_UL_allo, --EDA_MS_penetration --DL_8PSK_TO_GM