话统解释及count计算公式

1、EDGE 2、EDGE 3、 4、 5、 6、 7、 8、 9、 10、 12、 13、 14、 15、 16、 17、 18、 19、ERL 20、 21、 22、 23、ERLB表修 25 1、EDGESELECTCELLGPRS_ADM.TIMEASDATE,COUNT(DISTINCTCELLGPRS_ADM.NEASBSC量,COUNT(CELLGPRS.MO)AS小区数量,GDATA),10,2)ASIP量,GDATA),10,2)ASIP量,STBF+RLINKBITR.INT55BREGPRSTBF),10,2)ASRLCSTR(SUM(CELLGPRS.CS12ULACK/1000+CELLGPRS.MC19ULACK/1000),10,2)ASRLC10,2)ASGPRSIP吐率,TA),10,2)ASGPRSIP量,10,2)ASGPRSIP吐率,TA),10,2)ASGPRSIP量,G.DLTHP3EGDATA),10,2)ASEDGEIPTHP3EGDATA),10,2)ASEDGEIP量,G.ULTHP3EGDATA),10,2)ASEDGEIPTHP3EGDATA),10,2)ASEDGEIP量,DISRR+CELLGPRS2.LDISOTH+CELLGPRS2.FLUDISC),10,2)ASTBF线比,SUM(TRAFDLGPRS.TBFDLGPRS)ASGPRS的下行TBF量,SUM(TRAFDLGPRS.TBFDLEGPRS)ASEDGE下行TBF量,SUM(CELLGPRS2.LDISTFI)ASNO_PDCH_TFI_LLC的PDU弃数,SUM(CELLGPRS2.LDISRR)AS无线原因致LLC的PDU次数,SUM(CELLGPRS2.LDISOTH)AS其他原因致LLCPDU丢弃次数,SUM(CELLGPRS2.FLUDISC)ASRACRSLLCPDU次数REJTFI+CELLGPRS2.PREJOTH),10,2)AS上行TBFSUM(TRAFULGPRS.TBFULGPRS)ASGPRS的上行TBF数量,SUM(TRAFULGPRS.TBFULEGPRS)ASEDGE的上行TBF数量,SUM(CELLGPRS2.IAULREL)AS无线原因致上行TBF关闭次数,SUM(CELLGPRS2.PREJTFI)AS无PDCH或USF或TFI致分组接入 SUM(CELLGPRS2.PREJOTH)AS其他原因致分组接入 10,2)ASGPRS_LLC_DATA_PER_PFC_DL,10,2)ASGPRS_LLC_DATA_PER_PFC_UL,EG.DLTHP3EGPFC),10,2)ASEDGE_LLC_DATA_PER_PFC_DL,EG.ULTHP3EGPFC),10,2)ASEDGE_LLC_DATA_PER_PFC_UL,OSEG.DLTHP3EGDATA),10,2)ASLLCEDGE比,OSEG.ULTHP3EGDATA),10,2)ASLLCEDGE比,STR(SUM(CELLGPRS.CS12DLACK)/SUM(CELLGPRS.CS12DLSCHED*20),10,2)ASCS12RLC率STR(SUM(CELLGPRS.CS12ULACK)/SUM(CELLGPRS.CS12ULSCHED*20),10,2)ASCS12RLC率STR(SUM(CELLGPRS.CS12DLACK/1000),10,2)ASCS12RLC量,STR(SUM(CELLGPRS.CS12ULACK/1000),10,2)ASCS12RLCNT55BREGPRSTBF),10,2)ASEDGE的RLC下行吞吐率,INT45BREGPRSTBF+RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)ASEDGERLCINT55BREGPRSTBF),10,2)asINT10INT55BREGPRSTBF),10,2)asINT15INT55BREGPRSTBF),10,2)asINT20INT55BREGPRSTBF),10,2)asINT25INT55BREGPRSTBF),10,2)asINT30INT55BREGPRSTBF),10,2)asINT35INT55BREGPRSTBF),10,2)asINT40INT55BREGPRSTBF),10,2)asINT45INT55BREGPRSTBF),10,2)asINT50INT55BREGPRSTBF),10,2)asINT55STR(SUM(CELLGPRS.MC19ULACK)/SUM(CELLGPRS.MC19ULSCHED*20+0.0001),10,2)ASEDGERLC上STR(SUM(CELLGPRS.MC19ULACK)/1000,10,2)ASEDGERLC),10,2)AS下行RLC层EDGE占用比,0+0.0001),10,2)AS上行RLC层EDGE占用比,CELLGPRS2.FLUDISC+0.0001),10,2)AS无线原因 释放的TBF比例,GPRS2.TRAFF2GTBFSCAN+0.0001),10,2)ASGPRS多时隙利用率,+0.0001),10,2)asTBF数,STR(SUM(TRAFDLGPRS.DLTBFPEPDCH)/SUM(TRAFDLGPRS.DLEPDCH+0.0001),10,2asEDGE行每TBFSTR(SUM(TRAFULGPRS.ULTBFPEPDCH)/SUM(TRAFULGPRS.ULEPDCH+0.0001),10,2asEDGE行每2)astbf_minutes_per_inter_RA_csl,2)astbf_minutes_per_intra_RA_csl,SUM(CELLGPRS.PCHALLFAIL)ASPDCH,SUM(CELLGPRS.PCHALLATT)ASPDCH数,STR(SUM(CELLGPRS.PCHALLFAIL)/SUM(CELLGPRS.PCHALLATT+0.0001),10,2)asPDCH率,STR(SUM(CELLGPRS.ALLPDCHACC)/SUM(CELLGPRS.ALLPDCHSCAN+0.0001),10,2)asPDCHSTR(SUM(CELLGPRS.ALLPDCHACTACC)/SUM(CELLGPRS.ALLPDCHSCAN+0.0001),10,2)asPDCH量STR(SUM(CELLGPRS.ALLPDCHACTACC)/SUM(CELLGPRS.ALLPDCHACC+0.0001),10,2)asPDCHSUM(CELLGPRS.ALLPDCHPEAK)as最大的PDCH量,SUM(CELLGPRS.PREEMPTPDCH)ASPDCH空次数, ),10,2)aspreem_load,LGPRS.DLBPDCH+TRAFDLGPRS.DLGPDCH+TRAFDLGPRS.DLEPDCH),10,2)asshare_on_b_g_e_dl,LGPRS.ULBPDCH+TRAFULGPRS.ULGPDCH+TRAFULGPRS.ULEPDCH),10,2)asshare_on_b_g_e_ul,STR(SUM(TRAFDLGPRS.DLTBFPEPDCH)/SUM(TRAFDLGPRS.DLEPDCH+0.0001),10,2)asshare_on_e_dl,STR(SUM(TRAFULGPRS.ULTBFPEPDCH)/SUM(TRAFULGPRS.ULEPDCH+0.0001),10,2)asshare_on_e_ul,10,2)as每分种预清空影响到的TBFSTR(100*SUM(CELLGPRS.FAILDLTBFEST)/SUM(CELLGPRS.DLTBFEST+0.0001),10,2)as行PDCHSTR(100*SUM(CELLGPRS2.PREJTFI+CELLGPRS2.PREJOTH)/SUM(CELLGPRS2.PSCHREQ+0.0001),10,2as上行PDCH率,2)astbf_min_per_inter_ra_csl,2)as.0001),10,2)as.0001),10,2)ascs_bler_ul,PRS.CELLMOVED)ASRP移次2、EDGEEGDATA+CELLQOSEG.DLTHP3EGDATA),10,2)ASIPEGDATA+CELLQOSEG.ULTHP3EGDATA),10,2)ASIPASRLCSTR(SUM(CELLGPRS.CS12ULACK/1000+CELLGPRS.MC19ULACK/1000),10,2)ASRLCA+CELLQOSG.DLTHP3GDATA),10,2)ASGPRSIPSG.DLTHP3GDATA),10,2)ASGPRSIPA+CELLQOSG.ULTHP3GDATA),10,2)ASGPRSIPSG.ULTHP3GDATA),10,2)ASGPRSIPEG.DLTHP2EGDATA+CELLQOSEG.DLTHP3EGDATA),10,2)ASEDGEIPCELLQOSEG.DLTHP3EGDATA),10,2)ASEDGEIPEG.ULTHP2EGDATA+CELLQOSEG.ULTHP3EGDATA),10,2)ASEDGEIPCELLQOSEG.ULTHP3EGDATA),10,2)ASEDGEIP+CELLGPRS2.LDISRR+CELLGPRS2.LDISOTH+CELLGPRS2.FLUDISC),10,2)ASTBFSUM(TRAFDLGPRS.TBFDLGPRS)ASGPRSTBFSUM(TRAFDLGPRS.TBFDLEGPRS)ASEDGETBFSUM(CELLGPRS2.LDISTFI)ASNO_PDCH_TFI_LLCPDUSUM(CELLGPRS2.LDISRR)ASLLCPDUSUM(CELLGPRS2.LDISOTH)ASLLCPDUSUM(CELLGPRS2.FLUDISC)ASRACRSLLCPDU+CELLGPRS2.PREJTFI+CELLGPRS2.PREJOTH),10,2)AS上行TBF掉线比,SUM(TRAFULGPRS.TBFULGPRS)ASGPRS的上行TBF数量,SUM(TRAFULGPRS.TBFULEGPRS)ASEDGE的上行TBF数量,SUM(CELLGPRS2.IAULREL)AS无线原因致上行TBF关闭次数,SUM(CELLGPRS2.PREJTFI)AS无PDCH或USF或TFI致分组接入 SUM(CELLGPRS2.PREJOTH)AS其他原因致分组接入 FC+CELLQOSG.DLTHP3GPFC),10,2)ASGPRS_LLC_DATA_PER_PFC_DL,FC+CELLQOSG.ULTHP3GPFC),10,2)ASGPRS_LLC_DATA_PER_PFC_UL,OSEG.DLTHP2EGPFC+CELLQOSEG.DLTHP3EGPFC),10,2)ASEDGE_LLC_DATA_PER_PFC_DL,OSEG.ULTHP2EGPFC+CELLQOSEG.ULTHP3EGPFC),10,2)ASEDGE_LLC_DATA_PER_PFC_UL,EDGEEDGESTR(SUM(CELLGPRS.CS12DLACK)/SUM(CELLGPRS.CS12DLSCHED*20),10,2)ASCS12RLCSTR(SUM(CELLGPRS.CS12ULACK)/SUM(CELLGPRS.CS12ULSCHED*20),10,2)ASCS12RLCSTR(SUM(CELLGPRS.CS12DLACK/1000),10,2)ASCS12RLCSTR(SUM(CELLGPRS.CS12ULACK/1000),10,2)ASCS12RLC5BREGPRSTBF),10,2)ASEDGERLC.INT55BREGPRSTBF),10,2)ASEDGERLCRLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT10RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT15RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT20RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT25RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT30RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT35RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2asINT40RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT45RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT50RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)asINT55STR(SUM(CELLGPRS.MC19ULACK)/SUM(CELLGPRS.MC19ULSCHED*20+0.0001),10,2)ASSTR(SUM(CELLGPRS.MC19ULACK)/1000,10,2)ASEDGE的RLC层上行流量,0,2)AS下行RLC层EDGE占用比,S12ULACK/1000+0.0001),10,2)AS上行RLC层EDGE占用比,RS2.LDISOTH+CELLGPRS2.FLUDISC+0.0001),10,2)AS无线原因 释放的TBF比例,TBFSCAN+TRAFGPRS2.TRAFF2GTBFSCAN+0.0001),10,2)ASGPRS多时隙利用率,asEDGESTR(SUM(TRAFDLGPRS.DLTBFPEPDCH)/SUM(TRAFDLGPRS.DLEPDCH+0.0001),10,2)asEDGETBFTBF+0.0001),10,2)astbf_minutes_per_inter_RA_csl,+0.0001),10,2)astbf_minutes_per_intra_RA_csl,SUM(CELLGPRS.PCHALLFAIL)ASPDCHSUM(CELLGPRS.PCHALLATT)ASPDCHSTR(SUM(CELLGPRS.ALLPDCHACC)/SUM(CELLGPRS.ALLPDCHSCAN+0.0001),10,2)asPDCHSTR(SUM(CELLGPRS.ALLPDCHACTACC)/SUM(CELLGPRS.ALLPDCHSCAN+0.0001),10,2)asPDCHSTR(SUM(CELLGPRS.ALLPDCHACTACC)/SUM(CELLGPRS.ALLPDCHACC+0.0001),10,2)asPDCHSUM(CELLGPRS.ALLPDCHPEAK)asPDCHSUM(CELLGPRS.PREEMPTPDCH)ASPDCH ),10,2)aspreem_load,H)/SUM(TRAFDLGPRS.DLBPDCH+TRAFDLGPRS.DLGPDCH+TRAFDLGPRS.DLEPDCH),10,2)asH)/SUM(TRAFULGPRS.ULBPDCH+TRAFULGPRS.ULGPDCH+TRAFULGPRS.ULEPDCH),10,2)asSTR(SUM(TRAFDLGPRS.DLTBFPEPDCH)/SUM(TRAFDLGPRS.DLEPDCH+0.0001),10,2)asSTR(SUM(TRAFULGPRS.ULTBFPEPDCH)/SUM(TRAFULGPRS.ULEPDCH+0.0001),10,2)asDCH+0.0001),10,2)asTBFSTR(100*SUM(CELLGPRS.FAILDLTBFEST)/SUM(CELLGPRS.DLTBFEST+0.0001),10,2)asPDCH01),10,2)asPDCH+0.0001),10,2)astbf_min_per_inter_ra_csl,+0.0001),10,2)astbf_min_per_intra_ra_csl,S12DLSCHED+0.0001),10,2)asS12ULSCHED+0.0001),10,2)asF),SUM(CELLGPRS.CELLMOVED)ASRP3SELECTCELLGPRS_ADM.TIMEASDATE,CELLGPRS_ADM.NEASBSC,COUNT(CELLGPRS.MO)AS数量,GDATA),10,2)ASIP量,GDATA),10,2)ASIP量,STBF+RLINKBITR.INT55BREGPRSTBF),10,2)ASRLCSTR(SUM(CELLGPRS.CS12ULACK/1000+CELLGPRS.MC19ULACK/1000),10,2)ASRLC10,2)ASGPRSIP吐率,TA),10,2)ASGPRSIP量,10,2)ASGPRSIP吐率,TA),10,2)ASGPRSIP量,G.DLTHP3EGDATA),10,2)ASEDGEIPTHP3EGDATA),10,2)ASEDGEIP量,G.ULTHP3EGDATA),10,2)ASEDGEIPTHP3EGDATA),10,2)ASEDGEIP量,DISRR+CELLGPRS2.LDISOTH+CELLGPRS2.FLUDISC),10,2)ASTBF线比,SUM(TRAFDLGPRS.TBFDLGPRS)ASGPRS的下行TBF量,SUM(TRAFDLGPRS.TBFDLEGPRS)ASEDGE下行TBF量,SUM(CELLGPRS2.LDISTFI)ASNO_PDCH_TFI_LLC的PDU弃数,SUM(CELLGPRS2.LDISRR)AS无线原因致LLC的PDU次数,SUM(CELLGPRS2.LDISOTH)AS其他原因致LLCPDU丢弃次数,SUM(CELLGPRS2.FLUDISC)ASRACRSLLCPDU次数REJTFI+CELLGPRS2.PREJOTH),10,2)AS上行TBFSUM(TRAFULGPRS.TBFULGPRS)ASGPRS的上行TBF数量,SUM(TRAFULGPRS.TBFULEGPRS)ASEDGE的上行TBF数量,SUM(CELLGPRS2.IAULREL)AS无线原因致上行TBF关闭次数,SUM(CELLGPRS2.PREJTFI)AS无PDCH或USF或TFI致分组接入 SUM(CELLGPRS2.PREJOTH)AS其他原因致分组接入 10,2)ASGPRS_LLC_DATA_PER_PFC_DL,10,2)ASGPRS_LLC_DATA_PER_PFC_UL,EG.DLTHP3EGPFC),10,2)ASEDGE_LLC_DATA_PER_PFC_DL,EG.ULTHP3EGPFC),10,2)ASEDGE_LLC_DATA_PER_PFC_UL,OSEG.DLTHP3EGDATA),10,2)ASLLC层下行流量EDGE占用比,OSEG.ULTHP3EGDATA),10,2)ASLLC层上行流量EDGE占用比,STR(SUM(CELLGPRS.CS12DLACK)/SUM(CELLGPRS.CS12DLSCHED*20),10,2)ASCS12的RLC层下行吞吐率STR(SUM(CELLGPRS.CS12ULACK)/SUM(CELLGPRS.CS12ULSCHED*20),10,2)ASCS12RLC率STR(SUM(CELLGPRS.CS12DLACK/1000),10,2)ASCS12RLCSTR(SUM(CELLGPRS.CS12ULACK/1000),10,2)ASCS12RLCNT55BREGPRSTBF),10,2)ASEDGE的RLC下行吞吐率,INT45BREGPRSTBF+RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)ASEDGERLCINT55BREGPRSTBF),10,2)asINT10INT55BREGPRSTBF),10,2)asINT15INT55BREGPRSTBF),10,2)asINT20INT55BREGPRSTBF),10,2)asINT25INT55BREGPRSTBF),10,2)asINT30INT55BREGPRSTBF),10,2)asINT35INT55BREGPRSTBF),10,2)asINT40INT55BREGPRSTBF),10,2)asINT45INT55BREGPRSTBF),10,2)asINT50INT55BREGPRSTBF),10,2)asINT55STR(SUM(CELLGPRS.MC19ULACK)/SUM(CELLGPRS.MC19ULSCHED*20+0.0001),10,2)ASEDGERLC上STR(SUM(CELLGPRS.MC19ULACK)/1000,10,2)ASEDGERLC),10,2)AS下行RLC层EDGE占用比,0+0.0001),10,2)AS上行RLC层EDGE占用比,CELLGPRS2.FLUDISC+0.0001),10,2)AS无线原因 释放的TBF比例,GPRS2.TRAFF2GTBFSCAN+0.0001),10,2)ASGPRS多时隙利用率,+0.0001),10,2)asTBF数,STR(SUM(TRAFDLGPRS.DLTBFPEPDCH)/SUM(TRAFDLGPRS.DLEPDCH+0.0001),10,2asEDGE行每TBFSTR(SUM(TRAFULGPRS.ULTBFPEPDCH)/SUM(TRAFULGPRS.ULEPDCH+0.0001),10,2asEDGE行每2)astbf_minutes_per_inter_RA_csl,2)astbf_minutes_per_intra_RA_csl,SUM(CELLGPRS.PCHALLFAIL)ASPDCH,SUM(CELLGPRS.PCHALLATT)ASPDCH数,STR(SUM(CELLGPRS.PCHALLFAIL)/SUM(CELLGPRS.PCHALLATT+0.0001),10,2)asPDCH率,STR(SUM(CELLGPRS.ALLPDCHACC)/SUM(CELLGPRS.ALLPDCHSCAN+0.0001),10,2)asPDCHSTR(SUM(CELLGPRS.ALLPDCHACTACC)/SUM(CELLGPRS.ALLPDCHSCAN+0.0001),10,2)asPDCH量STR(SUM(CELLGPRS.ALLPDCHACTACC)/SUM(CELLGPRS.ALLPDCHACC+0.0001),10,2)asPDCH率,SUM(CELLGPRS.ALLPDCHPEAK)as最大的PDCH量,SUM(CELLGPRS.PREEMPTPDCH)ASPDCH空次数,0/),10,2)aspreem_load,LGPRS.DLBPDCH+TRAFDLGPRS.DLGPDCH+TRAFDLGPRS.DLEPDCH),10,2)asshare_on_b_g_e_dl,LGPRS.ULBPDCH+TRAFULGPRS.ULGPDCH+TRAFULGPRS.ULEPDCH),10,2)asshare_on_b_g_e_ul,STR(SUM(TRAFDLGPRS.DLTBFPEPDCH)/SUM(TRAFDLGPRS.DLEPDCH+0.0001),10,2)asshare_on_e_dl,STR(SUM(TRAFULGPRS.ULTBFPEPDCH)/SUM(TRAFULGPRS.ULEPDCH+0.0001),10,2)asshare_on_e_ul,10,2)as每分种预清空影响到的TBFSTR(100*SUM(CELLGPRS.FAILDLTBFEST)/SUM(CELLGPRS.DLTBFEST+0.0001),10,2)as行PDCH)上行PDCH拥塞率,2)astbf_min_per_inter_ra_csl,2)as.0001),10,2)as.0001),10,2)ascs_bler_ul,PRS.CELLMOVED)ASRP移次3、SELECTBSCGPRS_ADM.TIMEASDATE,BSCGPRS.MOASBSC,STR(100*(BSCGPRS.GSL8190+BSCGPRS.GSL9100)/BSCGPRS.GSLSCAN,10,2)ASGSL80160+BSCGPRS2.RPP6180+BSCGPRS2.RPP8190+BSCGPRS2.RPP9100+0.0001),10,2)ASBSCGPRS.ALLPDCHPCUFAILASRPPGSLPDCHBSCGPRS.FAILMOVECELLASRPPPDCH4、SELECTCELLGPRS_ADM.TIMEASDATE,CELLGPRS_ADM.NEASBSC,CELLGPRS.MOASCELL,ATA+CELLQOSEG.DLTHP3EGDATA),10,2)ASIPATA+CELLQOSEG.ULTHP3EGDATA),10,2)ASIP5BREGPRSTBF+RLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF),10,2)ASRLCSTR((CELLGPRS.CS12ULACK/1000+CELLGPRS.MC19ULACK/1000),10,2)ASRLCQOSG.DLTHP3GDATA+0.0001),10,2)ASGPRSIPDLTHP3GDATA),10,2)ASGPRSIPQOSG.ULTHP3GDATA+0.0001),10,2)ASGPRSIPULTHP3GDATA),10,2)ASGPRSIPHP2EGDATA+CELLQOSEG.DLTHP3EGDATA+0.0001),10,2)ASEDGEIPLQOSEG.DLTHP3EGDATA),10,2)ASEDGEIPHP2EGDATA+CELLQOSEG.ULTHP3EGDATA+0.0001),10,2)ASEDGEIPLQOSEG.ULTHP3EGDATA),10,2)ASEDGEIPPRS2.LDISRR+CELLGPRS2.LDISOTH+CELLGPRS2.FLUDISC+0.0001),10,2)ASTBFTRAFDLGPRS.TBFDLGPRSASGPRSTBF,TRAFDLGPRS.TBFDLEGPRSASEDGETBF,CELLGPRS2.LDISTFIASNO_PDCH_TFI_LLCPDUCELLGPRS2.LDISRRASLLCPDU,CELLGPRS2.LDISOTHASLLCPDU,CELLGPRS2.FLUDISCASRACRSLLCPDUPRS2.PREJTFI+CELLGPRS2.PREJOTH+0.0001),10,2)ASTBFTRAFULGPRS.TBFULGPRSASGPRSTBF,TRAFULGPRS.TBFULEGPRSASEDGE上行TBF数量,CELLGPRS2.IAULRELAS无线原因致上行TBF关闭次数,CELLGPRS2.PREJTFIAS无PDCH或USF或TFI致分组接 CELLGPRS2.PREJOTHAS其他原因致分组接 LQOSG.DLTHP3GPFC+0.0001),10,2)ASGPRS_LLC_DATA_PER_PFC_DL,LQOSG.ULTHP3GPFC+0.0001),10,2)ASGPRS_LLC_DATA_PER_PFC_UL,LTHP2EGPFC+CELLQOSEG.DLTHP3EGPFC+0.0001),10,2)ASEDGE_LLC_DATA_PER_PFC_DL,LTHP2EGPFC+CELLQOSEG.ULTHP3EGPFC+0.0001),10,2)ASEDGE_LLC_DATA_PER_PFC_UL,LLQOSEG.DLTHP2EGDATA+CELLQOSEG.DLTHP3EGDATA+0.0001)*100,10,2)ASLLCEDGELLQOSEG.ULTHP2EGDATA+CELLQOSEG.ULTHP3EGDATA+0.0001)*100,10,2)ASLLCEDGESTR(CELLGPRS.CS12DLACK/(CELLGPRS.CS12DLSCHED*20+0.0001),10,2)ASCS12RLCSTR(CELLGPRS.CS12ULACK/(CELLGPRS.CS12ULSCHED*20+0.0001),10,2)ASCS12RLCSTR(CELLGPRS.CS12DLACK/1000,10,2)ASCS12RLCSTR(CELLGPRS.CS12ULACK/1000,10,2)ASCS12RLCRLINKBITR.INT50BREGPRSTBF+RLINKBITR.INT55BREGPRSTBF+0.0001),10,2)ASEDGERLCBF+RLINKBITR.INT55BREGPRSTBF),10,2)ASEDGERLCINT10INT15INT20INT25INT30INT35INT40INT45INT50INT55STR(CELLGPRS.MC19ULACK/(CELLGPRS.MC19ULSCHED*20+0.0001),10,2)ASEDGERLCSTR(CELLGPRS.MC19ULACK/1000,10,2)ASEDGERLCBF+RLINKBITR.INT55BREGPRSTBF)+CELLGPRS.CS12DLACK/1000+0.0001)*100,10,2)ASEDGE的RLC层下行占用比,000+0.0001)*100,10,2)ASEDGE的RLC层上行占用比,OTH+CELLGPRS2.FLUDISC+0.0001),10,2)AS无线原因 释放的TBF比例,N+TRAFGPRS2.TRAFF2GTBFSCAN+0.0001),10,2)ASGPRS多时隙利用率,STR(100*(TRAFGPRS2.MUTILEGPRS)/(TRAFGPRS2.TRAFF2ETBFSCAN+0.0001),10,2)asEDGEPRS2.MUTIL22+0.0001),10,2)asTBFSTR(TRAFDLGPRS.DLTBFPEPDCH/(TRAFDLGPRS.DLEPDCH+0.0001),10,2)asEDGESTR(TRAFULGPRS.ULTBFPEPDCH/(TRAFULGPRS.ULEPDCH+0.0001),10,2)asEDGE1),10,2)astbf_minutes_per_inter_RA_csl,1),10,2)asCELLGPRS.PCHALLFAILASPDCH,CELLGPRS.PCHALLATTASPDCHPDCHSTR(CELLGPRS.ALLPDCHACC/(CELLGPRS.ALLPDCHSCAN+0.0001),10,2)asPDCH数,STR(CELLGPRS.ALLPDCHACTACC/(CELLGPRS.ALLPDCHSCAN+0.0001),10,2)asPDCHSTR(CELLGPRS.ALLPDCHACTACC/(CELLGPRS.ALLPDCHACC+0.0001),10,2)asPDCH ),10,2)aspreem_load,(TRAFDLGPRS.DLBPDCH+TRAFDLGPRS.DLGPDCH+TRAFDLGPRS.DLEPDCH+0.0001),10,2)as(TRAFULGPRS.ULBPDCH+TRAFULGPRS.ULGPDCH+TRAFULGPRS.ULEPDCH+0.0001),10,2)asSTR(TRAFDLGPRS.DLTBFPEPDCH/(TRAFDLGPRS.DLEPDCH+0.0001),10,2)asSTR(TRAFULGPRS.ULTBFPEPDCH/(TRAFULGPRS.ULEPDCH+0.0001),10,2)as0001),10,2)asTBFSTR(100*CELLGPRS.FAILDLTBFEST/(CELLGPRS.DLTBFEST+0.0001),10,2)asPDCH,2)asPDCH1),10,2)astbf_min_per_inter_ra_csl,1),10,2)asCHED+0.0001),10,2)asCHED+0.0001),10,2)ascs_bler_ul,LMOVEDASRP5、 T)AS,SUM(NCELLREL.HOVERSUC)ASSUM(NCELLREL.HORTTOCH)AS数 T-NCELLREL.HOVERSUC-NCELLREL.HORTTOCH)AS切换丢失 T),10,2)ASSUM(NICELHO.HOTOLCL)ASLSUM(NICELHO.HOTOKCLASKSUM(NICELHO.HOUPLQA)AS上行质差引起的切换申请,SUM(NICELHO.HODWNQA)AS下行质差引起的切换申请,SUM(NICELHO.HOEXCTA)ASTASUM(NICELHO.HOTOHCS)ASHCSSUM(NICELHO.HODUPFT)AS十秒切换返回次数,SUM(NICELASS.HOASBCL)ASBCELSUM(NICELASS.HOASWCL)ASWCELSUM(NICELASS.HOSUCBCL)ASBCELSUM(NICELASS.HOSUCWCL)ASWCEL6、 T)AS,SUM(NECELLREL.HOVERSUC)ASSUM(NECELLREL.HORTTOCH)AS数 T-NECELLREL.HOVERSUC-NECELLREL.HORTTOCH)AS切换 T+0.0001),10,2)ASSUM(NECELHO.HOTOLCLASLSUM(NECELHO.HOTOKCLASKSUM(NECELHO.HOUPLQA)AS上行质差引起的切换申请,SUM(NECELHO.HODWNQA)AS下行质差引起的切换申请,SUM(NECELHO.HOEXCTA)ASTASUM(NECELHO.HOTOHCS)ASHCSSUM(NECELHO.HODUPFT)AS十秒切换返回次数,SUM(NECELASS.HOASBCL)ASBCELSUM(NECELASS.HOASWCL)ASWCELSUM(NECELASS.HOSUCBCL)ASBCELSUM(NECELASS.HOSUCWCL)ASWCELSELECTCELLCCHHO_ADM.TIMEAS SUM(CELLCCHHO.CCHHOTOCH)ASSD T-CELLCCHHO.CCHHOSUC-CELLCCHHO.CCHHOTOCH)ASSD T+0.001),10,2)ASSD T+0.0001),10,2)AS7、SELECTCELLCCHHO_ADM.TIMEASDATE,CELLCCHHO_ADM.NEASBSC,CELLCCHHO.MOASTASSD,CELLCCHHO.CCHHOSUCASSDCELLCCHHO.CCHHOTOCHASSD T+0.001),10,2)ASSD T+0.001),10,2)ASSD T+0.0001),10,2)ASSD率8、HO_E_CELL2CELLNECELLREL.HORTTOCHAS数 T-NECELLREL.HOVERSUC-NECELLREL.HORTTOCH)AS切换丢失 T+0.0001),10,2)ASNECELHO.HOTOLCLASLNECELHO.HOTOKCLASKNECELHO.HOUPLQAAS上行质差引起的切换申请,NECELHO.HODWNQAAS下行质差引起的切换申请,NECELHO.HOEXCTAASTANECELHO.HOTOHCSASHCSNECELHO.HODUPFTAS十秒切换返回次数,NECELASS.HOASBCLASBCELNECELASS.HOASWCLASWCELNECELASS.HOSUCBCLASBCELNECELASS.HOSUCWCLASWCEL9、HO_I_CELL2CELLSELECTNCELLREL_ADM.TIMEASDATE,NCELLREL_ADM.NEASBSC,NCELLREL.MOASMO,LEFT(NCELLREL.MO,6)ASOUTCELL,RIGHT(NCELLREL.MO,6)ASINCELL TAS数,NCELLREL.HOVERSUCAS切换成功次数,NCELLREL.HORTTOCHAS T-NCELLREL.HOVERSUC-NCELLREL.HORTTOCH)AS切换丢失次数, T+0.0001),10,3)AS切换成功率,NICELHO.HOTOLCLASLNICELHO.HOTOKCLASKNICELHO.HOUPLQAAS上行质差引起的切换申请,NICELHO.HODWNQAAS下行质差引起的切换申请,NICELHO.HOEXCTAASTANICELHO.HOTOHCSASHCSNICELHO.HODUPFTAS十秒切换返回次数,NICELASS.HOASBCLASBCELNICELASS.HOASWCLASWCELNICELASS.HOSUCBCLASBCELNICELASS.HOSUCWCLASWCEL10、SELECTRANDOMACC_ADM.TIMEASDATE,SUM(CELLPAG.PAGPCHCONG)ASSUM(CELLPAG.PAGETOOOLD)ASSUM(CCCHLOAD.REJCSIMMASS)ASCS域的立即指 息,SUM(CCCHLOAD.REJPSIMMASS)ASPS域的立即指配 100*SUM(CCCHLOAD.REJCSIMMASS)/SUM(CCCHLOAD.CSIMMASS+0.0001)ASCS域的立即指 百分比 T)AS,SUM(RANDOMACC.RAACCFA)AS入失败次数,SUM(RANDOMACC.RAEMCAL)AS,SUM(RANDOMACC.RACALRE)ASSUM(RANDOMACC.RAANPAG)ASSUM(RANDOMACC.RAOSREQ)AS接入的呼叫次数,SUM(RANDOMACC.RAOTHER)AS随即接入中的位置更新次数, AS T+0.0001)ASSUM(CELTCHFP.TFCONGPGSM)ASTFCONGPGSM,SUM(CLTCH.TCASSALLAS成功占用次数,SUM(CLTCH.TASSALL)ASTCHT+RANDOMACC.RAACCFA+0.0001))AS无线接入成功率, ASRA_SD_SUC_R,100*SUM(CLSDCCH.CMSESTAB)/SUM(CLSDCCH.CCALLS+0.0001)ASSD成100*SUM(CLTCH.TCASSALL)/SUM(CLTCH.TASSALL+0.0001)ASTCH TOP20 DROP,CLSDCCH_ADM.TIMEASDATE,CLSDCCH_ADM.NEASBSC,CLSDCCH.MOASCELL,CLSDCCH.CCONGS,CLSDCCH.CTCONGS, SCAN+0.0001),10,2)ASSD STR(CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001),10,2)ASSDTASSD12、SELECTTOP20CELTCHF.TFNDROP,CELTCHF_ADM.TIMEASDATE,CELTCHF_ADM.NEASBSC,CELTCHF.MOASCELL,CELTCHFP.TFCONGPGSMSUBASTFCONGPGSMSUB,CELTCHH.THNDROPASTHNDROP,CELTCHFP.TFESTPGSMSUBASTFESTPGSMSUB,CELTCHF.TFCONGSASASTFCONGSAS,CELTCHF.TFCONGSHO,CELTCHH.THCONGSASASTHCONGSAS,CELTCHH.THCONGSHOASTHCONG TASTCH定义的信道数, T*100,10,2)ASTCH信道可用率, T,10,2)ASTCHLTCHH.THTRALACC/CELTCHH.THNSCAN),10,2)ASTCHSTR((CELTCHF_ADM.RPL/60*CELTCHF.TFTRALACC/CELTCHF.TFNSCAN),10,2)ASTCH13、SELECTCELTCHF_ADM.TIMEASDATE,COUNT(DISTINCTCELTCHF_ADM.NE)ASBSC数量,COUNT(CELTCHF.MO)AS小区数量,TCHH_ADM.RPL/60*CELTCHH.THTRALACC/(CELTCHH.THNSCAN+0.0001))),10,2)asTCH话务STR(SUM(CELTCHF_ADM.RPL/60*CELTCHF.TFTRALACC/(CELTCHF.TFNSCAN+0.0001)),10,2)ASTCHSTR(SUM(CELTCHH_ADM.RPL/60*CELTCHH.THTRALACC/(CELTCHH.THNSCAN+0.0001)),10,2)ASTCHCONGPGSMSUB),10,2)AS话务掉话比,ELTCHF.TFNDROP+0.0001),10,2)AS全速率话务掉话比,ELTCHH.THNDROP+0.0001),10,2)AS半速率话务掉话比,SUM(CELTCHFP.TFCONGPGSMSUB)ASTCHSUM(CELTCHF.TFNDROP)ASTCHSUM(CELTCHH.THNDROP)ASTCHSUM(CELTCHF.TFNDROP+CELTCHH.THNDROPASTCH1),10,2)ASTCHSTR(100*SUM(CELTCHF.TFNDROP)/SUM(CELTCHF.TFMSESTB+0.0001),10,2)ASTCHSTR(100*SUM(CELTCHH.THNDROP)/SUM(CELTCHH.THMSESTB+0.0001),10,2)ASTCHROP+0.0001),10,2)ASTA.0001),10,2)AS弱信号掉话比,NDROP+0.0001),10,2)AS下行弱信号掉话比,NDROP+0.0001),10,2)AS上行弱信号掉话比,NDROP+0.0001),10,2)AS上下行弱信号掉话比,DROP+0.0001),10,2)AS质差掉话比,THNDROP+0.0001),10,2)AS下行质差掉话比,THNDROP+0.0001),10,2)AS上行质差掉话比,THNDROP+0.0001),10,2)AS上下行质差掉话比,NDROP+0.0001),10,2)AS突然掉话比,S-CLTCHDRH.THSUDLOS)/SUM(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001),10,2)AS其他STR(100*SUM(CLTCHDRF.TFDISTA)/SUM(CELTCHF.TFNDROP+0.0001),10,2)ASTATFNDROP+0.0001),10,2)AS全速率弱信号掉话比,STR(100*SUM(CLTCHDRF.TFDISSDL)/SUM(CELTCHF.TFNDROP+0.0001),10,2)AS全速率下行STR(100*SUM(CLTCHDRF.TFDISSUL)/SUM(CELTCHF.TFNDROP+0.0001),10,2)AS全速率上行STR(100*SUM(CLTCHDRF.TFDISSBL)/SUM(CELTCHF.TFNDROP+0.0001),10,2)AS全速率上下HF.TFNDROP+0.0001),10,2)AS全速率质差掉话比,STR(100*SUM(CLTCHDRF.TFDISQADL)/SUM(CELTCHF.TFNDROP+0.0001),10,2)ASSTR(100*SUM(CLTCHDRF.TFDISQAUL)/SUM(CELTCHF.TFNDROP+0.0001),10,2)ASSTR(100*SUM(CLTCHDRF.TFDISQABL)/SUM(CELTCHF.TFNDROP+0.0001),10,2)ASSTR(100*SUM(CLTCHDRF.TFSUDLOS)/SUM(CELTCHF.TFNDROP+0.0001),10,2)AS全速率突然TCHDRF.TFSUDLOS)/SUM(CELTCHF.TFNDROP+0.0001),10,2)AS全速率其他掉话比,STR(100*SUM(CLTCHDRH.THDISTA)/SUM(CELTCHH.THNDROP+0.0001),10,2)AS半全速率TATHNDROP+0.0001),10,2)AS半速率弱信号掉话比,STR(100*SUM(CLTCHDRH.THDISSDL)/SUM(CELTCHH.THNDROP+0.0001),10,2)AS半速率下行STR(100*SUM(CLTCHDRH.THDISSUL)/SUM(CELTCHH.THNDROP+0.0001),10,2)AS半速率上行STR(100*SUM(CLTCHDRH.THDISSBL)/SUM(CELTCHH.THNDROP+0.0001),10,2)AS半速率上下HH.THNDROP+0.0001),10,2)AS半速率质差掉话比,STR(100*SUM(CLTCHDRH.THDISQADL)/SUM(CELTCHH.THNDROP+0.0001),10,2)ASSTR(100*SUM(CLTCHDRH.THDISQAUL)/SUM(CELTCHH.THNDROP+0.0001),10,2)ASSTR(100*SUM(CLTCHDRH.THDISQABL)/SUM(CELTCHH.THNDROP+0.0001),10,2)ASSTR(100*SUM(CLTCHDRH.THSUDLOS)/SUM(CELTCHH.THNDROP+0.0001),10,2)AS半速率突然TCHDRH.THSUDLOS)/SUM(CELTCHH.THNDROP+0.0001),10,2)AS半速率其他掉话比,SUM(CLSDCCH.CCALLS)ASSDCCHSUM(CLSDCCH.CMSESTAB)ASSDCCHSUM(CELTCHF.TFCALLS)ASTCHSUM(CELTCHH.THCALLS)ASTCHSUM(CELTCHF.TFMSESTB)ASTCHSUM(CELTCHH.THMSESTB)ASTCHSUM(CLTCH.TASSALL)ASTCHSUM(CLTCH.TCASSALL)ASTCHSTR(100*SUM(CLSDCCH.CCONGS)/SUM(CLSDCCH.CCALLS+0.0001),10,2)ASSD拥塞率, DROP)ASSD掉话次数, DROP)/SUM(CLSDCCH.CMSESTAB+0.0001),10,2ASSDSUM(CLSDCCH.CCONGS)ASSDSUM(CLSDCCH.CTCONGS)ASSD拥塞时间, 001),10,2)ASSDSTR(SUM(CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001)),10,2)ASSD T)ASSD DROP+0.0001),10,2)ASSD的TA掉话比, DROP+0.0001),10,2)ASSD弱信号掉 DROP+0.0001),10,2)ASSD质差掉话比, DROP+0.0001),10,2)ASSD其他原因掉话比,ASSDSUM(CLTCH.TCHSIG)ASTCHSD T)ASTCH定义的信道数,STR(SUM(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001)),10,2)ASTCH可用的信道数, 0,2)ASTCH信道可用率, +0.0001),10,2)ASTCHSUM(CELTCHFP.TFESTPGSMSUB)ASTCHSTR(100*SUM(CELTCHFP.TFESTPGSMSUB)/SUM(CLTCH.TASSALL+0.0001),10,2)ASTCH拥塞SUM(CELTCHF.TFCONGSAS)ASTCHSUM(CELTCHF.TFCONGSHO)ASTCHSUM(CELTCHH.THCONGSAS)ASTCHSUM(CELTCHH.THCONGSHO)ASTCHONGSHO+0.0001),10,2)ASTCHONGSHO+0.0001),10,2)ASTCHTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001),10,2)ASICM_FU1,TCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001),10,2)ASICM_FU2,TCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001),10,2)ASICM_FU3,TCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001),10,2)ASICM_FU4,TCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001),10,2)ASICM_FU514、ASSUM(CELLPAG.PAGETOOOLD)ASASCS域的立即指配消息,SUM(CCCHLOAD.PSIMMASS)ASPS域的立即指配消息,SUM(CCCHLOAD.REJCSIMMASS)ASCS域的立即指配 消息,SUM(CCCHLOAD.REJPSIMMASS)ASPS域的立即指配 100*SUM(CCCHLOAD.REJCSIMMASS)/SUM(CCCHLOAD.CSIMMASS+0.0001)ASCS域的立即指配拒绝百分比,100*SUM(CCCHLOAD.REJPSIMMASS)/SUM(CCCHLOAD.PSIMMASS+0.0001)ASPS域立即指 百分比 T)AS,SUM(RANDOMACC.RAACCFA)AS败次数,SUM(RANDOMACC.RAEMCAL)AS,SUM(RANDOMACC.RACALRE)ASRACALRE,SUM(RANDOMACC.RAANPAG)ASSUM(RANDOMACC.RAOSREQ)AS的呼叫次数,SUM(RANDOMACC.RAOTHER)AS T+RANDOMACC.RAACCFA+0.0001) T+0.0001)AS随即接入中的位置更用次数,SUM(CLTCH.TASSALL)ASTCHT+RANDOMACC.RAACCFA+0.0001))AS无线接入成功率, T+RANDOMACC.RAACCFA+0.0001)ASRA_SD_SUC_R,100*SUM(CLSDCCH.CMSESTAB)/SUM(CLSDCCH.CCALLS+0.0001)ASSD成功占100*SUM(CLTCH.TCASSALL)/SUM(CLTCH.TASSALL+0.0001)ASTCH15、SELECTCELTCHF_ADM.TIMEASDATE,CELTCHF_ADM.NEASBSC,COUNT(CELTCHF.MO)AS60*CELTCHH.THTRALACC/CELTCHH.THNSCAN))asTCHSUM(CELTCHF_ADM.RPL/60*CELTCHF.TFTRALACC/CELTCHF.TFNSCAN)ASTCHSUM(CELTCHH_ADM.RPL/60*CELTCHH.THTRALACC/CELTCHH.THNSCAN)ASTCHPL/60*CELTCHH.THTRALACC/CELTCHH.THNSCAN))/SUM(CELTCHFP.TFCONGPGSMSUB)ASP)AS全速率话务掉话比,P+0.0001)AS半速率话务掉话比,SUM(CELTCHFP.TFCONGPGSMSUB)ASTCHSUM(CELTCHF.TFNDROP)ASTCHSUM(CELTCHH.THNDROP)ASTCHSUM(CELTCHF.TFNDROP+CELTCHH.THNDROPASTCH100*SUM(CELTCHF.TFNDROP)/SUM(CELTCHF.TFMSESTB)ASTCH100*SUM(CELTCHH.THNDROP)/SUM(CELTCHH.THMSESTB+0.0001)ASTCHASTA P)AS下行弱信号掉话比,P)AS上行弱信号掉话比,P)AS上下行弱信号掉话比,AS质差掉话比,ROP)AS下行质差掉话比,ROP)AS上行质差掉话比,ROP)AS上下行质差掉话比,P)ASTCHDRH.THSUDLOS)/SUM(CELTCHF.TFNDROP+CELTCHH.THNDROP)AS其他掉话比,100*SUM(CLTCHDRF.TFDISTA)/SUM(CELTCHF.TFNDROP)ASTAROP)AS全速率弱信号掉话比,100*SUM(CLTCHDRF.TFDISSDL)/SUM(CELTCHF.TFNDROPAS100*SUM(CLTCHDRF.TFDISSUL)/SUM(CELTCHF.TFNDROPAS100*SUM(CLTCHDRF.TFDISSBL)/SUM(CELTCHF.TFNDROPASFNDROP)AS全速率质差掉话比,100*SUM(CLTCHDRF.TFDISQADL)/SUM(CELTCHF.TFNDROP)AS100*SUM(CLTCHDRF.TFDISQAUL)/SUM(CELTCHF.TFNDROP)AS100*SUM(CLTCHDRF.TFDISQABL)/SUM(CELTCHF.TFNDROP)AS100*SUM(CLTCHDRF.TFSUDLOS)/SUM(CELTCHF.TFNDROPASRF.TFSUDLOS)/SUM(CELTCHF.TFNDROP)AS全速率其他掉话比,.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)ASICM_FU1,.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)ASICM_FU2,.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)ASICM_FU3,.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)ASICM_FU4,.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)ASICM_FU5,SUM(CLSDCCH.CCALLS)ASSDCCHSUM(CLSDCCH.CMSESTAB)ASSDCCHSUM(CELTCHF.TFCALLS)ASTCHSUM(CELTCHH.THCALLS)ASTCHSUM(CELTCHF.TFMSESTB)ASTCHSUM(CELTCHH.THMSESTB)ASTCHSUM(CLTCH.TASSALL)ASTCHSUM(CLTCH.TCASSALL)ASTCH100*SUM(CLSDCCH.CCONGS)/SUM(CLSDCCH.CCALLS+0.0001)ASSD拥塞率, DROP)ASSD掉话次数, DROP)/SUM(CLSDCCH.CMSESTAB+0.0001)ASSDSUM(CLSDCCH.CCONGS)ASSDSUM(CLSDCCH.CTCONGS)ASSD拥塞时间, SCAN)ASSD话务量, T)ASSD信道可用SUM(CLSDCCH.CAVAACC/CLSDCCH.CAVASCAN)ASSD T)ASSD定义的信道数, DROP+0.0001)ASSD的TA掉话比, DROP+0.0001)ASSD DROP+0.0001)ASSD DROP+0.0001)ASSDSUM(CLTCH.TCHSIG)ASTCHSD T)ASTCH定义的信道数, T)ASTCH信道可用率, T)ASTCH每信道话务量,SUM(CELTCHFP.TFESTPGSMSUB)ASTCH拥塞次数,100*SUM(CELTCHFP.TFESTPGSMSUB)/SUM(CLTCH.TASSALL+0.0001)ASTCH拥塞率,SUM(CELTCHF.TFCONGSAS)ASTCH旧的拥塞次数,SUM(CELTCHF.TFCONGSHO)ASTCHSUM(CELTCHH.THCONGSAS)ASTCHSUM(CELTCHH.THCONGSHO)ASTCH16、 CELL,CELTCHFP.TFCONGPGSMSUBASTCHTFCONGSAS,CELTCHFP.TFESTPGSMSUBASTCH 数 T*100,10,3)ASTCH信道可ASTCH)*100,10,3)ASTCH T<0.12THEN'idle'ELSE'busy' 1)>=3or100*CELTCHFP.TFESTPGSMSUB/(CLTCH.TASSALL+0.0001)>=5)THEN'worse'ELSE'good' )>=3THENELSE'good' 100*CELTCHFP.TFESTPGSMSUB/(CLTCH.TASSALL+0.0001)>=5THE