Kevin,
It sounds strange, V$SESSION->PROCESS always returns the right process ID, even if it is of a forked child's. However, with subsequent calls, if you display your db handle that you acquire in a script, you may get the same ones all the time depending on which Apache children served your request. So if you start several requests and run a select process from v$session where username=<your username> and machine like <your apache machine>; then you should get a list of different process ids. Csaba On Fri, 7 Dec 2001, Kevin White wrote: > Hello there! I've used DBI on many platforms and many databases over > the years: Informix, Sybase, Postgres, and now, for the first time, Oracle. > > My Oracle platform is a brand new 9i box running Red Hat Linux 7.1. But > it isn't the problem. > > The client is also Red Hat Linux, on another machine, talking over > TCP/IP. It is running Apache, and I'm using mod_perl and Apache::DBI. > > After a while, the load on the box shoots way up and the httpd children > seem to slow wayyyy down. I'm trying to figure out why...I'm doing some > research on my own before I ask the world...however... > > I can't figure out how to tell which session each httpd processing > currently running is. Since Apache::DBI caches the handles and passes > them back, the PID's showing up in Oracle don't match the process that > currently has the session: only the one who originally made the session. > > Is there any way to get the Oracle session ID out of a $dbh, so I can > log it and map it back? > > Thanks! > > Kevin >
