Re: Primary/non primary sessions

amogh wrote:
> Mladen Gogala wrote:
> > On Tue, 30 Aug 2005 16:33:48 +0530, amogh wrote:
> >
> >
> >>Hi,
> >>
> >>
> >>Is there a SYS table which indicates whether a session is primary or non
> >>primary? I tried using the v$session table, but none of the columns seem
> >>to indicate whether a session is primary or non-primary.
> >>
> >>I RTFM and STFW but couldnt find an answer. Any pointers would help!
> >>
> >>
> >
> > We, the people of comp.databases.oracle.server hold this truth to be self
> > evident: all oracle sessions are created equal. Well, sort of, if we
> > disregard the division on system and user, foreground and background, MTS
> > vs. dedicated server etc. What would be the primary session? Oracle
> > doesn't maintain hierarchical relationship between sessions, like Unix
> > between processes. There is no primary or parent session. To my knowledge,
> > there is no such thing as the primary session.
> >
> Self evident truths are self inflicted. A session in Oracle can have a
> non-migratable parent session. This is well documented and would not
> need explanation.
>
> Amogh

Only with distributed transactions, as non-distributed transactions have no parent session. If you're referring to such a configuration you need to state this in your question. You clearly did not, and, as such, Mladen's answer is correct. Your attitude with respect to the responses is deplorable, especially since you obviously have no concept of what you are attempting to discuss.

David FItzjarrell Received on Tue Aug 30 2005 - 09:59:27 CDT