| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Relation Between Oracle Sessions
('binary' encoding is not supported, stored as-is)
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 <hussain_at_skm.org.pk>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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: sfaroult_at_oriolecorp.com 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: ListGuru_at_fatcity.com (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).Received on Tue Nov 05 2002 - 02:28:38 CST
 |
 |