$dbh->{RowCacheSize} = 256;
On 02/20/2004 11:41:09 AM, Rich Holland wrote:
> I didn't know about the "don't-parse-so-much flag" (ora_check_sql) until today.
> What's the "prefetch" one?
>
> I typically also use a template rather than forcing myself to remember connect
> strings, e.g.:
>
> $dbh = DBI->connect("dbi:Oracle:$ENV{TWO_TASK}", $USER, $PASS) ||
> die "$DBI::errstr\n";
> $dbh->{RaiseError} = 1; # die on any error
> $dbh->{AutoCommit} = 0; # don't auto-commit
>
> Rich
> --
> Rich Holland (913) 645-1950 SAP Technical Consultant
> print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
> > Behalf Of Jared.Still_at_radisys.com
> > Sent: Thursday, February 05, 2004 3:35 PM
> > To: oracle-l_at_freelists.org
> > Subject: RE: ora_check_sql in DBD::oracle
> >
> > It's easy to forget stuff.
> > Wish I could remember 10% more of everthing I've learned. :)
> >
> > In the case of perl, this is why I always build new scripts from a
> > template
> > that already has the prefetch and don't-parse-so-much flags set.
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
> > Sent by: oracle-l-bounce_at_freelists.org
> > 02/05/2004 12:01 PM
> > Please respond to oracle-l
> >
> >
> > To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
> > cc:
> > Subject: RE: ora_check_sql in DBD::oracle
> >
> >
> > Figures. I thought I learned something new today. Turns out that I just
> > re-learned something I forgot:
> >
> > http://www.mail-archive.com/dbi-users@perl.org/msg13613.html
> >
> > Thanks for the reminder! :) But now I have to find something else new to
> > learn today...
> >
> > Rich
> >
> > Rich Jesse System/Database Administrator
> > rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
> >
> >
> > -----Original Message-----
> > From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
> > Sent: Thursday, February 05, 2004 12:51 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: ora_check_sql in DBD::oracle
> >
> >
> > In private communication with Cary Millsap, I was warned about the
> > undocumented DBI handle attribute called "ora_check_sql" which was
> > defaults to "1" and, oracle versions 8 and above, causes oracle to
> > parse each statement twice ($sth=$dbh->prepare() is the first parse
> > and 4sth->execute() was the second). On 1/27/2004. Tim Bunce delivered
> > the new DBD::Oracle v1.15 and in the documentation one can find the
> > following text:
> > ***************************************************************************
> > ora_check_sql
> >
> > If 1 (default), force SELECT statements to be described in prepare
> > (). If 0, allow SELECT statements to defer describe until execute().
> > (OCI8 and later only.)
> >
> > See "Prepare postponed till execute" for more information.
> > **************************************************************************
> >
> > When I did the unthinkable and read the documentation (I know, real DBA
> > is not supposed to read the documentation, but learn by osmosis) I
> > remembered the correspondence with Cary and decided to publish it for
> > the rest of the good, hard hacking, perl folks.
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
> >
> >
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 20 2004 - 11:39:55 CST
