内容发布更新时间 : 2025/6/1 6:39:09星期一 下面是文章的全部内容请认真阅读。
,sum(M8006C206+M8006C215+decode(M8006C54,0,0,ceil(M8006C45/M8006C54))) \掉线率分母(QCI=1)\
,sum(M8006C177) \异常释放次数(QCI=2)\
,sum(M8006C207+M8006C216+decode(M8006C54,0,0,ceil(M8006C46/M8006C54))) \掉线率分母(QCI=2)\
,AVG(M8008C17) \连接建立时长\,AVG(M8007C14) \建立时长\
,avg(M8011C50)/17280000 \上行PRB利用率\,avg(M8011C54)/69120000 \下行PRB利用率\
FROM (
SELECT M8013.sdatetime
-- ,M8020.MRBTS_ID -- ,M8020.LNBTS_ID -- ,M8020.LNCEL_ID
,enb_id || '_' || cell_id enb_cell ,enb_id ,cell_id ,bts_ip
,bts_version ,bts_name ,cel_name
,EU0427,M8001C305,M8001C314,M8001C323,M8001C306,M8001C315,M8001C324,M8001C269,M8001C419,M8001C227
,V8006C1,V8006C2,V8006C3,V8006C4,V8006C5,V8006C6,V8006C7,V8006C8,V8006C9,V8006C10,V8006C11,V8006C12 ,EU0205,EU0507,EU0508,EU0509,EU0510,EU0515,EU0516 ,M8006C45,M8006C46,M8006C54,M8006C143,M8006C152,M8006C176,M8006C177,M8006C188,M8006C189,M8006C192,M8006C196,M8006C197,M8006C198,M8006C201,M8006C205 ,M8006C206,M8006C207,M8006C210,M8006C214,M8006C215,M8006C216,M8006C219,M8006C223
,M8007C14 ,M8008C17
,M8026C255,M8026C260,M8026C256,M8026C261 ,M8011C50,M8011C54 ,M8012C116,M8012C143
,M8013C5,M8013C17,M8013C18,M8013C19,M8013C21,M8013C26,M8013C31,M8013C34 ,M8016C34,M8016C33
FROM
20
( select
to_char(period_start_time,'yyyymmddhh24') sdatetime ,LNCEL_ID
,to_char(period_start_time,'yyyymmddhh24')||LNCEL_ID cel_key_id
,AVG(nvl(PDC