性能查询语句和说明

1、1 性能查询-小区间切换场景描述：tpa_sts_cell_adjho_ne里m_int_id主小区id,n_int_id邻小区id。提出要增加邻小区的信息输出，后来我增加了黄色标注的部分。对下面的语句有什么建议。select _id, as ne_name, cell.ci as ci, cell.lac as lac, cell_ as adj_name, cell_b.ci as adj_ci, cell_b.lac as adj_lac, a.scan_start_time as start_time, att_o_ho_intercell a

2、s att_o_ho_intercell, s_i_ho_intercell as s_i_ho_intercell, s_o_ho_intercell as s_o_ho_intercell, att_i_ho_intercell as att_i_ho_intercell from tpa_sts_cell_adjho_ne a, cell, cell cell_b where 1 = 1 and scan_start_time in (select scan_start_time from and a.m_int_id = _id and a.n_int_id = cel

3、l__id and a.m_int_id in (select * from and sum_level = 02 性能专题-话务量分析场景描述： 在性能专题，查询类似下面的结构。从tpa_sts_cell_ne里取的指标值，关联cell表获得资源信息select tpa_sts_cell__id, as ne_name, cell.zh_name, tpa_sts_cell_ne.scan_start_time as start_time, cell.bsc_name as related_bsc_name, cell.Lac, cell.Ci, r

4、ound(tpa_sts_cell_ne.tch_traffic, 2) as tch_traffic, round(tpa_sts_cell_ne.avail_tch_nbr, 0) as avail_tch_nbr, round(round(sfb_divfloat_1(tpa_sts_cell_ne.tch_traffic, tpa_sts_cell_ne.avail_tch_nbr), 4), 2) as tchpernbr, round(tpa_sts_cell_ne.tch_nbr, 0) as tch_nbr, round(tpa_sts_cell_ne.tch_traffic_

5、half, 2) as tch_traffic_half from tpa_sts_cell_ne, cell where 1 = 1 and scan_start_time in (select scan_start_time from AND sum_level = 0 and tpa_sts_cell__id = _id and sfb_divfloat_1(tpa_sts_cell_ne.tch_traffic, tpa_sts_cell_ne.avail_tch_nbr) > 0.5 and tpa_sts_cell__id in (se

6、lect int_id from order by start_time desc, tchpernbr desc3 TopN查询场景描述：小区每个时间点的的前10条数据。2010-05-09 08:00:00为2010-05-09 10:00:00，对这样的取各个时间点的前N条数据有没有建议select tpa_sts_cell__id as int_id, tpa_sts_cell_ne.scan_start_time as start_time, as ne_name, cell.lac as lac, cell.ci as ci, cell.bsc_na

7、me as related_bsc_name, tpa_sts_cell_ne.tch_drop_call as tch_drop_call, tpa_sts_cell_ne.tch_seize_nho as tch_seize_nho, tpa_sts_cell_ne.pch_succ_iart as pch_succ_iart, tpa_sts_cell_ne.sdcch_cong as sdcch_cong, tpa_sts_cell_ne.tch_call_req as tch_call_req, tpa_sts_cell_ne.tch_call_req_nho as tch_call

8、_req_nho, tpa_sts_cell_ne.att_tch_ovrfl as att_tch_ovrfl, tpa_sts_cell_ne.att_tch_ovrfl_nho as att_tch_ovrfl_nho, tpa_sts_cell_ne.att_sdcch_seiz as att_sdcch_seiz, tpa_sts_cell_ne.rand_acc_req as rand_acc_req, round(round(sfb_divfloat_1(tpa_sts_cell_ne.tch_drop_call, tpa_sts_cell_ne.tch_seize_nho),

9、4) * 100, 3) as tchdropper, round(round(sfb_divfloat_1(tpa_sts_cell_ne.pch_succ_iart, tpa_sts_cell_ne.rand_acc_req), 4) * 100, 3) as radioinjectPercent from tpa_sts_cell_ne, cell where 1 = 1 and tpa_sts_cell__id in (select * from and tpa_sts_cell_ne.scan_start_time in (to_date('2010-05-09 08:00:00', 'yyyy-mm-dd hh24:mi:ss') and tpa_sts_cell__id = _idand 10 >= rownum and tpa_sts_cell_ne