RE: Process field on v$session
- From: "QuijadaReina, Julio C" <QuijadJC@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Apr 2004 16:24:06 -0400
Dennis,
Thanks for pointing me to a different direction - I was starting to get
frustrated with this. I hope you pardon my ignorance since I am new to
the Oracle views. But, is this what v$session.command will show me? And
since you mentioned SQL, I've seen a view called v$sqlarea. Is that a
good starting point?
Julio=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS
Sent: Tuesday, April 13, 2004 2:23 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Process field on v$session
Julio
Consider working from the other direction. Try to find the SQL that
is
being executed.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of QuijadaReina, Julio C
Sent: Tuesday, April 13, 2004 12:24 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Process field on v$session
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
=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
=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!
=20
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
