诺西MR文件使用手册.docx

1、诺西MR文件使用手册诺西MR文件使用手册诺西BSC软件版本升级至RG20后，其MR测量功能已能够基本满足日常整体分析及问题定位。诺西的MR文件与话统文件同样使用SQL脚本导出，所需脚本详见下。本使用手册提供常用MR文件的SQL导出脚本，并对文件内字段进行详解。另外给出针对每类MR文件的分析关键点供参考。 一、 DAC- Defined Adjacent Cell（已定义邻区测量）1、导出SQLselect 诺基亚 VENDOR_NAME,to_char(cf.period_start_time,yyyy-mm-dd hh24:mi:ss) START_TIME,to_char(cf.perio

2、d_start_time,hh24) s_time,to_char(sysdate,yyyy-mm-dd hh24:mi:ss) time_stamp,o1.name ,bts.cell_id ci,bts.la_id_lac lac,o2.object_instance bts ,cf.*from p_nbsc_channel_finder cf,objects o1,objects o2,c_bts btswhere o1.object_class =3 and o1.name lile &BSCname%and o1.int_id = cf.int_idand o2.int_id =cf

3、.bts_int_idand cf.bts_int_id = bts.int_idand bts.conf_name =and cf.period_start_time=to_Date(&sdatetime,yyyymmddhh24) and cf.period_start_timeto_Date(&sdatetime,yyyymmddhh24)2、DAC文件示例及关键字段含义字段名字段解释备注DB_VALUE_LOW电平差下限DB_VALUE_HIGH电平差上限AVE_DL_SIG_STR_SERV_CELL_SUM服务小区的下行平均信号强度的总和 服务小区下行平均信号强度实际值=AVE_D

4、L_SIG_STR_SERV_CELL_SUM/AVE_DL_SIG_STR_SERV_CELL_DEN-110AVE_DL_SIG_STR_SERV_CELL_DEN服务小区的测量报告的数量 AVE_DL_SIG_STR_ADJ_CELL邻小区下行平均信号强度邻区下行平均信号强度实际值=AVE_DL_SIG_STR_ADJ_CELL-110NCC邻小区NCCBCC邻小区BCCBCCH邻小区BCCHNBR_OF_SAMPLES_IN_CLASS_1满足邻小区电平绝对值-服务小区电平绝对值低于电平差下限的测量报告数（即A-B-12db）NBR_OF_SAMPLES_IN_CLASS_2满足邻小区

5、电平绝对值-服务小区电平绝对值在低于电平差上限高于电平差下限的测量报告数(即-12A-B0)3、DAC文件分析关键点1) 可以分析出服务小区与每个邻小区的相关性，作为邻区关系定义必要性的参考。相关性=采样点数/总测量报告数。2) 从服务小区与邻小区的电平差值区间分布可以分析出服务小区与邻小区间的重叠关系。3) 作为过覆盖小区分析数据源之一，判断小区影响范围。（小区影响范围包括DAC与CF内所有测量到的小区）。二、 CF- Channel Finder（未定义但被测量到的小区测量）1、导出SQLselect 诺基亚 VENDOR_NAME,to_char(cf.period_start_time

6、,yyyy-mm-dd hh24:mi:ss) START_TIME,to_char(cf.period_start_time,hh24) s_time,to_char(sysdate,yyyy-mm-dd hh24:mi:ss) time_stamp,o1.name ,bts.cell_id ci,bts.la_id_lac lac,o2.object_instance bts ,cf.*from p_nbsc_channel_finder cf,objects o1,objects o2,c_bts btswhere o1.object_class =3 and o1.name lile

7、&BSCname%and o1.int_id = cf.int_idand o2.int_id =cf.bts_int_idand cf.bts_int_id = bts.int_idand bts.conf_name =and cf.period_start_time=to_Date(&sdatetime,yyyymmddhh24) and cf.period_start_timeto_Date(&endtime,yyyymmddhh24)2、CF文件示例及关键字段含义字段名字段解释备注DB_VALUE_LOW电平差下限DB_VALUE_HIGH电平差上限AVE_DL_SIGNAL_STRE

8、NGTH测量到的小区下行平均信号强度测量到的小区下行平均信号强度实际值=AVE_DL_SIG_STR_ADJ_CELL-110NCC测量到的小区NCCBCC测量到的小区BCCBCCH测量到的小区BCCHNUM_OF_SAMPLES_IN_CLASS_1满足测量到的小区电平绝对值-服务小区电平绝对值低于电平差下限的测量报告数（即A-B-12db）NUM_OF_SAMPLES_IN_CLASS_2满足测量到的小区电平绝对值-服务小区电平绝对值在低于电平差上限高于电平差下限的测量报告数(即-12A-B0)3、CF文件分析关键点1) 可根据测量到的小区的平均电平强度及与服务小区的相关性判断该小区是否需

