Re: v$session and unix-level processes

From: <nomail_at_nowhere.fr>
Date: 1997/09/12
Message-ID: <34190EBF.9FC38BCB@nowhere.fr>

--------------30F2D0E8F58820290875E99F
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Another way I use with windows 3.1/ Windows 95 is to setup in
For Windows 3.11 (16 bit)
\Orawin\oracle.ini

    [Oracle]
    ...
    TERMINAL = Gerald
     USER = GeraldPoste125
    for each computer on the network

For Windows 95 (32 bits)

    Gerald.reg
    REGEDIT4     [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]     "TERMINAL"="tGERALD"
    "USER"="uGERALD"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE1] "TERMINAL"="tGERALD"
"USER"="uGERALD"

As a result the v$session report the terminal correctly instead of "Windows 95".

Tobias Hitzfeld wrote:

> Hi Brett!

>
> I just thought about the same problem today.
> I suppose, that the problem is: process in v$session is the process id
> of the frontend-process.
> The process-id you received by ps -ef is indeed the process id of the
> database - backend process!
> Just try:
>
> select a.username,a.sid,a.process "Frontendprocess",b.spid
> "Backendprocess",a.program
> from v$session a,v$process b
> where a.paddr=b.addr
> order by spid;
>
> So, you'll receive both, the process-ID from frontend (the remote
> machine) and backend (the machine, where the DB-engine is running at).
>
> Hope this is what you've searched for...
>
> Tobias Hitzfeld
> Oracle-DBA
> Hitzfeld_at_Schoepflin.de
>
> -----------------------------------------------------------------------
>
> ANOTHER question is:


>    HOW TO identify DB-Connections without an existing frontend-task

>                        (Win3.1/95 Clients) ???

> I've found the SQL*Net Parameter expire_time -> how does it work. Any


>                            suggestions ???

> -----------------------------------------------------------------------
>
> Brett C wrote:
>
>> Greetings all -
>>
>> We are running PeopleSoft and many entries in V$SESSION shows the
>> the
>> same value in the 'PROCESS' column.  However, a check via 'ps -ef'
>> at
>> Unix level shows a bunch of processes with information kinda like
>> the
>> following:
>>
>> oracleOURSIDNAME (LOCAL=NO)
>>
>> There are a bunch of these listed, but their associated process
>> shown at
>> the Unix level don't appear in V$SESSION.  Is there a way to
>> associate
>> these processes to the one they use in Oracle ?  I have been playing
>> with
>> LOGON_TIME and I think I can reasonably arrive at which process is
>> which, but
>> that is only a guess.
>>
>> Any ideas ?
>>
>> Thanks in advance for any assistance !
>>
>> Brett
>> zgeist.nospam_at_ee.net
>
>



--------------30F2D0E8F58820290875E99F

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<HTML>
Another way I use with windows 3.1/ Windows 95 is to setup

<BR>in
<BR>For Windows 3.11 (16 bit)
<BR>\Orawin\oracle.ini
<BR>&nbsp;&nbsp;&nbsp; [Oracle]
<BR>&nbsp;&nbsp;&nbsp; ...
<BR>&nbsp;&nbsp;&nbsp; TERMINAL = Gerald
<BR>&nbsp;&nbsp;&nbsp;&nbsp; USER =&nbsp; GeraldPoste125
<BR>&nbsp;&nbsp;&nbsp; for each computer on the network

<P>For Windows 95 (32 bits)

Gerald.reg
     REGEDIT4

<P>&nbsp;&nbsp;&nbsp; [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
<BR>&nbsp;&nbsp;&nbsp; "TERMINAL"="tGERALD"
<BR>&nbsp;&nbsp;&nbsp; "USER"="uGERALD"

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE1]

"TERMINAL"="tGERALD"     "USER"="uGERALD"

As a result the v$session report the terminal correctly instead of "Windows 95".

Tobias Hitzfeld wrote:
<BLOCKQUOTE TYPE=CITE> Hi Brett!

I just thought about the same problem today. I suppose, that the problem is: process in v$session is the process id of the frontend-process.
 The process-id you received by ps -ef is indeed the process id of the database - backend process!
 Just try:

<P>select a.username,a.sid,a.process "Frontendprocess",b.spid "Backendprocess",a.program
<BR>from v$session a,v$process b
<BR>where a.paddr=b.addr
<BR>order by spid;

So, you'll receive both, the process-ID from frontend (the remote machine) and backend (the machine, where the DB-engine is running at).

Hope this is what you've searched for...

<P>Tobias Hitzfeld
<BR>Oracle-DBA
<BR>Hitzfeld_at_Schoepflin.de

<P>
<HR WIDTH="100%">

ANOTHER question is: <CENTER>HOW TO identify DB-Connections without an existing frontend-task (Win3.1/95 Clients) ???</CENTER>

<CENTER>I've found the SQL*Net Parameter expire_time -> how does it work. Any suggestions ???</CENTER>

Brett C wrote:
<BLOCKQUOTE TYPE=CITE>Greetings all -

We are running PeopleSoft and many entries in V$SESSION shows the the same value in the 'PROCESS' column.  However, a check via 'ps -ef' at
 Unix level shows a bunch of processes with information kinda like the following:

oracleOURSIDNAME (LOCAL=NO)

There are a bunch of these listed, but their associated process shown at
 the Unix level don't appear in V$SESSION.  Is there a way to associate these processes to the one they use in Oracle ?  I have been playing with
 LOGON_TIME and I think I can reasonably arrive at which process is which, but
 that is only a guess.

Any ideas ?

Thanks in advance for any assistance !

Brett
 zgeist.nospam_at_ee.net</BLOCKQUOTE>
  </BLOCKQUOTE>
 </HTML>

--------------30F2D0E8F58820290875E99F-- Received on Fri Sep 12 1997 - 00:00:00 CDT