Re: Find SID for oracle.exe

In message <1173041871.506416_at_bubbleator.drizzle.com>, DA Morgan <damorgan_at_psoug.org> writes
>astalavista wrote:
>> Hi,
>> On windows I have several instance,
>> if look at the task manager I see several oracle.exe.
>> Is there a simple way to find the SID of each oracle.exe
>> Thanks in advance
>
>There is no relationship between SID and oracle.exe.

Of course there is. It just might not be easy to find.

If you run tasklist /svc from a command window, it lists program name, process id and service name. The service name contains the ORACLE_SID.

Excerpt from one of my machines

nmesrvc.exe                  216 Oracleagent10gAgent
oracle.exe                   212 OracleServiceXE
TNSLSNR.EXE                  256 OracleXETNSListener

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>