select ps.puser_name 账号,
to_number(substr(pl.pm_key, 0, 8), 'xxxxxxxx') as PID进程号,
ps.pnode_name 登陆主机名,
ps.plogin_date + interval '8' hour 上次登陆时间
from infodba.PM_PROCESS_LIST pl, infodba.PPOM_SESSION ps
where pl.PM_PROCESS_ID = ps.PPROCESS_ID
-- and ps.puser_name = '00766229' --输入用户账号
--and ps.pnode_name = 'z1100a61-c1371' --输入主机名
order by 登陆主机名,plogin_date desc;