|
-
Yap.. That's what I was using.. Using v$process.PID..
Anyway, below are the results which are same..
oracle@CG_JDA1:/home/oracle/admin/ODBMSPRD/bdump_> top
USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND
oracle 115508 28.0 0.0 30676 16048 - A 15:36:37 6:38 oracleODBMSPRD
wccprod 91612 21.4 0.0 7544 6480 - A 15:46:02 1:02 /home/wcc/app_sh
oracle 123160 4.5 1.0 48752 23364 - A 14:50:09 5:12 oracleODBMSPRD
wccprod 84960 3.2 0.0 9696 8632 - A 15:44:50 0:14 /home/wcc/app_sh
SQL> select substr(S.username,1,8) username, substr(osuser,1,10) osuser, process osprocess,
2 substr(machine,1,20) host,substr(P.terminal,1,10) terminal, type, sid, S.serial#,
3 substr(S.program ,1,25) program
4 from v$session S, V$PROCESS P
5 where P.pid = '123160'
6 and S.paddr=P.addr
7
SQL> /
no rows selected
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|