按进程名称查看其内存和CPU使用SQL)
1.定制SQLselect 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.MOINSTIDcfg.moinstid and cfg.instnamevi and st.PROCPPMEM is not null2.结果 (BPPM)按进程名称查看其内存和CPU使用SQL
1.定制SQLselect 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.MOINSTIDcfg.moinstid and cfg.instnamevi and st.PROCPPMEM is not null2.结果