Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Process field on v$session

RE: Process field on v$session

From: QuijadaReina, Julio C <>
Date: Wed, 14 Apr 2004 09:10:56 -0400
Message-ID: <>


Our app server is a Windows box running 2k and our Oracle db server is an Alpha VMS. In effect like you said, the number before the ':' is the app server process id. This I already tracked down to the Apache service that runs on the app server. What intrigues me is the number after the colon (from my example below that would be 2168.)

Really what I am after is to find a way to trace back to the web users (our students registering for classes) to be able to point out who is consuming our Alpha box CPU. Interestingly enough, at the time that our Alpha box is dragging, our app server shows no increase in process consumption.=20

And thanks for the site. These guys definitely have some good tools for networking and debugging.


-----Original Message-----
From: Peter Gram []=20 Sent: Tuesday, April 13, 2004 6:30 PM
To: QuijadaReina, Julio C; Peter Gram - Miracle A/S Cc:
Subject: Re: Process field on v$session


I must assume you are using some OS from Microsoft, but again I could be

If you need t interment the content of the process column from v$session

on a MS os
the first part before the ':' is the pid this can be found in=20 taskmanager or one of the
nice tools from that produces the best tool for=20 debugging
and thereby understanding the MS os .-)


QuijadaReina, Julio C wrote:

>For a good chunk of the day now, I've been trying to get all
>I can about this one session that is consuming up to 70 per cent of CPU
>on our db server.=20
>Let me give you a little background: We have an application server that
>runs a web-based system for class registration. This app server runs
>Apache. The task mingler on this app server shows several Apache PIDs
>-each db instance has its own separate web service and in turn, each
>Apache PID can have several child processes.=20
>Now, in my efforts to track down this CPU-hogging session; on our db
>server I see this session as coming from the app server [get this from
>v$session.machine.] I can also get some other goodies by joining on
>v$process to get the db server PID. I've done pretty good up to this
>point, but there is one field on v$session called 'process' of which I
>am uncertain. This field shows two numbers separated by a colon (e.g.
>2800:2168). A little bit of research indicates that the first number
>corresponds to the app server Apache's PID. I have used netstat on my
>app server to see if the second number would be a port number. But,
>netstat does not show any clients connecting to that port number. Has
>anyone figured out what that second number stands for? Is it a client's
>identification number of some sort or is it just a random number
>generated by Oracle upon establishing a connection? I'll appreciate any
>input you may have on this. Thanks in advance!
>Please see the official ORACLE-L FAQ:
>To unsubscribe send email to:
>put 'unsubscribe' in the subject line.
>Archives are at
>FAQ is at
> =20

Peter Gram

comp  : Miracle A/S
Addr  : Kratvej 2, 2760 Maaloev=20
Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
mail  : -

Upcoming events:

DBF2004 28-30 oktober 2004

Visit fore news !

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Wed Apr 14 2004 - 08:12:57 CDT

Original text of this message