【資料名稱】：NSN T3101

【資料作者】：ME

【資料日期】：2011-5-21

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

SELECT a.period
,a.name
,a.cell_id
,a.segment_id
,a.IMM_ASSGN_SENT
,b.t3101_expired
,b.sdcch
,a.loc_update
,b.lu_attmpt
,b.lu_att_fail
,a.IMM_ASSGN_REJ
--,a.CH_REQ_MSG_REC
,a.TRX_DIAGNOSTIC
,a.TRX_DIAGNOSTIC_FAULT
--,a.ch_req_msg_rec
,a.del_ind_msg_rec
,a.SDCCH_CALL_RE_EST
,b.sdcch_moc_seiz_att
,b.sdcch_mtc_seiz_att
,A.SMS_REQ
,A.SUCC_SDCCH_SMS_EST
,A.UNSUCC_SDCCH_SMS_EST
from
(SELECT to_char(p.period_start_time, 'yyyymmddhh24') period
,o.name
,c.cell_id
,c.segment_id
,sum(P.IMM_ASSGN_SENT) IMM_ASSGN_SENT ,sum(P.IMM_ASSGN_REJ)IMM_ASSGN_REJ
,sum(P.CH_REQ_MSG_REC) CH_REQ_MSG_REC
,sum(P.TRX_DIAGNOSTIC) TRX_DIAGNOSTIC
,sum(P.TRX_DIAGNOSTIC_FAULT) TRX_DIAGNOSTIC_FAULT
,sum(p.ch_req_msg_rec) ch_req_msg_rec
,sum(p.del_ind_msg_rec) del_ind_msg_rec
,sum(p.ave_rach_slot) ave_rach_slot
,sum(p.ave_rach_busy) ave_rach_busy
,sum(P.SDCCH_CALL_RE_EST) SDCCH_CALL_RE_EST
,sum(p.sdcch_loc_upd) loc_update
,SUM(P.SMS_BC_REQ_SENT) SMS_REQ
,SUM(P.UNSUCC_SDCCH_SMS_EST) UNSUCC_SDCCH_SMS_EST
,SUM(P.SUCC_SDCCH_SMS_EST) SUCC_SDCCH_SMS_EST
from P_NBSC_RES_ACCESS P,objects o,c_bts c
where
p.int_id = o.int_id
and p.bts_int_id=c.int_id

and p.period_start_time >= to_date(&start_date,'yyyymmdd hh24')
and p.period_start_time <= to_date(&end_date,'yyyymmdd hh24')
and to_char(p.period_start_time,'hh24') in (&time)
group by to_char(p.period_start_time, 'yyyymmddhh24'),o.name,c.cell_id,c.segment_id) a,

(SELECT to_char(t.period_start_time, 'yyyymmddhh24') period
,o.name
,c.cell_id
,sum(t.sdcch_lu_attempt) lu_attmpt
,sum(t.sdcch_lu_attempt_fail) lu_att_fail
,sum(ser.T3101_EXPIRED) t3101_expired
,sum(t.sdcch_moc_seiz_att) sdcch_moc_seiz_att
,sum(t.sdcch_mtc_seiz_att) sdcch_mtc_seiz_att

,sum(T.sdcch_assign) sdcch from p_nbsc_traffic t,objects o,c_bts c,P_NBSC_SERVICE SER
where
t.int_id = o.int_id
and ser.bts_int_id=t.bts_int_id
and t.bts_int_id=c.int_id
and t.period_start_time=ser.period_start_time
and t.period_start_time >= to_date(&start_date,'yyyymmdd hh24')
and t.period_start_time <= to_date(&end_date,'yyyymmdd hh24')
and to_char(t.period_start_time,'hh24') in (&time)
group by to_char(t.period_start_time, 'yyyymmddhh24'),o.name,c.cell_id) b

where a.cell_id=b.cell_id
and a.period=b.period
and a.name=b.name