Hussain, This is just from the top of my head and therefore requires careful checking, but I presume that if you are not using MTS then the 2nd generation session must be initiated by your shadow process (hope you are under Unix!). V$SESSION holds the OS process id of the program on the 'client side' (eq sqlplus), and V$PROCESS contains the details about the shadow processes (SADDR lets you link with V$SESSION). This is where I would have a look. If my theory is right, the 'middle generation' process id should be both in V$SESSION and V$PROCESS.
HTH Stephane Faroult >----- Original Message ----- >From: Hussain Ahmed Qadri <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 04 Nov 2002 21:08:21 > >Hi all, >A question related to Developer but involves >forming sessions at the >backend, so would appreciate any help or ideas. > >Whenever a form is opened, it opens an Oracle >session (can be seen from >v$session). Now when we call another form from this >opened form, (call form >property of forms), it will open another session. >If we consider the main >form as the parent form and the form called from >within it as its child >form, then, IS there a way to know, from some view >or else, that session of >this newly opened form is the child of which parent >session, their >relationship basically? > >Thanks in advance > >Hussain Ahmed Qadri >DBA SKMCH&RC >Pakistan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
