Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Primary/non primary sessions

Re: Primary/non primary sessions

From: Bart the bear <bartthebear_at_gmail.com>
Date: 30 Aug 2005 08:57:02 -0700
Message-ID: <1125417422.838185.80090@o13g2000cwo.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US