1.定制SQL
select cfg.devicename,cfg.targetip,cfg.instname,unix_date_to_oracle(st.TIMERECORDED),st.PROCPPMEM as mem_kb,st.PROCPPCPUPERC from "_PATROL__PRO_0_ST_VIEW" st,"_PATROL__PRO_0_CFG_VIEW" cfg where st.MOINSTID=cfg.moinstid and cfg.instname='vi' and st.PROCPPMEM is not null2.结果