RE: ora_check_sql in DBD::oracle
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Feb 2004 09:24:55 -0800
Sorry Rich, I mis-spoke, er, wrote.
A better term would be 'array size', similar to sqlplus.
It is set like this:
$dbh->{RowCacheSize} = 100;
Jared
"Rich Holland" <holland@xxxxxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
02/20/2004 08:41 AM
Please respond to oracle-l
To: <oracle-l@xxxxxxxxxxxxx>
cc:
Subject: RE: ora_check_sql in DBD::oracle
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Jared.Still@xxxxxxxxxxx
> Sent: Thursday, February 05, 2004 3:35 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxx>
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> 02/05/2004 12:01 PM
> Please respond to oracle-l
>
>
> To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxx/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@xxxxxxxxxxxx Quad/Tech International, Sussex, WI
USA
>
>
> -----Original Message-----
> From: Mladen Gogala [mailto:mladen@xxxxxxxxxxxxxxx]
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
