Period Start Time WS: RRC Setup Success Rate eRAB Setup Success Rate (All Services)
Period Start Time WS: RRC Setup Success Rate eRAB Setup Success Rate (All Services)
Period Start Time WS: RRC Setup Success Rate eRAB Setup Success Rate (All Services)
Page 1
Data
Page 2
Data
Page 3
Data
Page 4
Data
Page 5
Data
Cell Uplink Average Throughput Downlink Latency Total Volume DL Total Volume UL
CELLUPLINKAVERAGETHROUGDOWNLINKLATEN TOTALVOLUMEDTOTALVOLUMEU
2,189.42 29.23 79,136,472.54 4,834,098.30
1,947.23 24.39 22,219,527.95 1,433,621.89
1,992.49 18.26 23,448,369.82 1,410,873.85
1,936.74 16.32 4,959,506.45 307,195.63
Page 6
Data
CSFB Success RateAvg active users per cellMax active users per cellUplinkLatency Unavailable
CSFBSUCCESSRALTE_717A LTE_718A UPLINKLATENCUNAVAILABL
99.85 0.00 0.17
99.85 0.00 0.63
99.86 0.00 0.44
99.89 0.00 0.48
Page 7
Data
Page 8
Data
UserDownlinkAverageThroughput3 UserUplinkAverageThroughput3
USERDOWNLINKAVERAGETHROUGHUSERUPLINKAVERAGETHROUGHPUT3
23,349.55 2,588.90
25,607.15 2,371.18
31,599.85 2,467.74
34,310.02 2,468.78
Page 9
Documentation
Page 10
Documentation
Page 11
Report Execution
Page 12
Report Execution
Page 13
Report Execution
Page 14
Report Execution
Page 15
Report Execution
Page 16
Report Execution
Page 17
Report Execution
Page 18
Report Execution
Page 19
Report Execution
Page 20
Report Execution
Page 21
Report Execution
Page 22
Report Execution
Page 23
Report Execution
Page 24
Report Execution
Page 25
Report Execution
Note Sql
executing sql extra step
create global temporary table jf_topo_vloflnbts_0310492221 on commit preserve rows as
SELECT
"plmn".co_gid plmn_gid,
"vloflnbtsparent".co_gid vloflnbtsparent_gid,
"vloflnbtsparent".co_mr_gid vloflnbtsparent_mr_gid,
"lnbts".co_gid lnbts_gid,
"lnbts".co_mr_gid lnbts_mr_gid,
decode(substr(bts_type.co_sys_version,1,3),'FLF','FlexiZoneMicroBTS','TLF','FlexiZoneMicroBTS','FL
FROM
utp_common_objects "plmn",
utp_common_objects "vloflnbtsparent",
utp_common_objects "lnbts",
ctp_common_objects bts_type
WHERE
"plmn".co_oc_id = 16
AND "vloflnbtsparent".co_parent_gid = "plmn".co_gid
AND ( "vloflnbtsparent".co_oc_id = 3128 or "vloflnbtsparent".co_oc_id = 739 )
AND "lnbts".co_parent_gid = "vloflnbtsparent".co_gid
AND "lnbts".co_oc_id = 3129
AND "lnbts".co_gid = bts_type.co_gid(+)
creating tmp table: jf_LUEST2_0388571371
create global temporary table jf_LUEST2_0388571371 on commit preserve rows as
select
a.period_start_time,
g.ws,
SUM(SIGN_CONN_ESTAB_COMP) SIGN_CONN_ESTAB_COMP,
SUM(SIGN_CONN_ESTAB_ATT_MO_S) SIGN_CONN_ESTAB_ATT_MO_S,
SUM(SIGN_CONN_ESTAB_ATT_MT) SIGN_CONN_ESTAB_ATT_MT,
SUM(SIGN_CONN_ESTAB_ATT_MO_D) SIGN_CONN_ESTAB_ATT_MO_D,
SUM(SIGN_CONN_ESTAB_ATT_OTHERS) SIGN_CONN_ESTAB_ATT_OTHERS,
SUM(SIGN_CONN_ESTAB_ATT_EMG) SIGN_CONN_ESTAB_ATT_EMG,
SUM(SIGN_CONN_ESTAB_ATT_HIPRIO) SIGN_CONN_ESTAB_ATT_HIPRIO,
SUM(SIGN_CONN_ESTAB_ATT_DEL_TOL) SIGN_CONN_ESTAB_ATT_DEL_TOL,
SUM(S1_SIGN_CONN_ESTAB_ATT_UE) S1_SIGN_CONN_ESTAB_ATT_UE,
SUM(S1_SIGN_CONN_ESTAB_SUCC_UE) S1_SIGN_CONN_ESTAB_SUCC_UE,
Page 26
Report Execution
SUM(UE_CTX_SETUP_ATT_CSFB) UE_CTX_SETUP_ATT_CSFB,
SUM(UE_CTX_SETUP_SUCC_CSFB) UE_CTX_SETUP_SUCC_CSFB
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t.vloflnbtsparent_gid vloflnbtsparent_gid,
t.lnbts_gid lnbts_gid,
t.lnbts_type LNBTS_type,
g.ws ws,
SUM(SIGN_CONN_ESTAB_COMP) SIGN_CONN_ESTAB_COMP,
SUM(SIGN_CONN_ESTAB_ATT_MO_S) SIGN_CONN_ESTAB_ATT_MO_S,
SUM(SIGN_CONN_ESTAB_ATT_MT) SIGN_CONN_ESTAB_ATT_MT,
SUM(SIGN_CONN_ESTAB_ATT_MO_D) SIGN_CONN_ESTAB_ATT_MO_D,
SUM(SIGN_CONN_ESTAB_ATT_OTHERS) SIGN_CONN_ESTAB_ATT_OTHERS,
SUM(SIGN_CONN_ESTAB_ATT_EMG) SIGN_CONN_ESTAB_ATT_EMG,
SUM(SIGN_CONN_ESTAB_ATT_HIPRIO) SIGN_CONN_ESTAB_ATT_HIPRIO,
SUM(SIGN_CONN_ESTAB_ATT_DEL_TOL) SIGN_CONN_ESTAB_ATT_DEL_TOL,
SUM(S1_SIGN_CONN_ESTAB_ATT_UE) S1_SIGN_CONN_ESTAB_ATT_UE,
SUM(S1_SIGN_CONN_ESTAB_SUCC_UE) S1_SIGN_CONN_ESTAB_SUCC_UE,
SUM(UE_CTX_SETUP_ATT_CSFB) UE_CTX_SETUP_ATT_CSFB,
SUM(UE_CTX_SETUP_SUCC_CSFB) UE_CTX_SETUP_SUCC_CSFB
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_luest_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
Page 27
Report Execution
Page 28
Report Execution
Page 29
Report Execution
SUM(ERAB_REL_ENB_RNL_INA) ERAB_REL_ENB_RNL_INA,
SUM(ERAB_REL_ENB_RNL_RED) ERAB_REL_ENB_RNL_RED,
SUM(ERAB_REL_ENB_RNL_RRNA) ERAB_REL_ENB_RNL_RRNA,
SUM(ERAB_REL_HO_PART) ERAB_REL_HO_PART,
SUM(ERAB_REL_EPC_PATH_SWITCH) ERAB_REL_EPC_PATH_SWITCH
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lepsb_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
creating tmp table: jf_LEPSB_2_0392126796
create global temporary table jf_LEPSB_2_0392126796 on commit preserve rows as
select
a.period_start_time,
g.ws,
SUM(RL70_eNB_drops) RL70_eNB_drops
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t.vloflnbtsparent_gid vloflnbtsparent_gid,
t.lnbts_gid lnbts_gid,
t.lnbts_type LNBTS_type,
g.ws ws,
SUM(enb_eps_bearer_rel_req_rnl + ENB_EPS_BEARER_REL_REQ_TNL + enb_eps_bearer_re
from
( select distinct g.ws_gid, g.ws from (select
Page 30
Report Execution
Page 31
Report Execution
SUM(INTER_ENB_S1_HO_SUCC) INTER_ENB_S1_HO_SUCC
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lienbho_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
creating tmp table: jf_LHO2_0335991693
create global temporary table jf_LHO2_0335991693 on commit preserve rows as
select
a.period_start_time,
g.ws,
SUM(HO_INTFREQ_ATT) HO_INTFREQ_ATT,
SUM(HO_INTFREQ_SUCC) HO_INTFREQ_SUCC
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t.vloflnbtsparent_gid vloflnbtsparent_gid,
t.lnbts_gid lnbts_gid,
t.lnbts_type LNBTS_type,
g.ws ws,
SUM(HO_INTFREQ_ATT) HO_INTFREQ_ATT,
SUM(HO_INTFREQ_SUCC) HO_INTFREQ_SUCC
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
Page 32
Report Execution
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lho_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
creating tmp table: jf_LIANBHO2_0330085056
create global temporary table jf_LIANBHO2_0330085056 on commit preserve rows as
select
a.period_start_time,
g.ws,
SUM(ATT_INTRA_ENB_HO) ATT_INTRA_ENB_HO,
SUM(SUCC_INTRA_ENB_HO) SUCC_INTRA_ENB_HO
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t.vloflnbtsparent_gid vloflnbtsparent_gid,
t.lnbts_gid lnbts_gid,
t.lnbts_type LNBTS_type,
g.ws ws,
SUM(ATT_INTRA_ENB_HO) ATT_INTRA_ENB_HO,
SUM(SUCC_INTRA_ENB_HO) SUCC_INTRA_ENB_HO
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lianbho_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
Page 33
Report Execution
Page 34
Report Execution
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
creating tmp table: jf_LCELAV2_0397483068
create global temporary table jf_LCELAV2_0397483068 on commit preserve rows as
select
a.period_start_time,
g.ws,
SUM(SAMPLES_CELL_AVAIL) SAMPLES_CELL_AVAIL,
SUM(DENOM_CELL_AVAIL) DENOM_CELL_AVAIL
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t.vloflnbtsparent_gid vloflnbtsparent_gid,
t.lnbts_gid lnbts_gid,
t.lnbts_type LNBTS_type,
g.ws ws,
SUM(SAMPLES_CELL_AVAIL) SAMPLES_CELL_AVAIL,
SUM(DENOM_CELL_AVAIL) DENOM_CELL_AVAIL
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lcelav_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
Page 35
Report Execution
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
creating tmp table: jf_LCELLR2_0326063711
create global temporary table jf_LCELLR2_0326063711 on commit preserve rows as
select
a.period_start_time,
g.ws,
AVG(UL_PRB_UTIL_TTI_MEAN) UL_PRB_UTIL_TTI_MEAN,
AVG(DL_PRB_UTIL_TTI_MEAN) DL_PRB_UTIL_TTI_MEAN
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t.vloflnbtsparent_gid vloflnbtsparent_gid,
t.lnbts_gid lnbts_gid,
t.lnbts_type LNBTS_type,
g.ws ws,
AVG(UL_PRB_UTIL_TTI_MEAN) UL_PRB_UTIL_TTI_MEAN,
AVG(DL_PRB_UTIL_TTI_MEAN) DL_PRB_UTIL_TTI_MEAN
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lcellr_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
Page 36
Report Execution
Page 37
Report Execution
SUM(IP_TPUT_VOL_DL_QCI_7) IP_TPUT_VOL_DL_QCI_7,
SUM(IP_TPUT_VOL_DL_QCI_8) IP_TPUT_VOL_DL_QCI_8,
SUM(IP_TPUT_VOL_DL_QCI_9) IP_TPUT_VOL_DL_QCI_9,
SUM(IP_TPUT_NET_TIME_UL_QCI6) IP_TPUT_NET_TIME_UL_QCI6,
SUM(IP_TPUT_NET_TIME_UL_QCI7) IP_TPUT_NET_TIME_UL_QCI7,
SUM(IP_TPUT_NET_TIME_UL_QCI8) IP_TPUT_NET_TIME_UL_QCI8,
SUM(IP_TPUT_NET_TIME_UL_QCI9) IP_TPUT_NET_TIME_UL_QCI9,
SUM(IP_TPUT_NET_TIME_DL_QCI6) IP_TPUT_NET_TIME_DL_QCI6,
SUM(IP_TPUT_NET_TIME_DL_QCI7) IP_TPUT_NET_TIME_DL_QCI7,
SUM(IP_TPUT_NET_TIME_DL_QCI8) IP_TPUT_NET_TIME_DL_QCI8,
SUM(IP_TPUT_NET_TIME_DL_QCI9) IP_TPUT_NET_TIME_DL_QCI9
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lcellt_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
creating tmp table: jf_LCELLT_ext2_0317308261
create global temporary table jf_LCELLT_ext2_0317308261 on commit preserve rows as
select
a.period_start_time,
g.ws,
SUM(PDCP_SDU_VOL_DL) PDCP_SDU_VOL_DL,
SUM(PDCP_SDU_VOL_UL) PDCP_SDU_VOL_UL
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
Page 38
Report Execution
t.vloflnbtsparent_gid vloflnbtsparent_gid,
t.lnbts_gid lnbts_gid,
t.lnbts_type LNBTS_type,
g.ws ws,
SUM(DECODE(ACTIVE_TTI_DL,NULL,0, PDCP_SDU_VOL_DL)) PDCP_SDU_VOL_DL,
SUM(DECODE(ACTIVE_TTI_UL,NULL,0, PDCP_SDU_VOL_UL)) PDCP_SDU_VOL_UL
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lcellt_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
creating tmp table: jf_LCELLD2_0397564382
create global temporary table jf_LCELLD2_0397564382 on commit preserve rows as
select
a.period_start_time,
g.ws,
AVG(PDCP_SDU_DELAY_DL_DTCH_MEAN) PDCP_SDU_DELAY_DL_DTCH_MEAN,
AVG(PDCP_SDU_DELAY_UL_DTCH_MEAN) PDCP_SDU_DELAY_UL_DTCH_MEAN,
AVG(CELL_LOAD_ACT_UE_AVG) CELL_LOAD_ACT_UE_AVG,
MAX(CELL_LOAD_ACT_UE_MAX) CELL_LOAD_ACT_UE_MAX
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t.vloflnbtsparent_gid vloflnbtsparent_gid,
t.lnbts_gid lnbts_gid,
t.lnbts_type LNBTS_type,
Page 39
Report Execution
g.ws ws,
AVG(PDCP_SDU_DELAY_DL_DTCH_MEAN) PDCP_SDU_DELAY_DL_DTCH_MEAN,
AVG(PDCP_SDU_DELAY_UL_DTCH_MEAN) PDCP_SDU_DELAY_UL_DTCH_MEAN,
AVG(CELL_LOAD_ACT_UE_AVG) CELL_LOAD_ACT_UE_AVG,
MAX(CELL_LOAD_ACT_UE_MAX) CELL_LOAD_ACT_UE_MAX
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
jf_topo_vloflnbts_0310492221 t,
noklte_ps_lcelld_lnbts_day p
where
g.ws_gid = t.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' )
and period_start_time >= to_date('2020/11/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/11/03 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t.lnbts_gid = p.lnbts_id
group by
trunc( p.period_start_time, 'dd' ),
t.vloflnbtsparent_gid,
t.lnbts_gid,
t.lnbts_type,
g.ws
)a
where
g.ws_gid = a.lnbts_gid and g.ws in ( '4G-DLK','4G-DNO','4G-GLI','4G-KTM' ) and a.ws = g.ws
group by
a.period_start_time,
g.ws
creating tmp table: jf_ALLTABLES_0324435672
create global temporary table jf_ALLTABLES_0324435672 on commit preserve rows as
select
period_start_time,
ws
from
(
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LCELAV2_0397483068
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LCELLD2_0397564382
)
UNION
Page 40
Report Execution
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LCELLR2_0326063711
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LCELLT2_0372492014
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LCELLT_ext2_0317308261
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LEPSB2_0392922551
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LEPSB_2_0392126796
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LHO2_0335991693
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LIANBHO2_0330085056
)
UNION
(
Page 41
Report Execution
select
period_start_time, TO_CHAR(ws) ws
from
jf_LIENBHO2_0392256421
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LISHO2_0388213285
)
UNION
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_LUEST2_0388571371
)
)p
report from tmp tables
select
ALLTABLES.period_start_time,
ALLTABLES.ws,
1 WS_DUMMY,
to_number(100*decode((LUEST2.SIGN_CONN_ESTAB_ATT_MO_S+LUEST2.SIGN_CONN_EST
to_number(100*decode((LEPSB2.EPS_BEARER_SETUP_ATTEMPTS),0,null,(LEPSB2.EPS_BEA
to_number(100*(decode((LUEST2.SIGN_CONN_ESTAB_ATT_MO_S+LUEST2.SIGN_CONN_ES
to_number(100*decode((nvl((LEPSB2.ERAB_REL_ENB+LEPSB2.ERAB_REL_HO_PART),0)+LEP
to_number(100*decode((LIENBHO2.INTER_ENB_HO_PREP),0,null,(LIENBHO2.SUCC_INTER_E
to_number(decode((LIENBHO2.INTER_ENB_S1_HO_PREP),0,null,(100*LIENBHO2.INTER_ENB
to_number(decode((LIANBHO2.ATT_INTRA_ENB_HO+LIENBHO2.ATT_INTER_ENB_HO+LIENB
to_number(100*decode(LHO2.HO_INTFREQ_ATT,0,null, LHO2.HO_INTFREQ_SUCC/LHO2.HO_
to_number(100*decode(LISHO2.ISYS_HO_ATT,0,null, LISHO2.ISYS_HO_SUCC/LISHO2.ISYS_H
to_number(100*decode((LCELAV2.DENOM_CELL_AVAIL),0,null,(LCELAV2.SAMPLES_CELL_AV
to_number((decode(10, 0, 0, LCELLR2.UL_PRB_UTIL_TTI_MEAN/10))) resourceblockutilizingrate
to_number((decode(10, 0, 0, LCELLR2.DL_PRB_UTIL_TTI_MEAN/10))) resourceblockutilizingrate
to_number(8*decode(LCELLT2.ACTIVE_TTI_DL,0,null, LCELLT_ext2.PDCP_SDU_VOL_DL/LCEL
to_number(8*decode(LCELLT2.ACTIVE_TTI_UL,0,null, LCELLT_ext2.PDCP_SDU_VOL_UL/LCEL
to_number((LCELLD2.PDCP_SDU_DELAY_DL_DTCH_MEAN)) downlinklatency,
to_number(decode(1000000, 0, 0, LCELLT2.PDCP_SDU_VOL_DL/1000000)) totalvolumedl,
to_number(decode(1000000, 0, 0, LCELLT2.PDCP_SDU_VOL_UL/1000000)) totalvolumeul,
to_number(100*decode(LUEST2.UE_CTX_SETUP_ATT_CSFB,0,null, LUEST2.UE_CTX_SETUP
to_number(lcelld2.cell_load_act_ue_avg) LTE_717a,
to_number(lcelld2.cell_load_act_ue_max) LTE_718a,
to_number(nvl((LCELLD2.PDCP_SDU_DELAY_UL_DTCH_MEAN),0)) uplinklatency,
to_number((100-100*decode((LCELAV2.DENOM_CELL_AVAIL),0,null,(LCELAV2.SAMPLES_CEL
to_number(decode(1000000, 0, 0, LCELLT2.PDCP_SDU_VOL_DL/1000000)+decode(1000000, 0
to_number(decode(1024, 0, 0, LCELLT2.PDCP_DATA_RATE_MAX_DL/1024)) celldownlinkmaxth
to_number(decode(1024, 0, 0, LCELLT2.PDCP_DATA_RATE_MAX_UL/1024)) celluplinkmaxthrou
Page 42
Report Execution
to_number(decode((LCELLT2.IP_TPUT_NET_TIME_DL_QCI6+LCELLT2.IP_TPUT_NET_TIME_D
to_number(decode((LCELLT2.IP_TPUT_NET_TIME_UL_QCI6+LCELLT2.IP_TPUT_NET_TIME_U
from
dual
,
jf_ALLTABLES_0324435672 ALLTABLES,
jf_LCELAV2_0397483068 LCELAV2,
jf_LCELLD2_0397564382 LCELLD2,
jf_LCELLR2_0326063711 LCELLR2,
jf_LCELLT2_0372492014 LCELLT2,
jf_LCELLT_ext2_0317308261 LCELLT_ext2,
jf_LEPSB2_0392922551 LEPSB2,
jf_LEPSB_2_0392126796 LEPSB_2,
jf_LHO2_0335991693 LHO2,
jf_LIANBHO2_0330085056 LIANBHO2,
jf_LIENBHO2_0392256421 LIENBHO2,
jf_LISHO2_0388213285 LISHO2,
jf_LUEST2_0388571371 LUEST2
where
1=1
and ALLTABLES.period_start_time = LCELAV2.period_start_time (+) and ALLTABLES.ws = LCEL
and ALLTABLES.period_start_time = LCELLD2.period_start_time (+) and ALLTABLES.ws = LCEL
and ALLTABLES.period_start_time = LCELLR2.period_start_time (+) and ALLTABLES.ws = LCEL
and ALLTABLES.period_start_time = LCELLT2.period_start_time (+) and ALLTABLES.ws = LCEL
and ALLTABLES.period_start_time = LCELLT_ext2.period_start_time (+) and ALLTABLES.ws = L
and ALLTABLES.period_start_time = LEPSB2.period_start_time (+) and ALLTABLES.ws = LEPSB
and ALLTABLES.period_start_time = LEPSB_2.period_start_time (+) and ALLTABLES.ws = LEPS
and ALLTABLES.period_start_time = LHO2.period_start_time (+) and ALLTABLES.ws = LHO2.ws
and ALLTABLES.period_start_time = LIANBHO2.period_start_time (+) and ALLTABLES.ws = LIAN
and ALLTABLES.period_start_time = LIENBHO2.period_start_time (+) and ALLTABLES.ws = LIEN
and ALLTABLES.period_start_time = LISHO2.period_start_time (+) and ALLTABLES.ws = LISHO2
and ALLTABLES.period_start_time = LUEST2.period_start_time (+) and ALLTABLES.ws = LUEST
order by
2,1,3
Page 43
Report Execution
FlexiZoneMicroBTS','FLC','FlexiZoneControllerBTS','TLC','FlexiZoneControllerBTS','MacroBTS') lnbts_type
Page 44
Report Execution
nd a.ws = g.ws
Page 45
Report Execution
COMPLETIONS,
_REQ_NORM,
EL_REQ_DETACH,
_REQ_NORM,
EQ_RNL_REDIR,
NON_GBR,
NI_NON_GBR,
Page 46
Report Execution
COMPLETIONS,
_REQ_NORM,
EL_REQ_DETACH,
_REQ_NORM,
EQ_RNL_REDIR,
NON_GBR,
NI_NON_GBR,
Page 47
Report Execution
nd a.ws = g.ws
L + enb_eps_bearer_rel_req_oth) RL70_eNB_drops
Page 48
Report Execution
nd a.ws = g.ws
Page 49
Report Execution
nd a.ws = g.ws
Page 50
Report Execution
nd a.ws = g.ws
Page 51
Report Execution
nd a.ws = g.ws
Page 52
Report Execution
nd a.ws = g.ws
Page 53
Report Execution
nd a.ws = g.ws
nd a.ws = g.ws
Page 54
Report Execution
nd a.ws = g.ws
Page 55
Report Execution
_SDU_VOL_DL,
SDU_VOL_UL
nd a.ws = g.ws
TCH_MEAN,
Page 56
Report Execution
DTCH_MEAN,
TCH_MEAN,
nd a.ws = g.ws
Page 57
Report Execution
ST2.SIGN_CONN_ESTAB_ATT_MT+LUEST2.SIGN_CONN_ESTAB_ATT_MO_D+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_O
null,(LEPSB2.EPS_BEARER_SETUP_COMPLETIONS)/(LEPSB2.EPS_BEARER_SETUP_ATTEMPTS))) erabsetupsuccessra
EST2.SIGN_CONN_ESTAB_ATT_MT+LUEST2.SIGN_CONN_ESTAB_ATT_MO_D+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_
REL_HO_PART),0)+LEPSB2.EPC_EPS_BEARER_REL_REQ_NORM+LEPSB2.EPC_EPS_BEARER_REL_REQ_DETACH+L
BHO2.SUCC_INTER_ENB_HO)/(LIENBHO2.INTER_ENB_HO_PREP))) handoversuccessrateviax2,
IENBHO2.INTER_ENB_S1_HO_SUCC/LIENBHO2.INTER_ENB_S1_HO_PREP))) handoversuccessratevias1,
NTER_ENB_HO+LIENBHO2.INTER_ENB_S1_HO_ATT-LHO2.HO_INTFREQ_ATT),0,NULL,(100*(LIANBHO2.SUCC_INTRA_
REQ_SUCC/LHO2.HO_INTFREQ_ATT)) interfrequencyho,
_SUCC/LISHO2.ISYS_HO_ATT)) interrathosrltetowcdma,
V2.SAMPLES_CELL_AVAIL)/(LCELAV2.DENOM_CELL_AVAIL))) avaiable,
sourceblockutilizingrateupli,
sourceblockutilizingratedown,
CP_SDU_VOL_DL/LCELLT2.ACTIVE_TTI_DL)) celldownlinkaveragethroughput,
CP_SDU_VOL_UL/LCELLT2.ACTIVE_TTI_UL)) celluplinkaveragethroughput,
00)) totalvolumedl,
00)) totalvolumeul,
EST2.UE_CTX_SETUP_SUCC_CSFB/LUEST2.UE_CTX_SETUP_ATT_CSFB)) csfbsuccessrate,
ELAV2.SAMPLES_CELL_AVAIL)/(LCELAV2.DENOM_CELL_AVAIL)))) unavailable,
00)+decode(1000000, 0, 0, LCELLT2.PDCP_SDU_VOL_UL/1000000)) totalvolume,
024)) celldownlinkmaxthroughput,
024)) celluplinkmaxthroughput,
Page 58
Report Execution
P_TPUT_NET_TIME_DL_QCI7+LCELLT2.IP_TPUT_NET_TIME_DL_QCI8+LCELLT2.IP_TPUT_NET_TIME_DL_QCI9),0,null
P_TPUT_NET_TIME_UL_QCI7+LCELLT2.IP_TPUT_NET_TIME_UL_QCI8+LCELLT2.IP_TPUT_NET_TIME_UL_QCI9),0,null
Page 59
Report Execution
_CONN_ESTAB_ATT_OTHERS,0)+LUEST2.SIGN_CONN_ESTAB_ATT_EMG+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_HIPR
S))) erabsetupsuccessrateallservice,
_CONN_ESTAB_ATT_DEL_TOL,0)+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_HIPRIO,0)+nvl(LUEST2.SIGN_CONN_ESTAB_
REL_REQ_DETACH+LEPSB2.EPC_EPS_BEARER_REL_REQ_RNL+LEPSB2.EPC_EPS_BEARER_REL_REQ_OTH+nvl(LE
NBHO2.SUCC_INTRA_ENB_HO+LIENBHO2.SUCC_INTER_ENB_HO+LIENBHO2.INTER_ENB_S1_HO_SUCC-LHO2.HO_IN
Page 60
Report Execution
_TIME_DL_QCI9),0,null,(LCELLT2.IP_TPUT_VOL_DL_QCI_6+LCELLT2.IP_TPUT_VOL_DL_QCI_7+LCELLT2.IP_TPUT_VOL
_TIME_UL_QCI9),0,null,(LCELLT2.IP_TPUT_VOL_UL_QCI_6+LCELLT2.IP_TPUT_VOL_UL_QCI_7+LCELLT2.IP_TPUT_VOL
Page 61
Report Execution
ONN_ESTAB_ATT_HIPRIO,0)+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_DEL_TOL,0)),0,null, LUEST2.SIGN_CONN_ESTAB_C
.SIGN_CONN_ESTAB_ATT_OTHERS,0)+LUEST2.SIGN_CONN_ESTAB_ATT_EMG),0,null, LUEST2.SIGN_CONN_ESTAB_
REL_REQ_OTH+nvl(LEPSB2.ERAB_REL_EPC_PATH_SWITCH,0)+nvl((LEPSB2.ENB_EPSBEAR_REL_REQ_RNL_REDIR+L
O_SUCC-LHO2.HO_INTFREQ_SUCC)/(LIANBHO2.ATT_INTRA_ENB_HO+LIENBHO2.ATT_INTER_ENB_HO+LIENBHO2.IN
Page 62
Report Execution
CELLT2.IP_TPUT_VOL_DL_QCI_8+LCELLT2.IP_TPUT_VOL_DL_QCI_9)/(LCELLT2.IP_TPUT_NET_TIME_DL_QCI6+LCELL
CELLT2.IP_TPUT_VOL_UL_QCI_8+LCELLT2.IP_TPUT_VOL_UL_QCI_9)/(LCELLT2.IP_TPUT_NET_TIME_UL_QCI6+LCELL
Page 63
Report Execution
SIGN_CONN_ESTAB_COMP/(LUEST2.SIGN_CONN_ESTAB_ATT_MO_S+LUEST2.SIGN_CONN_ESTAB_ATT_MT+LUEST2
SIGN_CONN_ESTAB_COMP/(LUEST2.SIGN_CONN_ESTAB_ATT_MO_S+LUEST2.SIGN_CONN_ESTAB_ATT_MT+LUEST
L_REQ_RNL_REDIR+LEPSB2.ENB_EPS_BEARER_REL_REQ_NORM+nvl(LEPSB_2.RL70_eNB_drops,0)+LEPSB2.PRE_E
ENB_HO+LIENBHO2.INTER_ENB_S1_HO_ATT-LHO2.HO_INTFREQ_ATT)))) intrafrequencyho,
Page 64
Report Execution
TIME_DL_QCI6+LCELLT2.IP_TPUT_NET_TIME_DL_QCI7+LCELLT2.IP_TPUT_NET_TIME_DL_QCI8+LCELLT2.IP_TPUT_N
TIME_UL_QCI6+LCELLT2.IP_TPUT_NET_TIME_UL_QCI7+LCELLT2.IP_TPUT_NET_TIME_UL_QCI8+LCELLT2.IP_TPUT_N
Page 65
Report Execution
TAB_ATT_MT+LUEST2.SIGN_CONN_ESTAB_ATT_MO_D+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_OTHERS,0)+LUEST2.S
STAB_ATT_MT+LUEST2.SIGN_CONN_ESTAB_ATT_MO_D+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_DEL_TOL,0)+nvl(LUES
ops,0)+LEPSB2.PRE_EMPT_GBR_BEARER+LEPSB2.PRE_EMPT_NON_GBR_BEARER),0)),0,null,(nvl((LEPSB2.ERAB_REL
Page 66
Report Execution
+LCELLT2.IP_TPUT_NET_TIME_DL_QCI9))) userdownlinkaveragethroughput3,
+LCELLT2.IP_TPUT_NET_TIME_UL_QCI9))) useruplinkaveragethroughput3
Page 67
Report Execution
OTHERS,0)+LUEST2.SIGN_CONN_ESTAB_ATT_EMG+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_HIPRIO,0)+nvl(LUEST2.SIG
_DEL_TOL,0)+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_HIPRIO,0)+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_OTHERS,0)+LUE
vl((LEPSB2.ERAB_REL_HO_PART+LEPSB2.ERAB_REL_ENB-LEPSB2.ERAB_REL_ENB_RNL_INA-LEPSB2.ERAB_REL_E
Page 68
Report Execution
RIO,0)+nvl(LUEST2.SIGN_CONN_ESTAB_ATT_DEL_TOL,0)))) rrcsetupsuccessrate,
_ATT_OTHERS,0)+LUEST2.SIGN_CONN_ESTAB_ATT_EMG)))*(decode(LUEST2.S1_SIGN_CONN_ESTAB_ATT_UE,0,null
LEPSB2.ERAB_REL_ENB_RNL_RED-LEPSB2.ERAB_REL_ENB_RNL_RRNA),0)+nvl(LEPSB_2.RL70_eNB_drops,0))/(nvl((L
Page 69
Report Execution
ESTAB_ATT_UE,0,null,null,1, LUEST2.S1_SIGN_CONN_ESTAB_SUCC_UE/LUEST2.S1_SIGN_CONN_ESTAB_ATT_UE))*(
0_eNB_drops,0))/(nvl((LEPSB2.ERAB_REL_ENB+LEPSB2.ERAB_REL_HO_PART),0)+LEPSB2.EPC_EPS_BEARER_REL_R
Page 70
Report Execution
N_ESTAB_ATT_UE))*(decode((nvl(LEPSB2.ERAB_INI_SETUP_ATT_QCI1,0)+nvl(LEPSB2.ERAB_INI_SETUP_ATT_QCI2,0)
EPS_BEARER_REL_REQ_NORM+LEPSB2.EPC_EPS_BEARER_REL_REQ_DETACH+LEPSB2.EPC_EPS_BEARER_REL_
Page 71
Report Execution
_SETUP_ATT_QCI2,0)+nvl(LEPSB2.ERAB_INI_SETUP_ATT_QCI3,0)+nvl(LEPSB2.ERAB_INI_SETUP_ATT_QCI4,0)+nvl(LE
C_EPS_BEARER_REL_REQ_RNL+LEPSB2.EPC_EPS_BEARER_REL_REQ_OTH+nvl(LEPSB2.ERAB_REL_EPC_PATH_SW
Page 72
Report Execution
P_ATT_QCI4,0)+nvl(LEPSB2.ERAB_INI_SETUP_ATT_QCI5,0)+nvl(LEPSB2.ERAB_INI_SETUP_ATT_QCI6,0)+nvl(LEPSB2.E
B_REL_EPC_PATH_SWITCH,0)+nvl((LEPSB2.ENB_EPSBEAR_REL_REQ_RNL_REDIR+LEPSB2.ENB_EPS_BEARER_REL
Page 73
Report Execution
_QCI6,0)+nvl(LEPSB2.ERAB_INI_SETUP_ATT_QCI7,0)+nvl(LEPSB2.ERAB_INI_SETUP_ATT_QCI8,0)+nvl(LEPSB2.ER...
B_EPS_BEARER_REL_REQ_NORM+nvl(LEPSB_2.RL70_eNB_drops,0)+LEPSB2.PRE_EMPT_GBR_BEARER+LEPSB2.PR
Page 74
Report Execution
0)+nvl(LEPSB2.ER...
_BEARER+LEPSB2.PRE_EMPT_NON_GBR_BEARER),0)))) service...
Page 75