诺西LTE指标提取SQL语句20160801-南京廖华答案网

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

reached the ECM-CONNECTED state.

,sum(nvl(SIGN_EST_F_RRCCOMPL_ERROR,0)) M8013C7 --The number of Signaling Connection Establishment failures due to the Erroneous or incomplete RRC CONNECTION SETUP COMPLETE message. The UE has not reached the ECM-CONNECTED state.

,sum(nvl(SIGN_CONN_ESTAB_FAIL_RRMRAC,0)) M8013C8 --The number of Signaling Connection Establishment failures due to Rejection by RRM RAC. The UE has not reached the ECM-CONNECTED state. ,sum(nvl(EPC_INIT_TO_IDLE_UE_NORM_REL,0)) M8013C9 --The number of EPC-initiated transitions to the ECM-IDLE state due to a Normal release by the UE .

,sum(nvl(EPC_INIT_TO_IDLE_DETACH,0)) M8013C10 --The number of EPC-initiated transitions to the ECM-IDLE state due to the Detach procedure by the UE or the MME .

,sum(nvl(EPC_INIT_TO_IDLE_RNL,0)) M8013C11 --The number of EPC initiated transitions to ECM-IDLE state due to Radio Network Layer cause. The UE-associated logical S1-connection is released. ,sum(nvl(EPC_INIT_TO_IDLE_OTHER,0)) M8013C12 --The number of EPC-initiated transitions to the ECM-IDLE state due to Other causes.

,sum(nvl(ENB_INIT_TO_IDLE_NORM_REL,0)) M8013C13 --The number of eNB-initiated transitions from the ECM-CONNECTED to ECM-IDLE state due to User Inactivity or Redirect. The UE-associated logical S1-connection is released.

,sum(nvl(ENB_INIT_TO_IDLE_RNL,0)) M8013C15 --The number of eNB initiated transitions from the ECM-CONNECTED to ECM-IDLE state when the Radio Connection to the UE is lost. The UE-associated logical S1-connection is released.

,sum(nvl(ENB_INIT_TO_IDLE_OTHER,0)) M8013C16 --The number of eNB-initiated transitions from the ECM-CONNECTED to ECM-IDLE state due to Other causes than User Inactivity, Redirect or Radio Connection Lost.

,sum(nvl(SIGN_CONN_ESTAB_ATT_MO_S,0)) M8013C17 --The number of Signaling Connection Establishment attempts for mobile originated signaling. From UE's point of view, the transition from ECM-IDLE to ECM-CONNECTED has started. ,sum(nvl(SIGN_CONN_ESTAB_ATT_MT,0)) M8013C18 --The number of Signaling Connection Establishment attempts for mobile terminated connections. From UE's point of view, the transition from ECM-IDLE to ECM-CONNECTED is started. ,sum(nvl(SIGN_CONN_ESTAB_ATT_MO_D,0)) M8013C19 --The number of Signaling Connection Establishment attempts for mobile originated data connections. From UE's point of view, the transition from ECM-IDLE to ECM-CONNECTED is started. ,sum(nvl(SIGN_CONN_ESTAB_ATT_OTHERS,0)) M8013C20 --The number of Signaling Connection Establishment attempts due to other reasons. From UE's point of view, the transition from ECM-IDLE to ECM-CONNECTED is started. ,sum(nvl(SIGN_CONN_ESTAB_ATT_EMG,0)) M8013C21 --Number of Signalling Connection Establishment attempts for emergency calls

,sum(nvl(SUBFRAME_DRX_ACTIVE_UE,0)) M8013C24 --The number of subframes, when UE is DRX Active. ,sum(nvl(SUBFRAME_DRX_SLEEP_UE,0)) M8013C25 --The number of subframes, when UE is DRX Sleep (i.e. not DRX Active).

,sum(nvl(SIGN_CONN_ESTAB_COMP_EMG,0)) M8013C26 --The number of Signalling Connection Establishment completions for emergency calls

,sum(nvl(SIGN_CONN_ESTAB_FAIL_RB_EMG,0)) M8013C27 --The number of Signalling Connection Establishment failures for emergency calls due to missing RB (Radio Bearer) resources

,sum(nvl(PRE_EMPT_UE_CONTEXT_NON_GBR,0)) M8013C28 --This measurement provides the number of UE contexts being released due to lack of radio resources.

