whats the username that these sessions are opened/created from?
after opening do they persist for long time ? or they kind of runaway processes.
from the operating system check with the ps -ef command for the user/application to take a note of currently running processes.
were there any recent changes ?
you can execute:
you can use many columns:
Pay atention at:
Operating system client user name
MACHINE VARCHAR2(64) Operating system machine name PROGRAM VARCHAR2(48) Operating system program name
If you have PID you can use the next query to looking for "SID"
select sid, s.serial# from v$session s, v$process p where paddr=addr and SPID=<PIDNUMBER>