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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Track the sessions

Re: Track the sessions

From: Muhammed Soyer <msoyer_at_gmail.com>
Date: Mon, 12 Jun 2006 07:31:54 +0300
Message-ID: <23e9386e0606112131w4d8a02beye137fd3b2b4c31a4@mail.gmail.com>


Hi Mladen,

   From your writings it seems that it is not possible what I want . I was wanting to track the parent-child ring ..

Very Thanks for your detailed reply ..

Muhammed Soyer

2006/6/12, Mladen Gogala <gogala_at_sbcglobal.net>:
>
>
> On 06/11/2006 11:50:24 PM, Muhammed Soyer wrote:
> > Hi Friends,
> > I want to ask if I can track the sessions . I mean I start an oracle
> forms
> > 6i application on my machine A session is opened for the main window.
> > When I click a menu item a new window is opened and an other session is
> > opened for that window . I didnt give any user information for the
> second
> > session it takes the required login information from the first one in a
> way
>
> There is an arcane and very little known view called V$SESSION. It may be
> used to
> track and obtain information about the currently connected users. If you
> need history,
> it's called "auditing". You can audit sessions by a statement which reads
> "AUDIT
> SESSION". If you don't want failed connection attempts in DBA_AUDIT_TRAIL,
> you can
> say something like "AUDIT SESSION WHENEVER SUCCESSFUL";
>
> > .
> > I wonder if I can track the second session and find who its forked from
> ?
>
> Unfortunately, Oracle doesn't establish parent - child relationship among
> sessions. That means that there isn't a parent session or anything of the
> sort.
> Also, one session can execute one SQL at any given time. There is no
> concept
> of a multi-threaded sessions. Personally, I see Oracle RDBMS as a database
> management software and a TP monitor and I don't think that these entities
> would necessarily be an improvement. There is no need for that, at least
> in
> my opinion. Every session has a client PID which issued a connection
> request
> recorded in PROCESS field of V$SESSION. Here is what it looks like:
>
> SQL> select sid from v$session where
> audsid=SYS_CONTEXT('USERENV','SESSIONID');
> SID
> ----------
> 54
>
> SQL> select process from v$session where sid=54;
>
> PROCESS
> ------------
> 4316
>
> In the other terminal:
> $ ps -fp 4316
> UID PID PPID C STIME TTY TIME CMD
> mgogala 4316 2608 0 00:05 pts/1 00:00:00 sqlplus
> $
>
> The V$SESSION table also has a "MACHINE" column. You can establish parent
> child
> relationship between the originating processes your self by using ps
> command. It's
> an OS relationship, not an Oracle relationship. It should be investigated
> by using
> OS tools, electric shocks, sodium pentathol and blunt object traumas.
>
>
>
> --
> Mladen Gogala
> http://www.mgogala.com
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jun 11 2006 - 23:31:54 CDT

Original text of this message

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