How to Locate Database Process on OS
This script will map database process to the operating system process (spid), provide username and program (sqlplus, java etc...):select p.spid, s.username, s.program
from v$process p, v$session s
where p.addr=s.paddr order by 2, 3, 1
/
0 comments:
Post a Comment