【資料名稱】：升級OSS5.4自用腳本

【資料作者】：Dri

【資料日期】：20130415

【資料語言】：中文

【資料格式】：其它

【資料目錄和簡介】：
希望大家資源共享。謝謝

select to_char(qua.period_start_time,'yyyymmdd')bscday,
o_bsc.namebscname,
c_bsc_bts.bts_cell_idcell_id,
qua.segment_idseg_id,
c_bsc_bts.bts_segment_name seg_name,
sum(freq_ul_qual0) ulq0,
sum(freq_ul_qual0+freq_ul_qual1+freq_ul_qual2+freq_ul_qual3+freq_ul_qual4+freq_ul_qual5) ulq5,
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)ulq,
0.48*(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))/60 trxtime,
sum(freq_dl_qual0) dlq0,
sum(freq_dl_qual0+freq_dl_qual1+freq_dl_qual2+freq_dl_qual3+freq_dl_qual4+freq_dl_qual5) dlq5,
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) dlq,
qua.bts_idbts_id,
o_bts.namebts_name,
qua.trxtrx,
qua.trx_frequencyfreq
,round(100*decode(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),0,0,sum(freq_ul_qual0)/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)),2) ulq0
,round(100*decode(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),0,0,sum(freq_ul_qual0+freq_ul_qual1+freq_ul_qual2+freq_ul_qual3+freq_ul_qual4+freq_ul_qual5)/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)),2) ulq0_5
,round(100*decode(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),0,0,sum(freq_dl_qual0)/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)),2) dlq0
,round(100*decode(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),0,0,sum(freq_dl_qual0+freq_dl_qual1+freq_dl_qual2+freq_dl_qual3+freq_dl_qual4+freq_dl_qual5)/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)),2) dlq0_5
from p_nbsc_rx_qual qua,c_bsc_bts,objects o_bts,objects o_bsc,p_nbsc_res_avail
where
qua.bts_int_id=to_number(substr(c_bsc_bts.OBJ_GID,-7,7))

and qua.int_id=to_number(substr(c_bsc_bts.bsc_int_id,-7,7))

--and to_number(substr(c_bsc_bts.OBJ_GID,-7,7))=o_bts.int_id

--and to_number(substr(c_bsc_bts.bsc_int_id,-7,7))=o_bsc.int_id

/*
where qua.bts_int_id=c_bts.int_id
and qua.int_id=o_bsc.int_id
and c_bts.int_id=o_bts.int_id
*/

--and c_bsc_bts.conf_name='<ACTUAL>'
and (o_bsc.name like 'BS%')
and c_bsc_bts.bts_cell_id=22181
and to_char(qua.period_start_time,'hh24') in (10)
and to_char(qua.period_start_time,'yyyymmdd') between &Sdate and &Edate
group by to_char(qua.period_start_time,'yyyymmdd') ,o_bsc.name,c_bsc_bts.bts_cell_id,qua.segment_id,
c_bsc_bts.BTS_SEGMENT_NAME,qua.bts_id,o_bts.name,qua.trx,qua.trx_frequency