I am trying to find out the SID of a host based concurrent program but not able to do so.
The following query doesn't fetch me any results. But this works when the requests call a package in database.
SELECT * FROM V$SESSION
WHERE PROCESS IN(SELECT OS_PROCESS_ID
Can anyone please help me here?
apps - 12.1.3
OS - IBM AIX 6.1