Re: Process field on v$session
- From: Peter Gram <peter.gram@xxxxxxxxxxxx>
- To: QuijadJC@xxxxxxxxxxxxxxx,Peter Gram - Miracle A/S <peter.gram@xxxxxxxxxxxx>
- Date: Wed, 14 Apr 2004 00:30:00 +0200
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
taskmanager or one of the
nice tools from www.sysinternal.com that produces the best tool for
debugging
and thereby understanding the MS os .-)
/peter
QuijadaReina, Julio C wrote:
>All,
>
>
>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.
>
>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.
>
>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
>
>
>
>
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------
>
>
>
--
Peter Gram
comp : Miracle A/S
Addr : Kratvej 2, 2760 Maaloev
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:
