所有NSEI负荷及拒绝.doc

所有NSEI负荷及拒绝select bsc, NSEI_DAP.NSEI, nvl(total_dap_slot,0) EDAP时隙, nvl(TOTAL_CDED,0) 静态信道数, nvl(TOTAL_CDEF,0) 动态信道数, nvl(TOTAL_实际信道数,0) 实际信道数, nvl(TOTAL_PEAK_GP,0) 申请最大信道数, nvl(TOTAL_PCU_LACK,0) PCU拒绝次数, (nvl(total_dap_slot,0)+nvl(TOTAL_CDEF,0)/256*100 PCU配置负荷, (nvl(total_dap_slot,0)+nvl(TOTAL_实际信道数,0)/256*100 PCU实际负荷, (nvl(total_dap_slot,0)+nvl(TOTAL_PEAK_GP,0)/256*100 PCU峰值负荷 from ( select bsc, nsei, sum(total_2m_slot)*4 total_dap_slotfrom( select bsc, d.nsei, f.first_tsl, f.last_tsl, f.dap_id, max(f.last_tsl-f.first_tsl+1) total_2M_slot from c_bts d, objects a, objects b, objects c, ( select a.BCSU_ID, a.PCU_ID, b.object_instance NSEI from c_nse a,objects b where _id=_id and a.conf_name= ) e, ( select BSC, g.cell_id, b.object_instance BTS_ID, g.nsei, f.first_tsl, f.last_tsl, a.dap_id, sum(decode(ch_0_type,0,1,2,1,0)+ decode(ch_1_type,0,1,2,1,0)+ decode(ch_2_type,0,1,2,1,0)+ decode(ch_3_type,0,1,2,1,0)+ decode(ch_4_type,0,1,2,1,0)+ decode(ch_5_type,0,1,2,1,0)+ decode(ch_6_type,0,1,2,1,0)+ decode(ch_7_type,0,1,2,1,0) total_radio_slot, count(c.object_instance) total_trx from c_trx a,objects b,objects c,objects d,objects e, ( select BCSU_id, FIRST_TSL, LAST_TSL, PCM_CIRCUIT_ID, PCU_ID, , b.object_instance from c_dap c,objects a,objects b where _id=b.parent_int_id and _id=_id and c.conf_name= ) f,C_BTS g where gprs_enabled_trx=1 and _id=d.parent_int_id and _id=b.parent_int_id and _id=c.parent_int_id and _id=_id and a.dap_id=f.object_instance and = and a.conf_name= and _id=_id and g.conf_name= group by ,cell_id,b.object_instance,nsei,first_tsl,last_tsl,a.dap_id ) f where _id=b.parent_int_id and _id=c.parent_int_id and _id=_id and d.conf_name= and like (NCBSC%) and not like %for% and e.NSEI(+)=d.nsei and d.nsei is not null and f.cell_id(+)=d.cell_id group by ,d.nsei,f.first_tsl,f.last_tsl,f.dap_id order by BSC) dap group by bsc,nsei ) NSEI_DAP, ( select NSEI, max(CDED_SLOT) TOTAL_CDED, max(CDEF_SLOT) TOTAL_CDEF, max(PS实际信道数) TOTAL_实际信道数, max(PEAK_GP) TOTAL_PEAK_GP, max(PCU_LACK) TOTAL_PCU_LACK from (select c.nsei,sum(decode(Res_Av_Denom2*Ave_Gprs_Channels_Den,0,0,decode(Ave_Avail_Full_Tch/Res_Av_Denom2+Ave_Gprs_Channels_Sum / Ave_Gprs_Channels_Den)*Dedicated_Gprs_Capacity/100,0,0,decode(sign(Ave_Avail_Full_Tch/Res_Av_Denom2+Ave_Gprs_Channels_Sum / Ave_Gprs_Channels_Den)*Dedicated_Gprs_Capacity/100-1),-1,1,trunc(Ave_Avail_Full_Tch/Res_Av_Denom2+Ave_Gprs_Channels_Sum / Ave_Gprs_Channels_Den)*Dedicated_Gprs_Capacity/100) CDED_SLOT, sum(decode(Res_Av_Denom2,0,0,trunc(Ave_Avail_Full_Tch/Res_Av_Denom2+Ave_Gprs_Channels_Sum / Ave_Gprs_Channels_Den)*Default_Gprs_Capacity/100) CDEF_SLOT,sum(decode(ave_gprs_channels_den,0,0,ave_GPRS_channels_sum/ave_GPRS_channels_den)PS实际信道数,-sum(decode(ave_avail_tch_den,0,0,ave_avail_tch_sum/ave_avail_tch_den) CS_SLOT,sum(PEAK_GPRS_CHANNELS) PEAK_GP,-sum(PEAK_BUSY_TCH ) PEAK_CS_SLOT,sum(GPRS_TER_UG_REJ_DUE_LACK_PCU) PCU_LACKfromp_nbsc_res_avail e,objects bsc,c_bts c,p_nbsc_traffic twhere _id=e.bts_int_idand _id=_idand _id=t.bts_int_idand e.period_start_time=t.period_start_timeand bsc.object_class=3and to_char(e.per