Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
Where is it documented? Can you provide a link? Received on Tue Aug 30 2005 - 10:57:02 CDT
![]() |
![]() |