Perl code executed by mod_perl is executed in a Perl interpreter in the Apache process. The interpreter is created when apache starts up and it persists on until the apache child exits.

While the db connection is still limited to a process -- each apache process has its own pool -- that process can handle more than one HTTP request.