【資料名稱】：NOKIA pcu負(fù)荷查詢腳本

【資料作者】：g

【資料日期】：20130105

【資料語(yǔ)言】：中文

【資料格式】：DOC

【資料目錄和簡(jiǎn)介】：

主要提取NOKIAPCU負(fù)荷：
Select
c.Name,
c.nsei,
c.gprs,
decode(d.dap,Null,0,d.dap)dap,
c.gprs+decode(d.dap,Null,0,d.dap)subtsl,
(c.gprs+decode(d.dap,Null,0,d.dap))/1024*100 pcu_load
from
(Select
a.Name,
a.nseinsei,
sum(a.cdef_ch) gprs
from
( select
bsc.nameName,
C_BSC_BTS.BTS_NSEInsei,
C_BSC_BTS.BTS_LOC_AREA_ID_LAC lac,
C_BSC_BTS.BTS_CELL_ID,
bts.object_instance bts_id,
sum((
case when TRX_CH_0_TYPE=0 then 1 else 0 end + case when TRX_CH_1_type=0 then 1 else 0 end+
case when TRX_CH_2_type=0 then 1 else 0 end + case when TRX_CH_3_type=0 then 1 else 0 end+
case when TRX_CH_4_type=0 then 1 else 0 end + case when TRX_CH_5_type=0 then 1 else 0 end+
case when TRX_CH_6_type=0 then 1 else 0 end + case when TRX_CH_7_type=0 then 1 else 0 end+
case when TRX_CH_0_type=2 then 1 else 0 end + case when TRX_CH_1_type=2 then 1 else 0 end+
case when TRX_CH_2_type=2 then 1 else 0 end + case when TRX_CH_3_type=2 then 1 else 0 end+
case when TRX_CH_4_type=2 then 1 else 0 end + case when TRX_CH_5_type=2 then 1 else 0 end+
case when TRX_CH_6_type=2 then 1 else 0 end + case when TRX_CH_7_type=2 then 1 else 0 end ) *TRX_GPRS_ENA_TRX) gtch_num,

C_BSC_BTS.BTS_DGS_92 cdef_percent,