my $dbh;
$dbh = dbi->connect_cached(args);
#args has connection string and the options
For Oracle db
#control is not coming here since script seems to be hanging at this point