On Wed, Sep 06, 2006 at 04:33:27PM -0500, Frank Wiles wrote:
> On Wed, 06 Sep 2006 14:02:56 -0400
> Perrin Harkins <[EMAIL PROTECTED]> wrote:
>
> > You can usually increase your performance greatly just by tuning your
> > existing SQL and database. Run Apache::DProf or the DBI profiler,
> > find
On Wed, May 19, 2004 at 09:40:41AM -0400, Geoffrey Young wrote:
> my $dbh = DBI->connect('dbi:Oracle:HELM', 'user', 'password');
>
>
>
> local $dbh->{AutoCommit} = 0;
> local $dbh->{PrintError} = 0;
>
One good use for local as if you just set the attribute the handle gets corrupted for
i
When using Apache::DBI you must remember that it caches the connections by using the
connection string it you have two types of connection say one with autocommit on and
the other with it off this is cached as two connections.
If you do not have a standard method/module for making your database
Hi,
When you reboot the Oracle Database are you rebooting the machine or just restarting
the oracle process. If it is the later then you might try restarting the Orcle
Listener as well.
I have noticed that sometimes the listener keeps open a connection to the now
restarted database and this ca
Hi,
My I suggest these links :-
Before asking a database related question ...
http://www.perlmonks.com/index.pl?node_id=264485
Speeding up the DBI
http://www.perlmonks.com/index.pl?node_id=273952
Apache::DBI
http://cpan.org/authors/id/A/AB/ABH/Apache-DBI-0.92.readme
Hope it helps
Paddy
On