Home: Perl Programming Help: DBI:
Perl DBI - How to get PID of Database Session



RK_Perl_Pearl
New User

Oct 17, 2016, 9:31 PM


Views: 5036
Perl DBI - How to get PID of Database Session

Hello,

Is there any function in DBI to return the Database Process Id (PID) for a query executed through Perl Program?

Detail: Suppose I have a Perl program that connects to Oracle/Sybase/MySQL and executes a query. As soon as query is submitted to database, I want to have the Database Process ID (Not Unix Process ID for Perl program).

If not, then please advise on any other best approach to get database PID. I don't want to use fork/thread or Perl modules like Proc::Parallel due to some reasons.

Thanks in advance!

RK