以下是基于GPRS平均占用數(shù)，建議設(shè)置CDEF的腳本，是根據(jù)數(shù)據(jù)優(yōu)化資料寫的，但是存在問題部分小區(qū)CDEF超過100，不知道問題出在哪里？麻煩哪位高手指導(dǎo)下，謝謝哈！

因字?jǐn)?shù)限制腳本未貼完，麻煩了，如果這個腳本錯誤，麻煩指出，謝謝！



SELECT --PDCHNUM.日期,
--PDCHNUM.時段,
PDCHNUM.NAME,
PDCHNUM.CELL_ID,
PDCHNUM.AVA16,
PDCHNUM.PEAK_GPRS,
CHNUM.DYNAMIC_PDCH CDEF_CH,
CHNUM.PDTCH,
(CASE
WHEN (CHNUM.DYNAMIC_PDCH > PDCHNUM.AVA16) THEN
'可減少'
WHEN (CHNUM.DYNAMIC_PDCH < PDCHNUM.AVA16) THEN
'需增加'
WHEN (CHNUM.DYNAMIC_PDCH = PDCHNUM.AVA16) THEN
'匹配'

ELSE
'其他'
END) || TO_NUMBER(ABS(CHNUM.DYNAMIC_PDCH - PDCHNUM.AVA16)) || '信道' 建議,
DECODE(CHNUM.PDTCH,
0,
0,
CEIL((DECODE((CASE
WHEN (PDCHNUM.AVA16 > 4) THEN
'5'
WHEN (PDCHNUM.AVA16 <= 4) THEN
'4'

ELSE
'4'
END),
4,
4,
5,
PDCHNUM.AVA16,
PDCHNUM.AVA16) / CHNUM.PDTCH) * 100)) 建議CDEF,
CHNUM.CDEF,
CHNUM.CDED,
CHNUM.CMAX,
CHNUM.SDCCH*8 sd,
PDCHNUM.AVA3,
PDCHNUM.UAV10,
PDCHNUM.PEAK_SD,
CHNUM.TCHF+CHNUM.TCHD 業(yè)務(wù)信道數(shù)量,
PDCHNUM.AVA28,
PDCHNUM.PEAK_TCH,
CHNUM.GENA,
CHNUM.EGENA,
CHNUM.NSEI,
CHNUM.CS34,
CHNUM.TRX_NUM,
CHNUM.EDGE_TRX,
CHNUM.TCHF,
CHNUM.TCHD,
CHNUM.GTRX,
CHNUM.EDGE_TRX_ACTIVE
FROM (SELECT --TO_CHAR(R.PERIOD_START_TIME, 'yyyymmdd') "日期",
--TO_CHAR(R.PERIOD_START_TIME, 'hh24') "時段",
BSC.NAME,
BTS.CELL_ID,
DECODE(SUM(R.AVE_GPRS_CHANNELS_DEN),
0,
0,
CEIL(SUM(R.AVE_GPRS_CHANNELS_SUM) /
SUM(R.AVE_GPRS_CHANNELS_DEN))) AVA16,/*Average PS territory-timeslot*/
decode(sum(ave_permanent_GPRS_ch_den),0,0,sum(ave_permanent_GPRS_ch_sum)/sum(ave_permanent_GPRS_ch_den)) ava17,/*Average available dedicated GPRS channels*/
SUM(R.PEAK_GPRS_CHANNELS) PEAK_GPRS,
DECODE(SUM(R.AVE_AVAIL_TCH_DEN),
0,
0,
ROUND(SUM(R.AVE_AVAIL_TCH_SUM) / SUM(R.AVE_AVAIL_TCH_DEN), 2)) ava28,/*Average CS TCH in normal TRXs-timeslot*/
DECODE(sum(res_av_denom3),0,0,ROUND(sum(ave_sdcch_sub)/sum(res_av_denom3),2)) ava3,/*Average available SDCCH*/
ROUND(avg(ave_non_avail_sdcch),4) uav10,/*Average unavailable SDCCH*/
SUM(PEAK_BUSY_SDCCH) PEAK_SD,
SUM(PEAK_BUSY_TCH) PEAK_TCH


FROM P_NBSC_RES_AVAIL R, OBJECTS BSC, C_BTS BTS
WHERE BTS.INT_ID = R.BTS_INT_ID
AND R.INT_ID = BSC.INT_ID
AND TO_CHAR(R.PERIOD_START_TIME, 'yyyymmddhh24') >= '&start_date'
AND TO_CHAR(R.PERIOD_START_TIME, 'yyyymmddhh24') <= '&end_date'
AND TO_CHAR(R.PERIOD_START_TIME, 'hh24') IN
('08',
'09',
'10',
'11',
'12',
'13',
'14',
'15',
'16',
'17',
'18',
'19',
'20',
'21',
'22',
'23')
AND BSC.NAME LIKE 'LUZBSC%'
--AND BTS.CELL_ID IN (&CI)
GROUP BY --TO_CHAR(R.PERIOD_START_TIME, 'yyyymmdd'),
--TO_CHAR(R.PERIOD_START_TIME, 'hh24'),
BSC.NAME,
BTS.CELL_ID
ORDER BY --TO_CHAR(R.PERIOD_START_TIME, 'yyyymmdd'),
--TO_CHAR(R.PERIOD_START_TIME, 'hh24'),
BSC.NAME,
BTS.CELL_ID) PDCHNUM,