9、要与服务小区定义邻区。相关性=采样点数/总测量报告数2) 从服务小区与邻小区的电平差值区间分布可分析出服务小区与测量到的小区间的重叠关系。3) 作为过覆盖小区分析数据源之一，判断小区影响范围。（小区影响范围包括DAC与CF内所有测量到的小区）三、 Rxlev&RQ-电平与质量采样点二维分布1、导出SQL小区级select to_char(a.period_start_time,yyyymmddhh24) Sdate ,b.name ,bts.la_id_lac ,bts.CELL_ID ,a.class_upper_range-110 rxlev_upper_range ,a.trx_freq

10、uency ,Sum(FREQ_UL_QUAL0+FREQ_UL_QUAL1+FREQ_UL_QUAL2+FREQ_UL_QUAL3+FREQ_UL_QUAL4+FREQ_UL_QUAL5+FREQ_UL_QUAL6+fREQ_UL_QUAL7) ul_all_sample ,Sum(FREQ_DL_QUAL0+FREQ_DL_QUAL1+FREQ_DL_QUAL2+FREQ_DL_QUAL3+FREQ_DL_QUAL4+FREQ_DL_QUAL5+FREQ_DL_QUAL6+FREQ_DL_QUAL7) dl_all_sample ,sum(freq_ul_qual0) as ul_qual

11、0 ,sum(freq_ul_qual1) as ul_qual1 ,sum(freq_ul_qual2) as ul_qual2 ,sum(freq_ul_qual3) as ul_qual3 ,sum(freq_ul_qual4) as ul_qual4 ,sum(freq_ul_qual5) as ul_qual5 ,sum(freq_ul_qual6) as ul_qual6 ,sum(freq_ul_qual7) as ul_qual7 ,sum(freq_dl_qual0) as dl_qual0 ,sum(freq_dl_qual1) as dl_qual1 ,sum(freq_

12、dl_qual2) as dl_qual2 ,sum(freq_dl_qual3) as dl_qual3 ,sum(freq_dl_qual4) as dl_qual4 ,sum(freq_dl_qual5) as dl_qual5 ,sum(freq_dl_qual6) as dl_qual6 ,sum(freq_dl_qual7) as dl_qual7 from p_nbsc_rx_statistics a ,objects b ,c_bts btswhere b.int_id=a.int_id and bts.int_id=a.bts_int_id and a.period_star

13、t_time between to_date(&sdate,yyyymmddhh24) and to_date(&edate,yyyymmddhh24) and b.name like &BSCname%Group By to_char(a.period_start_time,yyyymmddhh24) ,a.class_upper_range-110 ,b.name ,bts.la_id_lac ,bts.CELL_ID ,a.trx_frequency载频级select 诺基亚 VENDOR_NAME,to_char(rs.period_start_time,yyyy-mm-dd hh24

14、) Start_time,to_char(rs.period_start_time,hh24) S_TIME,to_char(sysdate,yyyy-mm-dd hh24) time_stamp,o1.name bsc_name,bts.cell_id ci,bts.la_id_lac lac,o2.object_instance bts ,rs.*from p_nbsc_rx_statistics rs,objects o1,objects o2,c_bts btswhere o1.object_class =3 and o1.name like &BSCname%and o1.int_i

15、d = rs.int_idand o2.int_id =rs.bts_int_idand rs.bts_int_id = bts.int_idand bts.conf_name =and rs.period_start_time=to_Date(&sdatetime,yyyymmddhh24 and rs.period_start_timeto_Date(&endtime,yyyymmddhh24)2、Rxlev&RQ文件示例及关键字段含义字段名字段解释RXLEV_UPPER_RANGE电平区间,总共分为-100以下,99-95,94-90,89-80,79-70,69-37 六个区间段TRX

16、_FREQUENCY载频频点号UL_QUAL0上行QUAL0采样点数UL_QUAL1上行QUAL1采样点数UL_QUAL2上行QUAL2采样点数UL_QUAL3上行QUAL3采样点数UL_QUAL4上行QUAL4采样点数UL_QUAL5上行QUAL5采样点数UL_QUAL6上行QUAL6采样点数UL_QUAL7上行QUAL7采样点数DL_QUAL0下行QUAL7采样点数DL_QUAL1下行QUAL8采样点数DL_QUAL2下行QUAL9采样点数DL_QUAL3下行QUAL10采样点数DL_QUAL4下行QUAL11采样点数DL_QUAL5下行QUAL12采样点数DL_QUAL6下行QUAL13

17、采样点数DL_QUAL7下行QUAL14采样点数3、Rxlev&RQ文件分析关键点1) 可根据服务小区电平与质量分布判断小区质量原因。2) 可根据载频级小区电平与质量分布判断是否存在严重质量载频。四、 Ho-切换测量1、导出SQLSELECT bsc.name , c_bts.la_id_lac serv_lac, c_bts.cell_id serv_ci, p.BTS_ID , p.LAC adj_lac , p.CI adj_ci, sum(p.HO_ATT_TO_ADJ) , sum(p.HO_SUCC_TO_ADJ), sum(p.HO_ATT_from_ADJ) , sum(p.H

18、O_SUCC_from_ADJ) from P_NBSC_HO_ADJ p ,objects bsc ,objects bts ,c_bts where bts.int_id = p.bts_int_id and bsc.int_id = p.int_id and c_bts.int_id=p.bts_int_id and c_bts.int_id=bts.int_id and bsc.object_instance != 0 and p.period_start_time between to_date(&sdatetime,yyyymmddhh24) and to_date(&endtim

19、e,yyyymmddhh24) and bsc.name like &SYSNAME%GROUP BY bsc.name , c_bts.la_id_lac , c_bts.cell_id , p.BTS_ID , p.LAC , p.CI2、HO文件示例及关键字段含义字段名字段解释SERV_LAC服务小区LACSERV_CI服务小区CIADJ_LAC邻小区LACADJ_CI邻小区CISUM(P.HO_ATT_TO_ADJ)切出尝试次数SUM(P.HO_SUCC_TO_ADJ)切出成功次数SUM(P.HO_ATT_FROM_ADJ)切入尝试次数SUM(P.HO_SUCC_FROM_ADJ)切入

