诺西LTE指标提取SQL语句20160801 下载本文

additional EPS bearer setup attempts for GBR DRBs of QCI3 characteristics.

,sum(nvl(EPS_BEARER_STP_ATT_ADD_QCI_4,0)) M8006C167 --This measurement provides the number of 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

32

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 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. ,sum(nvl(SUM_SIMUL_ERAB_QCI_1,0)) M8006C45 ,sum(nvl(SUM_SIMUL_ERAB_QCI_2,0)) M8006C46 ,sum(nvl(SUM_SIMUL_ERAB_QCI_3,0)) M8006C47 ,sum(nvl(SUM_SIMUL_ERAB_QCI_4,0)) M8006C48 ,sum(nvl(SUM_SIMUL_ERAB_QCI_5,0)) M8006C49 ,sum(nvl(SUM_SIMUL_ERAB_QCI_6,0)) M8006C50 ,sum(nvl(SUM_SIMUL_ERAB_QCI_7,0)) M8006C51 ,sum(nvl(SUM_SIMUL_ERAB_QCI_8,0)) M8006C52 ,sum(nvl(SUM_SIMUL_ERAB_QCI_9,0)) M8006C53 ,sum(nvl(DENOM_SUM_SIMUL_ERAB,0)) M8006C54 from

NOKLTE_PS_LEPSB_MNC1_RAW PMRAW where

period_start_time between to_date(&1,'yyyymmddHH24mi') and to_date(&2,'yyyymmddHH24mi') ---- to_char(period_start_time,'yyyymmddHH24mi') >= to_char(SYSDATE-1,'yyyymmddHH24mi') -- and to_char(period_start_time,'yyyymmddHH24mi') <= to_char(SYSDATE-1,'yyyymmddHH24mi') --AND PERIOD_DURATION=15 group by

to_char(period_start_time,'yyyymmddHH24mi'),LNCEL_ID,to_char(period_start_time,'yyyymmddHH24mi')||LNCEL_ID )M8006,( select

to_char(period_start_time,'yyyymmddHH24mi') sdatetime ,LNCEL_ID ,to_char(period_start_time,'yyyymmddHH24mi')||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).

33

,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_MNC1_RAW PMRAW where

period_start_time between to_date(&1,'yyyymmddHH24mi') and to_date(&2,'yyyymmddHH24mi') --- to_char(period_start_time,'yyyymmddHH24mi') >= to_char(SYSDATE-1,'yyyymmddHH24mi')

-- and to_char(period_start_time,'yyyymmddHH24mi') <= to_char(SYSDATE-1,'yyyymmddHH24mi') --AND PERIOD_DURATION=15 group by

to_char(period_start_time,'yyyymmddHH24mi'),LNCEL_ID,to_char(period_start_time,'yyyymmddHH24mi')||LNCEL_ID )M8008,( select

to_char(period_start_time,'yyyymmddHH24mi') sdatetime ,LNCEL_ID

,to_char(period_start_time,'yyyymmddHH24mi')||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_MNC1_RAW PMRAW where

period_start_time between to_date(&1,'yyyymmddHH24mi') and to_date(&2,'yyyymmddHH24mi') --- to_char(period_start_time,'yyyymmddHH24mi') >= to_char(SYSDATE-1,'yyyymmddHH24mi') -- and to_char(period_start_time,'yyyymmddHH24mi') <= to_char(SYSDATE-1,'yyyymmddHH24mi')

34

--AND PERIOD_DURATION=15 group by

to_char(period_start_time,'yyyymmddHH24mi'),LNCEL_ID,to_char(period_start_time,'yyyymmddHH24mi')||LNCEL_ID )M8009,( select

to_char(period_start_time,'yyyymmddHH24mi') sdatetime ,LNCEL_ID

,to_char(period_start_time,'yyyymmddHH24mi')||LNCEL_ID cel_key_id ,sum(nvl(PRB_USED_PUSCH,0)) M8011C50--Total number of used PRB's for PUSCH scheduling over the measurement period.

,sum(nvl(PRB_USED_PDSCH,0)) M8011C54 --Total number of used PRB's for PDSCH scheduling over the measurement period.

,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_1, 0)) M8011C12 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of <= 10% is updated to this counter.

,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_2, 0)) M8011C13 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 10% < PRBUTIL < = 20% is updated to this counter.

,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_3, 0)) M8011C14 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 20% < PRBUTIL < = 30% is updated to this counter.

,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_4, 0)) M8011C15 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 30% < PRBUTIL < = 40% is updated to this counter.

,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_5, 0)) M8011C16 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 40% < PRBUTIL < = 50% is updated to this counter. ,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_6, 0)) M8011C17 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 50% < PRBUTIL < = 60% is updated to this counter. ,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_7, 0)) M8011C18 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 60% < PRBUTIL < = 70% is updated to this counter. ,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_8, 0)) M8011C19 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 70% < PRBUTIL < = 80% is updated to this counter.

,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_9, 0)) M8011C20 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 80% < PRBUTIL < = 90% is updated to this counter.

,sum(nvl(UL_PRB_UTIL_TTI_LEVEL_10, 0)) M8011C21 --The Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI. Utilization in the range of 90% < PRBUTIL < = 100% is updated to this counter.

,min(nvl(UL_PRB_UTIL_TTI_MIN, 0)) M8011C22 --The minimum value of the UL Physical Resource Block (PRB) utilization per TTI. The utilization is defined by the rate of used PRB per TTI.

35