Finding the Parent / Child SID's in Oracle HRMS

Hi,

        We have some interfaces where we create the SLAVE from a PARENT process and run it on multiple threads. This case for a interface there may be multiple SID's. One is parent and the other is the child.

       I need to find out all the child SID's under one parent SID.

       Is there any query to get the same ? I have only apps account privilages.

--

Regards,
Tanmoy

• "Time is the coin of life. Only you can determine how it will be spent."

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 06 2006 - 11:26:50 CDT