【资料名称】：NOKIA pcu负荷查询脚本

【资料作者】：g

【资料日期】：20130105

【资料语言】：中文

【资料格式】：DOC

【资料目录和简介】：

主要提取NOKIAPCU负荷：
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,