select ses.sid "SID会话号" ,proc.pid "PID_oracle进程号",proc.spid "SPID操作系统进程号", ses.schemaname ,
ses.osuser ,ses.process ,ses.machine ,ses.program ,proc.username,proc.pga_used_mem,
proc.pga_alloc_mem,proc.pga_freeable_mem,proc.pga_max_mem
from v$process proc,v$session ses
where proc.addr=ses.paddr
and ses.type='USER'
ses.osuser ,ses.process ,ses.machine ,ses.program ,proc.username,proc.pga_used_mem,
proc.pga_alloc_mem,proc.pga_freeable_mem,proc.pga_max_mem
from v$process proc,v$session ses
where proc.addr=ses.paddr
and ses.type='USER'