Re: Track the sessions

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@xxxxxxxxxxxxx>: 


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


Other related posts: