RE: Process field on v$session
- From: "QuijadaReina, Julio C" <QuijadJC@xxxxxxxxxxxxxxx>
- To: "Peter Gram" <peter.gram@xxxxxxxxxxxx>
- Date: Wed, 14 Apr 2004 09:10:56 -0400
Peter,
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.
Julio=20
-----Original Message-----
From: Peter Gram [mailto:peter.gram@xxxxxxxxxxxx]=20
Sent: Tuesday, April 13, 2004 6:30 PM
To: QuijadaReina, Julio C; Peter Gram - Miracle A/S
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Process field on v$session
Hi
I must assume you are using some OS from Microsoft, but again I could be
wrong.
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 www.sysinternal.com that produces the best tool for=20
debugging
and thereby understanding the MS os .-)
/peter
QuijadaReina, Julio C wrote:
>All,
>=20
>
>For a good chunk of the day now, I've been trying to get all
information
>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!
>
>Julio
>
>=20
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
> =20
>
--=20
Peter Gram
=20
comp : Miracle A/S
Addr : Kratvej 2, 2760 Maaloev=20
Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
mail : peter.gram@xxxxxxxxxxxx - http://www.miracleas.dk
Upcoming events:
DBF2004 28-30 oktober 2004
Visit http://www.miracleas.dk fore news !
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
