select addr,pid,spid,username,program from v$process;
----
select p.spid from v$session s,v$process p where p.ADDR=s.PADDR;
---查看会话id
select sid from v$session where audsid=userenv('sessionid');
---查看sid=14的客户端进程的客户端进程和线程id,用session视图
select machine,program,username,status,process from v$session where sid=14;
---服务器的进程id,用session和process视图
select * from v$process p,v$session s where p.addr=s.PADDR and sid=14;