Sms
Sms
Sms
MO
MO VMSC IWMSC - Phy Addr
Period start time MSC name SR Succ Unsucc Succ Unsucc
MSC_602A M309B3C1 M309B3C2 M309B5C1 M309B5C2
12.12.2017 07:00:00 XAMB3 81.82 196,523 43,670
12.12.2017 08:00:00 XAMB3 85.43 275,871 47,057
12.12.2017 09:00:00 XAMB3 87.19 325,938 47,872
12.12.2017 10:00:00 XAMB3 88.12 350,834 47,291
12.12.2017 11:00:00 XAMB3 88.55 368,505 47,656
12.12.2017 12:00:00 XAMB3 88.68 374,244 47,749
12.12.2017 13:00:00 XAMB3 88.81 380,267 47,916
12.12.2017 14:00:00 XAMB3 88.42 362,493 47,460
12.12.2017 15:00:00 XAMB3 87.77 327,575 45,666
12.12.2017 16:00:00 XAMB3 87.69 320,030 44,936
12.12.2017 17:00:00 XAMB3 87.70 320,649 44,984
12.12.2017 18:00:00 XAMB3 89.24 382,655 46,147
12.12.2017 19:00:00 XAMB3 92.34 617,800 51,243
12.12.2017 20:00:00 XAMB3 93.50 755,655 52,535
12.12.2017 21:00:00 XAMB3 93.73 756,847 50,606
12.12.2017 22:00:00 XAMB3 92.80 623,559 48,356
12.12.2017 23:00:00 XAMB3 89.74 388,839 44,448
12.13.2017 00:00:00 XAMB3 76.82 138,781 41,873
12.13.2017 01:00:00 XAMB3 63.95 64,648 36,442
12.13.2017 02:00:00 XAMB3 44.71 26,498 32,769
12.13.2017 03:00:00 XAMB3 29.74 14,039 33,169
12.13.2017 04:00:00 XAMB3 28.09 12,485 31,963
12.13.2017 05:00:00 XAMB3 43.85 24,533 31,412
12.13.2017 06:00:00 XAMB3 71.92 92,935 36,285
12.13.2017 07:00:00 XAMB3 83.04 199,208 40,680
12.13.2017 08:00:00 XAMB3 86.48 285,051 44,545
12.13.2017 09:00:00 XAMB3 87.81 335,191 46,522
12.13.2017 10:00:00 XAMB3 88.74 360,458 45,759
12.13.2017 11:00:00 XAMB3 88.67 375,409 47,983
12.13.2017 12:00:00 XAMB3 89.20 387,210 46,884
12.13.2017 13:00:00 XAMB3 88.92 385,662 48,055
12.13.2017 14:00:00 XAMB3 88.20 369,340 49,430
12.13.2017 15:00:00 XAMB3 87.82 338,048 46,896
12.13.2017 16:00:00 XAMB3 87.85 324,204 44,858
12.13.2017 17:00:00 XAMB3 87.69 327,301 45,946
12.13.2017 18:00:00 XAMB3 89.55 397,232 46,363
12.13.2017 19:00:00 XAMB3 92.56 634,670 51,006
12.13.2017 20:00:00 XAMB3 93.49 769,077 53,521
12.13.2017 21:00:00 XAMB3 93.61 751,634 51,291
12.13.2017 22:00:00 XAMB3 92.36 606,754 50,179
12.13.2017 23:00:00 XAMB3 31.01 183,459 408,093
12.14.2017 00:00:00 XAMB3 3.41 10,036 283,869
12.14.2017 01:00:00 XAMB3 2.28 3,381 144,893
12.14.2017 02:00:00 XAMB3 1.70 1,405 81,283
12.14.2017 03:00:00 XAMB3 1.26 733 57,529
12.14.2017 04:00:00 XAMB3 1.25 689 54,475
Page 1
Data
Page 2
Data
O
IWMSC - Log Addr MT GMSC - Phy Addr GMSC - Status Report
Succ Unsucc SR Succ Temp Fail Perm Fail Delivery SR Succ
M309B4C1 M309B4C2 MSC_603B M309B6C1 M309B6C2 M309B6C3 MSC_2108A M309B6C4
99.31
99.38
99.27
99.27
99.30
99.34
99.31
99.37
99.18
99.26
99.35
99.37
99.34
99.36
99.36
99.36
99.38
99.38
99.29
99.13
98.80
98.63
98.91
99.11
99.29
99.34
99.36
99.33
99.30
99.32
99.34
99.36
99.34
99.36
99.35
99.36
99.35
99.36
99.32
99.33
98.91
98.62
98.49
98.58
98.48
97.94
Page 3
Data
98.49
98.36
Page 4
Data
MT
GMSC - Status Report VMSC - Log Addr VMSC - Status Report
Temp Fail Perm Fail Succ Temp Fail Perm Fail Delivery SR Succ Temp Fail
M309B6C5 M309B6C6 M309B7C1 M309B7C2 M309B7C3 MSC_2107A M309B7C4 M309B7C5
432,716 83,575 2,988 95 91,257 4,676
588,682 89,573 3,700 96 128,228 5,420
737,923 147,661 5,406 96 153,163 6,068
785,012 177,234 5,739 96 164,328 6,549
866,123 238,239 6,136 96 171,653 7,327
780,944 173,713 5,152 96 176,574 7,271
780,542 153,664 5,408 96 179,837 7,146
722,018 134,925 4,590 96 170,669 7,222
700,441 181,100 5,817 96 154,921 6,504
659,614 148,301 4,903 96 152,060 6,524
654,374 130,715 4,310 96 154,639 6,664
756,312 140,041 4,814 96 184,202 7,823
1,142,535 159,135 7,587 96 298,543 11,758
1,348,589 169,400 8,740 96 364,637 14,964
1,326,189 170,457 8,602 96 365,485 14,497
1,094,559 152,235 7,015 96 303,340 11,678
682,225 106,883 4,273 96 188,452 7,319
301,699 77,048 1,872 95 63,314 3,300
142,096 61,609 1,011 94 29,607 1,838
92,149 57,000 806 89 12,954 1,491
49,934 49,028 604 86 7,270 1,141
39,977 33,805 555 85 6,171 1,076
96,104 55,278 1,063 88 11,628 1,495
218,746 66,034 1,967 93 42,453 3,026
437,107 81,412 3,133 95 93,025 4,784
603,231 93,587 4,010 96 132,733 5,647
694,553 101,131 4,477 96 156,990 6,041
812,584 159,820 5,516 96 168,951 6,862
865,756 205,390 6,074 96 177,029 6,627
787,690 148,803 5,380 96 181,524 7,014
755,695 137,407 5,043 96 180,643 7,272
722,721 129,348 4,648 96 174,100 7,513
675,325 131,107 4,457 95 160,738 7,112
648,268 124,268 4,192 95 154,084 6,957
670,514 133,095 4,365 95 156,927 6,998
785,158 143,051 5,067 96 191,841 8,167
1,182,057 159,965 7,706 96 306,534 12,071
1,385,611 174,628 8,900 96 371,495 14,984
1,327,851 173,397 9,104 95 364,894 15,814
1,073,325 154,386 7,213 96 296,463 12,542
398,593 95,946 4,373 94 89,386 5,088
120,952 64,756 1,693 64 2,594 1,424
59,019 54,541 905 61 1,570 1,000
50,376 53,436 728 59 1,303 879
31,004 43,806 479 62 1,336 796
21,516 29,069 452 60 1,154 775
Page 5
Data
Page 6
Data
us Report
Perm Fail
M309B7C6
328
445
532
655
604
629
683
672
596
579
532
638
1,216
1,462
1,629
1,314
751
184
113
31
38
29
38
149
368
487
642
661
700
695
692
644
616
558
653
741
1,327
1,647
1,790
1,404
565
22
12
9
7
10
Page 7
Data
11
48
Page 8
Documentation
Page 9
Documentation
Page 10
Report Execution
Cache handler
Evaluation method
Init duration
Sql generation
Execution duration
Load from cache
Create tmp Tables
Drop tmp Tables
Load data db
Load data and write to cache
Start Time
2017-12-14 06:12:24.156
Page 11
Report Execution
2017-12-14 06:12:24.346
Page 12
Report Execution
com.nokia.oss.qengine.support.CacheAwareEngine
tmp tables(1)
0.145
0.007
0.21
none
0.19
none
none
none
Page 13
Report Execution
SUM(SMSC_SUCC_GMSC_MT_
SUM(SMSC_TEMP_FAIL_GMSC
SUM(SMSC_PERM_FAIL_GMSC
SUM(SMSC_SUCC_GMSC_STA
SUM(SMSC_T_FAIL_GMSC_STA
SUM(SMSC_P_FAIL_GMSC_STA
SUM(SMSC_SUCC_VMSC_MT_
SUM(SMSC_TEMP_FAIL_VMSC
SUM(SMSC_PERM_FAIL_VMSC
SUM(SMSC_SUCC_VMSC_STAR
SUM(SMSC_T_FAIL_VMSC_STA
SUM(SMSC_P_FAIL_VMSC_STA
from
utp_common_objects plmn,
utp_common_objects msc,
rns_ps_smsty_type1_raw p
where
msc.co_gid in ( '852755' ) and
period_start_time >= to_date('201
period_start_time < to_date('2017
msc.co_gid = p.msc_id and
msc.co_parent_gid = plmn.co_gid
msc.co_oc_id=107 and
plmn.co_oc_id=16
group by
trunc( p.period_start_time, 'hh24'
msc.co_gid,
p.smsc_address_id,
p.smsc_address_type_id
)a
group by
a.period_start_time,
a.msc_gid
2017-12-14 06:12:24.366 report from tmp tables
select
SMSTY.period_start_time period_
nvl(msc.co_name, nvl(msc.co_ob
SMSTY.msc_gid, nvl(msc.co_ext_
to_number(100*(decode( (smsty.s
to_number(smsty.smsc_succ_vm
to_number(smsty.smsc_unsucc_v
to_number(smsty.smsc_succ_iwm
to_number(smsty.smsc_unsucc_i
to_number(smsty.smsc_succ_iwm
to_number(smsty.smsc_unsucc_i
to_number(100*(decode( (smsty.s
to_number(smsty.smsc_succ_gm
to_number(smsty.smsc_temp_fail
to_number(smsty.smsc_perm_fai
Page 14
Report Execution
to_number(100*decode( ((SMSTY
to_number(smsty.smsc_succ_gm
to_number(smsty.smsc_t_fail_gm
to_number(smsty.smsc_p_fail_gm
to_number(smsty.smsc_succ_vm
to_number(smsty.smsc_temp_fail
to_number(smsty.smsc_perm_fai
to_number(100*decode( ((SMSTY
to_number(smsty.smsc_succ_vm
to_number(smsty.smsc_t_fail_vm
to_number(smsty.smsc_p_fail_vm
from
utp_common_objects plmn,
utp_common_objects msc
,
jf_SMSTY_1430873898 SMSTY
where
msc.co_parent_gid = plmn.co_gid
SMSTY.msc_gid = msc.co_gid
order by 2,1,3
Page 15
Report Execution
MSTY_1430873898
al temporary table jf_SMSTY_1430873898 on commit preserve rows as
C_SUCC_VMSC_MO_LOGICAL) SMSC_SUCC_VMSC_MO_LOGICAL,
SMSC_UNSUCC_VMSC_MO_LOGICAL) SMSC_UNSUCC_VMSC_MO_LOGICAL,
SMSC_SUCC_IWMSC_MO_LOGICAL) SMSC_SUCC_IWMSC_MO_LOGICAL,
SMSC_UNSUCC_IWMSC_MO_LOGICAL) SMSC_UNSUCC_IWMSC_MO_LOGICAL,
SMSC_SUCC_IWMSC_MO_PHYSICAL) SMSC_SUCC_IWMSC_MO_PHYSICAL,
SMSC_UNSUCC_IWMSC_MO_PHYSICAL) SMSC_UNSUCC_IWMSC_MO_PHYSICAL,
SMSC_SUCC_GMSC_MT_PHYS) SMSC_SUCC_GMSC_MT_PHYS,
SMSC_TEMP_FAIL_GMSC_MT_PHYS) SMSC_TEMP_FAIL_GMSC_MT_PHYS,
SMSC_PERM_FAIL_GMSC_MT_PHYS) SMSC_PERM_FAIL_GMSC_MT_PHYS,
SMSC_SUCC_GMSC_STAR_MT_PHYS) SMSC_SUCC_GMSC_STAR_MT_PHYS,
SMSC_T_FAIL_GMSC_STAR_MT_PHYS) SMSC_T_FAIL_GMSC_STAR_MT_PHYS,
SMSC_P_FAIL_GMSC_STAR_MT_PHYS) SMSC_P_FAIL_GMSC_STAR_MT_PHYS,
SMSC_SUCC_VMSC_MT_PHYS) SMSC_SUCC_VMSC_MT_PHYS,
SMSC_TEMP_FAIL_VMSC_MT_PHYS) SMSC_TEMP_FAIL_VMSC_MT_PHYS,
SMSC_PERM_FAIL_VMSC_MT_PHYS) SMSC_PERM_FAIL_VMSC_MT_PHYS,
SMSC_SUCC_VMSC_STAR_MT_LOG) SMSC_SUCC_VMSC_STAR_MT_LOG,
SMSC_T_FAIL_VMSC_STAR_MT_LOG) SMSC_T_FAIL_VMSC_STAR_MT_LOG,
SMSC_P_FAIL_VMSC_STAR_MT_LOG) SMSC_P_FAIL_VMSC_STAR_MT_LOG
Page 16
Report Execution
SMSC_SUCC_GMSC_MT_PHYS) SMSC_SUCC_GMSC_MT_PHYS,
SMSC_TEMP_FAIL_GMSC_MT_PHYS) SMSC_TEMP_FAIL_GMSC_MT_PHYS,
SMSC_PERM_FAIL_GMSC_MT_PHYS) SMSC_PERM_FAIL_GMSC_MT_PHYS,
SMSC_SUCC_GMSC_STAR_MT_PHYS) SMSC_SUCC_GMSC_STAR_MT_PHYS,
SMSC_T_FAIL_GMSC_STAR_MT_PHYS) SMSC_T_FAIL_GMSC_STAR_MT_PHYS,
SMSC_P_FAIL_GMSC_STAR_MT_PHYS) SMSC_P_FAIL_GMSC_STAR_MT_PHYS,
SMSC_SUCC_VMSC_MT_PHYS) SMSC_SUCC_VMSC_MT_PHYS,
SMSC_TEMP_FAIL_VMSC_MT_PHYS) SMSC_TEMP_FAIL_VMSC_MT_PHYS,
SMSC_PERM_FAIL_VMSC_MT_PHYS) SMSC_PERM_FAIL_VMSC_MT_PHYS,
SMSC_SUCC_VMSC_STAR_MT_LOG) SMSC_SUCC_VMSC_STAR_MT_LOG,
SMSC_T_FAIL_VMSC_STAR_MT_LOG) SMSC_T_FAIL_VMSC_STAR_MT_LOG,
SMSC_P_FAIL_VMSC_STAR_MT_LOG) SMSC_P_FAIL_VMSC_STAR_MT_LOG
mmon_objects plmn,
mmon_objects msc,
_smsty_type1_raw p
p.period_start_time, 'hh24' ),
c_address_id,
c_address_type_id
Y.period_start_time period_start_time,
c.co_name, nvl(msc.co_object_instance, 'NN('||msc.co_gid||')'))"MSC name",
Y.msc_gid, nvl(msc.co_ext_dn, msc.co_dn) "DN",
mber(100*(decode( (smsty.smsc_succ_vmsc_mo_logical + smsty.smsc_unsucc_vmsc_mo_logical),0,null, smsty.smsc_succ_vm
mber(smsty.smsc_succ_vmsc_mo_logical) M309B3C1,
mber(smsty.smsc_unsucc_vmsc_mo_logical) M309B3C2,
mber(smsty.smsc_succ_iwmsc_mo_physical) M309B5C1,
mber(smsty.smsc_unsucc_iwmsc_mo_physical) M309B5C2,
mber(smsty.smsc_succ_iwmsc_mo_logical) M309B4C1,
mber(smsty.smsc_unsucc_iwmsc_mo_logical) M309B4C2,
mber(100*(decode( (smsty.smsc_succ_vmsc_mt_phys + smsty.smsc_perm_fail_vmsc_mt_phys),0,null, smsty.smsc_succ_vmsc
mber(smsty.smsc_succ_gmsc_mt_phys) M309B6C1,
mber(smsty.smsc_temp_fail_gmsc_mt_phys) M309B6C2,
mber(smsty.smsc_perm_fail_gmsc_mt_phys) M309B6C3,
Page 17
Report Execution
mmon_objects plmn,
mmon_objects msc
TY_1430873898 SMSTY
Page 18
Report Execution
Page 19
Report Execution
Page 20
Report Execution
y.smsc_unsucc_vmsc_mo_logical)))) msc_602a,
_perm_fail_vmsc_mt_phys) ) )) msc_603b,
Page 21
Report Execution
Page 22
Report Execution
Page 23
Report Execution
STAR_MT_PHYS)))) msc_2108a,
_LOG)))) msc_2107a,
Page 24