,sum(nvl(SIGN_CONN_ESTAB_ATT_HIPRIO,0)) M8013C31 ,sum(nvl(SIGN_CONN_ESTAB_ATT_DEL_TOL,0)) M8013C34 ,lnbts.co_object_instance enb_id ,lncel.co_object_instance cell_id ,ip.ipno_mpia_8 bts_ip

,lnbts.co_sys_version bts_version ,Trim(lnbts.co_name) bts_name ,Trim(lncel.co_name) cel_name from

NOKLTE_PS_LUEST_MNC1_RAW PMRAW,ctp_common_objects lnbts,ctp_common_objects lncel,c_lte_ipno ip 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 PMRAW.LNCEL_ID=lncel.co_gid and PMRAW.lnbts_id=lnbts.co_gid

and ip.ipno_bts_id=lnbts.co_object_instance --AND PERIOD_DURATION=15 group by

to_char(period_start_time,'yyyymmddHH24mi'),MRBTS_ID,LNBTS_ID,LNCEL_ID,to_char(period_start_time,'yyyymmddHH24mi')||LNCEL_ID

,lnbts.co_object_instance,lncel.co_object_instance,ip.ipno_mpia_8,lnbts.co_sys_version,Trim(lnbts.co_name),Trim(lncel.co_name) )M8013,( select

to_char(period_start_time,'yyyymmddHH24mi') sdatetime ,LNCEL_ID ,to_char(period_start_time,'yyyymmddHH24mi')||LNCEL_ID cel_key_id ,sum(nvl(INTER_ENB_HO_PREP,0)) M8014C0 --The number of Inter-eNB X2-based Handover preparations. The Mobility management (MM) receives a list with target cells from the RRM and decides to start an Inter-eNB X2-based Handover.

,sum(nvl(FAIL_ENB_HO_PREP_TIME,0)) M8014C2 --The number of failed Inter-eNB X2-based Handover preparations due to timer TX2RELOCprep. ,sum(nvl(FAIL_ENB_HO_PREP_AC,0)) M8014C3 --The number of failed Inter-eNB X2-based Handover preparations due to the target eNB's admission control reasons.

,sum(nvl(FAIL_ENB_HO_PREP_OTHER,0)) M8014C5 --The number of failed Inter-eNB X2-based Handover preparations due to the target eNB's other reasons.

,sum(nvl(ATT_INTER_ENB_HO,0)) M8014C6 --The number of Inter-eNB X2-based Handover attempts.

,sum(nvl(SUCC_INTER_ENB_HO,0)) M8014C7 --The number of successful Inter-eNB X2-based Handover completions.

,sum(nvl(INTER_ENB_HO_FAIL,0)) M8014C8 --Number of Inter eNB Handover failures due to expiration of guarding timer TX2RELOCoverall

,sum(nvl(INTER_ENB_S1_HO_PREP,0)) M8014C14 --The number of Inter eNB S1-based Handover

preparations

,sum(nvl(INTER_S1_HO_PREP_FAIL_TIME,0)) M8014C15 --The number of failed Inter eNB S1-based Handover preparations due to the expiry of the guarding timer TS1RELOCprep.

,sum(nvl(INTER_S1_HO_PREP_FAIL_NORR,0)) M8014C16 --The number of failed Inter eNB S1-based Handover preparations with cause No Radio Resources Available in Target Cell.

,sum(nvl(INTER_S1_HO_PREP_FAIL_OTHER,0)) M8014C17 --The number of failed Inter eNB S1-based Handover preparations due to the reception of an S1AP: HANDOVER PREPARATION FAILURE message with a cause other than No Radio Resources Available in Target Cell.

,sum(nvl(INTER_ENB_S1_HO_ATT,0)) M8014C18 --The number of Inter eNB S1-based Handover attempts

,sum(nvl(INTER_ENB_S1_HO_SUCC,0)) M8014C19 --The number of successful Inter eNB S1-based Handover completions

,sum(nvl(INTER_ENB_S1_HO_FAIL,0)) M8014C20 --The number of Inter eNB S1-based Handover failures from

NOKLTE_PS_LIENBHO_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 )M8014, (

select

to_char(period_start_time,'yyyymmddHH24mi') sdatetime ,LNCEL_ID ,to_char(period_start_time,'yyyymmddHH24mi')||LNCEL_ID cel_key_id ,sum(nvl(INTRA_HO_SUCC_NB,0)) M8015C2 --The number of successful Intra-eNB Handover completions per neighbour cell relationship. ,sum(nvl(INTER_HO_SUCC_NB,0)) M8015C9 --The number of successful Inter eNB Handover completions per neighbour cell relationship ,SUM(NVL(INTER_HO_PREP_FAIL_OTH_NB,0)) M8015C5 --The number of failed Inter eNB Handover preparations per cause per neighbour cell relationship ,SUM(NVL(INTER_HO_PREP_FAIL_TIME_NB,0)) M8015C6 --The number of failed Inter eNB Handover preparations per neighbour cell relationship due to the expiration of the respective guarding timer.

,SUM(NVL(INTER_HO_PREP_FAIL_AC_NB,0)) M8015C7 --The number of failed Inter eNB Handover preparations per neighbour cell relationship due to failures in the HO preparation on the target side

,SUM(NVL(INTER_HO_ATT_NB,0)) M8015C8 --The number of Inter eNB Handover attempts per neighbour cell relationship

from

NOKLTE_PS_LNCELHO_DMNC1_RAW PMRAW where

period_start_time between to_date(&1,'yyyymmddHH24mi') and to_date(&2,'yyyymmddHH24mi')

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

to_char(period_start_time,'yyyymmddHH24mi') sdatetime ,LNCEL_ID

,to_char(period_start_time,'yyyymmddHH24mi')||LNCEL_ID cel_key_id ,sum(nvl(CSFB_REDIR_CR_ATT,0)) M8016C11 --The number of CS Fallback attempts with redirection via the RRC Connection Release

,sum(nvl(CSFB_REDIR_CR_CMODE_ATT,0)) M8016C12 --The number of CS Fallback attempts (UE in Connected Mode) with redirection via the RRC Connection Release ,sum(nvl(CSFB_REDIR_CR_EMERGENCY_ATT,0)) M8016C13 --The number of CS Fallback attempts for emergency call reason with redirection via the RRC Connection Release ,sum(nvl(ISYS_HO_PREP,0)) M8016C14 --Number of Inter System Handover preparations. ,sum(nvl(ISYS_HO_PREP_FAIL_TIM,0)) M8016C15 --Number of failed Inter System Handover preparations due to expiration of guarding timer.

,sum(nvl(ISYS_HO_PREP_FAIL_AC,0)) M8016C16 --Number of failed Inter System Handover preparations due to admission control of target cell. ,sum(nvl(ISYS_HO_PREP_FAIL_OTH,0)) M8016C17 --Number of failed Inter System Handover preparations due to other reasons of target cell. ,sum(nvl(ISYS_HO_ATT,0)) M8016C21 --Number of Inter System Handover attempts. ,sum(nvl(ISYS_HO_SUCC,0)) M8016C23 --Number of successful Inter System Handover completions. ,sum(nvl(ISYS_HO_FAIL,0)) M8016C25 --Number of failed Inter System Handover attempts. ,sum(nvl(NACC_TO_GSM_ATT,0)) M8016C26 --This measurement provides the number of NACC from LTE to GSM attempts ,sum(nvl(NACC_TO_GSM_SUCC,0)) M8016C27 --This measurement provides the number of successful NACC from LTE to GSM completions ,sum(nvl(NACC_TO_GSM_FAIL,0)) M8016C28 --This measurement provides the number of failed NACC from LTE to GSM.

,sum(nvl(ISYS_HO_UTRAN_SRVCC_ATT,0)) M8016C29 --This measurement provides the number of Inter System Handover attempts to UTRAN with SRVCC (Single Radio Voice Call Continuity, 3GPP TS 23.216). ,sum(nvl(ISYS_HO_UTRAN_SRVCC_SUCC,0)) M8016C30 --This measurement provides the number of successful Inter System Handover completions to UTRAN with SRVCC (Single Radio Voice Call Continuity, 3GPP TS 23.216).

,sum(nvl(ISYS_HO_UTRAN_SRVCC_FAIL,0)) M8016C31 --This measurement provides the number of failed Inter System Handover attempts to UTRAN with SRVCC (Single Radio Voice Call Continuity, 3GPP TS 23.216). ,sum(nvl(CSFB_PSHO_UTRAN_ATT,0)) M8016C32 --This measurement provides the number of CS Fallback attempts to UTRAN with PS Handover (Circuit Switched Fallback in Evolved Packet System, 3GPP TS 23.272). ,sum(nvl(ISYS_HO_GERAN_SRVCC_ATT,0)) M8016C33 --This measurement provides the number of Inter System Handover attempts to GERAN with SRVCC (Single Radio Voice Call Continuity, 3GPP TS 23.216).

Word文档下载：诺西LTE指标提取SQL语句20160801.doc

搜索更多:诺西LTE指标提取SQL语句20160801