发布时间 : 星期四 文章诺西LTE指标提取SQL语句20160801更新完毕开始阅读
additional EPS bearer setup attempts for GBR DRBs of QCI4 characteristics.
,sum(nvl(EPS_BEARER_STP_COM_INI_QCI_2,0)) M8006C168 --This measurement provides the number of initial EPS bearer setup completions for GBR DRBs of QCI2 characteristics.
,sum(nvl(EPS_BEARER_STP_COM_INI_QCI_3,0)) M8006C169 --This measurement provides the number of initial EPS bearer setup completions for GBR DRBs of QCI3 characteristics.
,sum(nvl(EPS_BEARER_STP_COM_INI_QCI_4,0)) M8006C170 --This measurement provides the number of initial EPS bearer setup completions for GBR DRBs of QCI4 characteristics.
,sum(nvl(EPS_BEARER_STP_COM_ADD_QCI_2,0)) M8006C171 --This measurement provides the number of additional EPS bearer setup completions for GBR DRBs of QCI2 characteristics.
,sum(nvl(EPS_BEARER_STP_COM_ADD_QCI_3,0)) M8006C172 --This measurement provides the number of additional EPS bearer setup completions for GBR DRBs of QCI3 characteristics.
,sum(nvl(EPS_BEARER_STP_COM_ADD_QCI_4,0)) M8006C173 --This measurement provides the number of additional EPS bearer setup completions for GBR DRBs of QCI4 characteristics. ,sum(nvl(PRE_EMPT_GBR_BEARER,0)) M8006C174 --This measurement provides the number of GBR E-RABs (Guaranteed Bit Rate bearers, 3GPP TS 23.203) being released due to lack of radio resources. ,sum(nvl(PRE_EMPT_NON_GBR_BEARER,0)) M8006C175 --This measurement provides the number of non-GBR E-RABs (non-Guaranteed Bit Rate bearers, 3GPP TS 23.203) being released due to lack of radio resources.
,sum(nvl(ERAB_REL_ENB_ACT_QCI1,0)) M8006C176 --This measurement provides the number of released active E-RABs (i.e. when there was user data in the queue at the time of release) with QCI1 characteristics. The release is initiated by the eNB due to radio connectivity problems. ,sum(nvl(ERAB_REL_ENB_ACT_QCI2,0)) M8006C177 --This measurement provides the number of released active E-RABs (i.e. when there was user data in the queue at the time of release) with QCI2 characteristics. The release is initiated by the eNB due to radio connectivity problems. ,sum(nvl(ERAB_REL_ENB_ACT_QCI3,0)) M8006C178 --This measurement provides the number of released active E-RABs (i.e. when there was user data in the queue at the time of release) with QCI3 characteristics. The release is initiated by the eNB due to radio connectivity problems. ,sum(nvl(ERAB_REL_ENB_ACT_QCI4,0)) M8006C179 --This measurement provides the number of released active E-RABs (i.e. when there was user data in the queue at the time of release) with QCI4 characteristics. The release is initiated by the eNB due to radio connectivity problems. ,sum(nvl(ERAB_REL_ENB_ACT_NON_GBR,0)) M8006C180 --This measurement provides the number of released active E-RABs (i.e. when there was user data in the queue at the time of release) with non-GBR characteristics (QCI5..9). The release is initiated by the eNB due to radio connectivity problems. ,sum(nvl(ERAB_IN_SESSION_TIME_QCI1,0)) M8006C181 --This measurement provides the aggregated in-session activity time in seconds for all E-RABs with QCI1 characteristics. The E-RAB is said to be in session if any user data has been transferred in UL or DL direction within the last 100msec. ,sum(nvl(ERAB_IN_SESSION_TIME_QCI2,0)) M8006C182 --This measurement provides the aggregated in-session activity time in seconds for all E-RABs with QCI2 characteristics. The E-RAB is said to be in session if any user data has been transferred in UL or DL direction within the last 100msec.
,sum(nvl(ERAB_IN_SESSION_TIME_QCI3,0)) M8006C183 --This measurement provides the aggregated in-session activity time in seconds for all E-RABs with QCI3 characteristics. The E-RAB is said to be in session if any user data has been transferred in UL or DL direction within the last 100msec.
,sum(nvl(ERAB_IN_SESSION_TIME_QCI4,0)) M8006C184 --This measurement provides the aggregated in-session activity time in seconds for all E-RABs with QCI4 characteristics. The E-RAB is said to be in session if any user data has been transferred in UL or DL direction within the last 100msec.
,sum(nvl(ERAB_IN_SESSION_TIME_NON_GBR,0)) M8006C185 --This measurement provides the aggregated
8
in-session activity time in seconds for all E-RABs with non-GBR (QCI5..9) characteristics. The E-RAB is said to be in session if any user data has been transferred in UL or DL direction within the last 100msec. from
NOKLTE_PS_LEPSB_lncel_hour PMRAW where
period_start_time between to_date(&1,'yyyymmddHH24') and to_date(&2,'yyyymmddHH24') ---- to_char(period_start_time,'yyyymmdd') >= to_char(SYSDATE-1,'yyyymmdd') -- and to_char(period_start_time,'yyyymmdd') <= to_char(SYSDATE-1,'yyyymmdd') --AND PERIOD_DURATION=15 group by
to_char(period_start_time,'yyyymmdd'),LNCEL_ID,to_char(period_start_time,'yyyymmdd')||LNCEL_ID )M8006,( select
to_char(period_start_time,'yyyymmdd') sdate ,LNCEL_ID
,to_char(period_start_time,'yyyymmdd')||LNCEL_ID cel_key_id ,sum(nvl(REJ_RRC_CONN_RE_ESTAB,0)) M8008C0 --The number of rejected RRC Connection re-establishments.
,sum(nvl(RRC_PAGING_REQUESTS,0)) M8008C1 --The number of RRC paging requests (records). ,sum(nvl(DISC_RRC_PAGING,0)) M8008C2 --The number of discarded RRC paging requests (records). ,sum(nvl(RRC_PAGING_MESSAGES,0)) M8008C3 --The number of transmitted RRC paging messages. ,sum(nvl(RRC_CON_RE_ESTAB_ATT,0)) M8008C4 --The number of attempted RRC Connection Re-establishment procedures.
,sum(nvl(RRC_CON_RE_ESTAB_SUCC,0)) M8008C5 --The number of successful RRC Connection Re-establishment procedures.
,sum(nvl(RRC_CON_RE_ESTAB_ATT_HO_FAIL,0)) M8008C6 --The number of RRC Connection Re-establishment attempts per cause (Handover Failure). ,sum(nvl(RRC_CON_RE_ESTAB_SUCC_HO_FAIL,0)) M8008C7 --The number of successful RRC Connection Re-establishment procedures per cause (Handover Failure). ,sum(nvl(RRC_CON_RE_ESTAB_ATT_OTHER,0)) M8008C8 --The number of RRC Connection Re-establishment attempts per cause (Other failure). ,sum(nvl(RRC_CON_RE_ESTAB_SUCC_OTHER,0)) M8008C9 --The number of successful RRC Connection Re-establishment procedures per cause (Other Failure). ,sum(nvl(REPORT_CGI_REQ,0)) M8008C10 --This counter provides the total number of attempts to retrieve the CGI of a neighbor cell from UE. ,sum(nvl(SUCC_CGI_REPORTS,0)) M8008C11 --This counter provides the number of CGI measurement reports received from UE. from
NOKLTE_PS_LRRC_lncel_hour PMRAW where
period_start_time between to_date(&1,'yyyymmddHH24') and to_date(&2,'yyyymmddHH24') --- to_char(period_start_time,'yyyymmdd') >= to_char(SYSDATE-1,'yyyymmdd')
-- and to_char(period_start_time,'yyyymmdd') <= to_char(SYSDATE-1,'yyyymmdd') --AND PERIOD_DURATION=15
9
group by
to_char(period_start_time,'yyyymmdd'),LNCEL_ID,to_char(period_start_time,'yyyymmdd')||LNCEL_ID )M8008,( select
to_char(period_start_time,'yyyymmdd') sdate ,LNCEL_ID
,to_char(period_start_time,'yyyymmdd')||LNCEL_ID cel_key_id
,sum(nvl(TOT_NOT_START_HO_PREP,0)) M8009C0 --The number of not started Handover preparations. The RRM receives an RRC Measurement Report (UE -; eNB), but the RRM decides not to start a Handover preparation phase. No target cell list will be handed over to the mobility management (MM) unit.
,sum(nvl(TOT_HO_DECISION,0)) M8009C1 --The number of positive Handover decisions. In case of a positive Handover decision, the RRM transmits a target cell list to the mobility management (MM) unit. ,sum(nvl(INTRA_ENB_HO_PREP,0)) M8009C2 --The number of Intra-eNB Handover preparations. ,sum(nvl(FAIL_ENB_HO_PREP_AC,0)) M8009C3 --The number of failed Intra-eNB Handover preparations due to Admission Control. Includes failures to set up data forwarding in the target cell. ,sum(nvl(FAIL_ENB_HO_PREP_OTH,0)) M8009C5 --The number of failed Intra-eNB Handover preparations due to other reasons.
,sum(nvl(ATT_INTRA_ENB_HO,0)) M8009C6 --The number of Intra-eNB Handover attempts. ,sum(nvl(SUCC_INTRA_ENB_HO,0)) M8009C7 --The number of successful Intra-eNB Handover completions. ,sum(nvl(ENB_INTRA_HO_FAIL,0)) M8009C8 --The number of Intra-eNB Handover failures due to the guarding timer THOoverall.
,sum(nvl(ENB_HO_DROP_RLFAIL,0)) M8009C12 --The number of Intra-eNB Handover drops due to Radio Link Failure.
,sum(nvl(ENB_HO_DROP_OTHERFAIL,0)) M8009C13 --The number of Intra-eNB Handover drops due to other failures.
from
NOKLTE_PS_LIANBHO_lncel_hour PMRAW where
period_start_time between to_date(&1,'yyyymmddHH24') and to_date(&2,'yyyymmddHH24') --- to_char(period_start_time,'yyyymmdd') >= to_char(SYSDATE-1,'yyyymmdd') -- and to_char(period_start_time,'yyyymmdd') <= to_char(SYSDATE-1,'yyyymmdd') --AND PERIOD_DURATION=15 group by
to_char(period_start_time,'yyyymmdd'),LNCEL_ID,to_char(period_start_time,'yyyymmdd')||LNCEL_ID )M8009,( select
to_char(period_start_time,'yyyymmdd') sdate ,LNCEL_ID
,to_char(period_start_time,'yyyymmdd')||LNCEL_ID cel_key_id
,avg(nvl(PRB_USED_PUSCH,0)) M8011C50--Total number of used PRB's for PUSCH scheduling over the measurement period.
,avg(nvl(PRB_USED_PDSCH,0)) M8011C54 --Total number of used PRB's for PDSCH scheduling over the measurement period. from
10
NOKLTE_PS_LCELLR_lncel_hour PMRAW where
period_start_time between to_date(&1,'yyyymmddHH24') and to_date(&2,'yyyymmddHH24') --- to_char(period_start_time,'yyyymmdd') >= to_char(SYSDATE-1,'yyyymmdd') -- and to_char(period_start_time,'yyyymmdd') <= to_char(SYSDATE-1,'yyyymmdd') --AND PERIOD_DURATION=15 group by
to_char(period_start_time,'yyyymmdd'),LNCEL_ID,to_char(period_start_time,'yyyymmdd')||LNCEL_ID
) M8011 ,( select
to_char(period_start_time,'yyyymmdd') sdate ,LNCEL_ID
,to_char(period_start_time,'yyyymmdd')||LNCEL_ID cel_key_id ,sum(nvl(PDCP_SDU_VOL_UL,0)) M8012C19 --The measurement gives an indication of the eUu interface traffic load by reporting the total received PDCP SDU-related traffic volume. ,sum(nvl(PDCP_SDU_VOL_DL,0)) M8012C20 --The measurement gives an indication of the eUu interface traffic load by reporting the total transmitted PDCP SDU-related traffic volume. ,round(avg(decode(PDCP_DATA_RATE_MEAN_UL,0,NULL,PDCP_DATA_RATE_MEAN_UL)),2) M8012C23 --The measurement gives indication of the eUu interface traffic load by reporting Mean UL PDCP traffic throughput
,round(avg(decode(PDCP_DATA_RATE_MEAN_DL,0,NULL,PDCP_DATA_RATE_MEAN_DL)),2) M8012C26 --The measurement gives indication of the eUu interface traffic load by reporting Mean DL PDCP traffic throughput.
from
NOKLTE_PS_LCELLT_lncel_hour PMRAW where
period_start_time between to_date(&1,'yyyymmddHH24') and to_date(&2,'yyyymmddHH24') --- to_char(period_start_time,'yyyymmdd') >= to_char(SYSDATE-1,'yyyymmdd') -- and to_char(period_start_time,'yyyymmdd') <= to_char(SYSDATE-1,'yyyymmdd') --AND PERIOD_DURATION=15 group by
to_char(period_start_time,'yyyymmdd'),LNCEL_ID,to_char(period_start_time,'yyyymmdd')||LNCEL_ID )M8012,( select
to_char(period_start_time,'yyyymmdd') sdate ,LNCEL_ID
,to_char(period_start_time,'yyyymmdd')||LNCEL_ID cel_key_id
,sum(nvl(SIGN_CONN_ESTAB_COMP,0)) M8013C5 --The number of Signaling Connection Establishment completions with the UE target to be in the ECM-CONNECTED state.
11