SQL脚本NSN
请问谁有提取PCU负荷的脚本，最好是能分细点的(256,1024分开的）
提取小区SD拥塞明细的脚本
按天提降功率的
小区切换相关的，最好能提取单个BSC的所有小区切换KPI
请发我邮箱13628685427@163.com 谢谢
select to_char(period_stop_time,'yyyymmdd') datetime
,o_bsc.name bsc_name ,bearer_id ,max(nsvc_nsei) nsei ,MAX(c_nsvc.nsvc_committed_info_rate)*16 access_rate
,frbc_pcm_circuit_id||'-'||frbc_first_tsl||'-'||frbc_unit_index pcm
,decode(sum(c_nsvc.nsvc_committed_info_rate)*16,0,' --- ',to_char(100*max(8*(DLCI_1_BYTES_SENT+DLCI_2_BYTES_SENT+DLCI_3_BYTES_SENT+DLCI_4_BYTES_SENT+DLCI_5_BYTES_SENT)/(period_duration*60))/(MAX(c_nsvc.nsvc_committed_info_rate)*16),'990.00')) frl_7
,decode(sum(c_nsvc.nsvc_committed_info_rate)*16,0,' --- ',to_char(100*max(8*(DLCI_1_BYTES_REC+DLCI_2_BYTES_REC+DLCI_3_BYTES_REC+DLCI_4_BYTES_REC+DLCI_5_BYTES_REC)/(period_duration*60))/(MAX(c_nsvc.nsvc_committed_info_rate)*16),'990.00')) frl_8
from p_nbsc_frame_relay a ,objects o_bsc ,objects o_frbc ,objects o_nsvc ,c_bsc_frbc c_frbc,object_modestates s_nsvc ,c_bsc_nsvc c_nsvc
where to_char(period_stop_time,'yyyymmdd') = TO_CHAR(SYSDATE-1,'YYYYMMDD')
and o_bsc.int_id = a.int_id
and o_frbc.object_instance = a.bearer_id
and a.int_id in (select int_id from objects where object_class=3 and name like 'BSC4%')
and o_frbc.parent_int_id=o_bsc.int_id
and o_frbc.object_class = 464
and c_frbc.int_id = o_frbc.int_id
and c_frbc.conf_name = '<ACTUAL>'
and o_nsvc.parent_int_id=o_frbc.int_id
and o_bsc.object_class = 3
and o_nsvc.object_class = 465
and s_nsvc.int_id = o_nsvc.int_id
and s_nsvc.stateinmode1 = 1
and c_nsvc.int_id = o_nsvc.int_id
and c_nsvc.conf_name = '<ACTUAL>'
group by o_bsc.name ,bearer_id ,dlci_1_id ,dlci_2_id ,dlci_3_id ,dlci_4_id ,c_frbc.frbc_pcm_circuit_id ,c_frbc.frbc_first_tsl ,c_frbc.frbc_unit_index,to_char(period_stop_time,'yyyymmdd')