(BPPM)按进程名称查看其内存和CPU使用SQL

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 null

2.结果