【資料名稱】：RB 升速與降速_KPI

【資料作者】：nsn

【資料日期】：2012-5-8

【資料語言】：中文

【資料格式】：TXT

【資料目錄和簡介】：

select
--max(to_char(period_start_time,'yyyymmdd')) as datetime
rnc.co_object_instance as rnc_id
--,bts.co_object_instance as bts_id
--,cell.co_object_instance as cell_id

/*由于AAL2擁塞導(dǎo)致的RB降速和釋放的counter*/
,sum(RB_DOWNGR_DUE_PBS_AAL2)/7as m1000c145
,sum(RB_RELEASE_DUE_PBS_AAL2)/7as m1000c157
,sum(RB_DOWNGR_DUE_PRE_EMP_AAL2)/7as m1000c150
,sum(RB_RELEASE_DUE_PRE_EMP_AAL2)/7 as m1000c162
/*由于AAL2擁塞導(dǎo)致的RB降速和釋放的counter*/

/*由于功率擁塞導(dǎo)致的RB降速和釋放的counter*/
,sum(RB_DOWNGR_DUE_DYLO_RL_POWER)/7 as m1000c143
,sum(RB_DOWNGR_DUE_PBS_INTERF)/7 as m1000c147
,sum(RB_RELEASE_DUE_PBS_INTERF)/7as m1000c159
/*由于功率擁塞導(dǎo)致的RB降速和釋放的counter*/

/*由于過載控制導(dǎo)致的RB降速和釋放的counter*/
,sum(RB_DOWNGR_DUE_OLC_TFC_SUBS)/7as m1000c142
,sum(RB_RELEASE_DUE_OLC_RL_RECONF)/7 as m1000c166
/*由于過載控制導(dǎo)致的RB降速和釋放的counter*/

from NOKRWW_PS_CELLRES_MNC1_RAW
,utp_common_objects rnc
-- ,utp_common_objects bts
--,utp_common_objects cell

where rnc.co_gid=RNC_ID
--and bts.co_gid=WBTS_ID
--and cell.co_gid=WCEL_ID
and rnc.co_object_instance in ('1969','1970','1971','1972')
--and bts.co_object_instance in ('&BTS')
--and cell.co_object_instance in ('&CELL')
and to_char(PERIOD_START_TIME,'yyyymmdd')>='&datetime'
and to_char(PERIOD_START_TIME,'yyyymmdd')<'&endtime'
and to_char(period_start_time,'hh24') = '20'

group by
--to_char(period_start_time,'yyyymmdd')
rnc.co_object_instance
--,bts.co_object_instance
--,cell.co_object_instance

order by rnc.co_object_instance