(SELECT AA.CELL_ID CI,
AA.BSCNAME,
AA.BCF_ID BCF,
AA.SEGMENT_ID SEG,
AA.LAC,
AA.CDED,
AA.CDEF,
AA.CMAX,
AA.PDTCH,
CEIL(AA.CDEF / 100 * AA.PDTCH) DYNAMIC_PDCH,
AA.NCC,
AA.BCC,
AA.BCCH,
(CASE
WHEN AA.BCCH BETWEEN 1 AND 124 THEN
'900'
WHEN AA.BCCH BETWEEN 512 AND 885 THEN
'1800'
WHEN AA.BCCH BETWEEN 975 AND 1023 THEN
'E'
ELSE
''
END) BAND,
AA.BCF_TYPE,
AA.NSEI,
AA.GENA,
AA.EGENA,
AA.CS34,
AA.CBA,
AA.CBQ,
AA.FRL,
AA.FRU,
AA.TRP,
AA.BFG,
AA.MASTER_BTS,
AA.DMAX,
AA.TRX_NUM,
AA.EDGE_TRX,
AA.TCHF,
AA.TCHD,
AA.SDCCH,
AA.GTRX,
AA.DED_TSL,
AA.DEF_TSL,
MIN_PCM,
MAX_PCM,
AA.EGENA * AA.GTRX EDGE_TRX_ACTIVE,
AA.MCA,
AA.MCU,
AA.MBP,
AA.MBG,
AA.MFR,
AA.AG1,
AA.AG2,
TO_CHAR(SYSDATE - 1, 'YYYYMMDD') DATETIME
FROM (SELECT A.CELL_ID, --OMSC.NAME MSCNAME,
OBSC.NAME BSCNAME,
A.SEGMENT_ID,
A.SEGMENT_NAME,
OBCF.OBJECT_INSTANCE BCF_ID,
OBTS.OBJECT_INSTANCE BTS_ID,
DECODE(OBCF.BCF_TYPE,
0,
'2ND GEN',
1,
'TALK-FAMILY',
2,
'PRIMESITE',
3,
'METROSITE/CONNECT 10',
5,
'ULTRASITE',
6,
'FLEXI EDGE',
8,
'FLEXI MULTI',
'') BCF_TYPE,
A.RX_LEV_ACCESS_MIN - 110 RXP,
A.RADIO_LINK_TIMEOUT * 4 + 4 RLT,
CELL_RESELECT_PARAM_IND C2_ENABLE,
A.CELL_RESELECT_HYSTERESIS * 2 CRH,
A.GPRS_NON_BCCH_RX_LEV_LOWER - 110 GPL,
A.GPRS_NON_BCCH_RX_LEV_UPPER - 110 GPU,
A.CELL_RESELECT_OFFSET * 2 REO,
A.TEMPORARY_OFFSET * 10 TEO,
A.PENALTY_TIME * 20 + 20 PT,
A.NSEI,
A.GPRS_ENABLED GENA,
A.EGPRS_ENABLED EGENA,
A.CS3_CS4_ENABLED CS34,
A.CELL_BARRED CBA,
A.CELL_BAR_QUALIFY CBQ,
A.BTS_SP_LOAD_DEP_TCH_RATE_LOWER FRL,
A.BTS_SP_LOAD_DEP_TCH_RATE_UPPER FRU,
TRX_PRIORITY_IN_TCH_ALLOC TRP,
A.PREFER_BCCH_F_GPRS2 BFG,
A.MASTER_BTS,
A.DEDICATED_GPRS_CAPACITY CDED,
A.DEFAULT_GPRS_CAPACITY CDEF,
A.MAX_GPRS_CAPACITY CMAX,
A.DR_IN_USE,
A.DTX_MODE,
A.NON_BCCH_LAYER_OFFSET NBL,
A.DIRECT_GPRS_ACCESS_BTS DIRE,
A.EGPRS_INIT_MSC_ACK_MODE MCA,
A.EGPRS_INIT_MSC_UNACK_MODE MCU,
A.EGPRS_MEAN_BEP_OFFSET_8PSK MBP,
A.EGPRS_MEAN_BEP_OFFSET_GMSK MBG,
A.CALL_REESTABL_ALLOWED CALL_REESTABLSH,
A.NO_OF_M_FRAMES_BETWEEN_PAGING MFR,
A.NO_OF_BLOCKS_FOR_ACCESS_GRANT1 AG1,
A.NO_OF_BLOCKS_FOR_ACCESS_GRANT2 AG2,
A.EGPRS_LINK_ADAPT_ENABLED ELA,