前一天忙时数据休眠小区.docVIP

前一天忙时数据休眠小区 Select To_Char(a.Period_Start_Time, yyyymmddHH24) 日期, bsc.name, --f.chinaname CellName, b.cell_id, --f.fldibtsno BTS, --f.fldibcfno BCF, a.Segment_Id SEG, b.Nsei, decode(Res_Av_Denom2,0,0, Round((decode(Res_Av_Denom2,0,0,round(Ave_Avail_Full_Tch / Res_Av_Denom2)) + decode(Res_Av_Denom3,0,0,round(Ave_Sdcch_Sub / 8 / Res_Av_Denom3)) + decode(Ave_Gprs_Channels_Den,0,0,Ave_Gprs_Channels_Sum / Ave_Gprs_Channels_Den)+ 1)/8,0)) Trx数, decode(Res_Av_Denom14,0,0,round(Ave_Busy_Tch / Res_Av_Denom14,2)) 话务量, decode(Res_Av_Denom14*Ave_Avail_Full_Tch,0,0, round( (Ave_Busy_Tch / Res_Av_Denom14)/(Ave_Avail_Full_Tch / Res_Av_Denom2),2)) 每线ERL, round((Rlc_Data_Blocks_Ul_Cs1 * 20 + Rlc_Data_Blocks_Ul_Cs2 * 30) / 1024,2) CS1_2上行流量, round((Rlc_Data_Blocks_Dl_Cs1 * 20 + Rlc_Data_Blocks_Dl_Cs2 * 30) / 1024,2) CS1_2下行流量, nvl(h.RLC_DATE_UL,0) edge_UL, nvl(h.RLC_DATE_DL,0) edge_DL, nvl(h.CS3_4_UL,0) CS3_4_UL, nvl(h.CS3_4_DL,0) CS3_4_DL, Nbr_of_UL_TBF 上行TBF数, (req_1_TSL_DL+req_2_TSL_DL+req_3_TSL_DL+req_4_TSL_DL+req_5_8_TSL_DL) 下行TBF数, (a.PACKET_IMMED_ASS_REJ_MSG) IMM_REJ, (Packet_Ch_Req) PS信道请求数 From p_Nbsc_Packet_Control_Unit a, c_Bts b, p_Nbsc_Res_Avail e,p_nbsc_traffic g,objects bsc, (select m.period_start_time 日期, to_char(m.period_start_time,hh24) 时段, m.bts_int_id bts_int_id, round((m.MCS1_RLC_DATA_UL_KBYTE+m.MCS2_RLC_DATA_UL_KBYTE+m.MCS3_RLC_DATA_UL_KBYTE+m.MCS4_RLC_DATA_UL_KBYTE+m.MCS5_RLC_DATA_UL_KBYTE+m.MCS6_RLC_DATA_UL_KBYTE+m.MCS7_RLC_DATA_UL_KBYTE+m.MCS8_RLC_DATA_UL_KBYTE+m.MCS9_RLC_DATA_UL_KBYTE)/1024,2) RLC_DATE_UL, round((m.MCS1_RLC_DATA_DL_KBYTE+m.MCS2_RLC_DATA_DL_KBYTE+m.MCS3_RLC_DATA_DL_KBYTE+m.MCS4_RLC_DATA_DL_KBYTE+m.MCS5_RLC_D