Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
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_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://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@MiracleAS.dk - 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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Apr 13 2004 - 17:46:00 CDT
![]() |
![]() |