Acting on the assumption that you are using DBI with DBD::Oracle, you may want to look at the DBI->trace function. You can find fairly complete info at this link. This can provide you with a wealth of information. See "Programming the Perl DBI" by O'Reilly for more information.

Cheers,
Ovid

Join the Perlmonks Setiathome Group or just click on the the link and check out our stats.