20、成功次数3、Rxlev&RQ文件分析关键点1) 判断小区间切换成功率。2) 判断小区间邻区关系必要性。五、 TA-TA值测量1、导出SQLSELECT c.la_id_lac ,c.cell_id ,o_bsc.name bscname ,o_bts.name btsname ,d.class_upper_range ,d.trx_type ,sum(d.freq_reports) sum_freq_reports ,round(avg(d.min_power),0) avg_min_power ,round(avg(d.max_power),0) avg_max_power ,round(a

21、vg(d.ave_power),0) avg_avg_powerFROM p_nbsc_timing_advance d, objects o_bts, objects o_bsc, c_bts c WHERE d.period_start_time between to_date(&sdatetime,yyyymmddhh24) and to_date(&endtime,yyyymmddhh24) AND o_bsc.name like &BSCName% AND o_bts.int_id=d.bts_int_id AND o_bts.object_class=4 AND o_bsc.obj

22、ect_class=3 AND o_bsc.int_id=d.int_id and d.bts_int_id=c.int_id GROUP BY c.la_id_lac, c.cell_id, o_bsc.name, o_bts.name, d.class_upper_range, d.trx_type2、TA文件示例及关键字段含义字段名字段解释CLASS_UPPER_RANGETA区间,共分为1;2;3;4;6;10;16;25;40;63 十个区间段SUM_FREQ_REPORTS测量报告数AVG_MIN_POWERMS最小功率AVG_MAX_POWERMS最大功率AVG_AVG_POWE

23、RMS平均功率3、TA文件分析关键点1) 判断小区话务TA分布，分析话务集中区域。六、 LB- Link Balance（链路平衡测量）1、导出SQLselect c.la_id_lac ,c.cell_id ,o_bsc.name bscname ,o_bts.name btsname ,d.class_sig_level ,d.normal ,d.ms_limited ,d.bs_limited ,d.max_power ,d.trx_type FROM p_nbsc_link_balance d, objects o_bts, objects o_bsc, c_bts c WHERE d

24、.period_start_time between to_date(&sdatetime,yyyymmddhh24) and to_date(&endtime,yyyymmddhh24) AND o_bsc.name like &BSCName% AND o_bts.int_id=d.bts_int_id AND o_bts.object_class=4 AND o_bsc.object_class=3 AND o_bsc.int_id=d.int_id and d.bts_int_id=c.int_id GROUP BY c.la_id_lac, c.cell_id, o_bsc.name

25、, o_bts.name ,d.class_sig_level ,d.normal ,d.ms_limited ,d.bs_limited ,d.max_power ,d.trx_type2、LB文件示例及关键字段含义字段名字段解释CLASS_SIG_LEVEL上行电平与下行电平的差值,分为11个区间段Class 1 = -20 dB to -15 dBClass 2 = -14 dB to -10 dBClass 3 = -09 dB to -06 dBClass 4 = -05 dB to -03 dBClass 5 = -02 dB to -01 dBClass 6 = 0Class 7

26、 = 01 dB to 02 dBClass 8 = 03 dB to 05 dBClass 9 = 06 dB to 09 dBClass 10 = 10 dB to 14 dBClass 11 = 15 dB to 20 dBNORMALMS和BS均不以满功率发射的采样点个数MS_LIMITEDMS以满功率发射,BS不以满功率发射的采样点个数BS_LIMITEDBS以满功率发射,MS不以满功率发射的采样点个数MAX_POWERMS和BS均以满功率发射的采样点个数3、LB文件分析使用简要说明1) 判断小区是否存在上下行不平衡。2) MAX_POWER采样点比例较大，怀疑功控效果不佳或存在干扰。