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
