/DBD/Oracle/Oracle.so
resolves that missing symbol.
Happy Perl hacking,
John
[EMAIL PROTECTED]
with the specific DBD::Oracle.
$ /bin/env - ORACLE_HOME=/path/to/oracle/product/9.2.0 \
/path/to/bin/perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION'
$ /bin/env - ORACLE_HOME=/path/to/oracle/product/9.2.0 \
/path/to/bin/perl your_simple_test_script
John
[EMAIL PROTECTED]
Well, do you know what cause that delay? Between an Oracle client and
Database Server?
- Original Message -
From: Steffen Goeldner [EMAIL PROTECTED]
To: Paul Appleby [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 18, 2004 11:34 AM
Subject: Re: Slow connection to Oracle 9i
##
### The error when I run the make test TEST_VERBOSE=1
##
can't get DBI::st=HASH(0x33768)-{NUM_OFFIELDS_typo}: unrecognised attribute
at t/general.t line 41.
Failed 1/9 test scripts, 88.89% okay.
://www.nntp.perl.org/group/perl.dbi.users/23322).
best regards,
John Escott.
Well, how could i define the $ORACLE_HOME in the connection string?
- Original Message -
From: Scott Dial [EMAIL PROTECTED]
To: John [EMAIL PROTECTED]
Sent: Thursday, August 05, 2004 3:03 PM
Subject: Re: DBD::Oracle seems not working through Apache
ie:
$ENV{ORACLE_HOME}='/u01
-
From: Tim Bunce [EMAIL PROTECTED]
To: John [EMAIL PROTECTED]
Cc: DBI-Users [EMAIL PROTECTED]
Sent: Thursday, July 08, 2004 8:45 PM
Subject: Re: Automating database full backup
On Thu, Jul 08, 2004 at 01:17:04PM +0300, John wrote:
Ok, can mysqlhotcopy create a dump? That is what i want. like
.
Hardy Merrill
John [EMAIL PROTECTED] 07/07/04 09:52AM
I want to automate a mysql backup
Can this be done via perl and how?
Ok, can mysqlhotcopy create a dump? That is what i want. like mysqldump (in
my case the mysql server is absoloutely inactive during the whole night,
therefore i don't case about speed or locking the tables :) )
- Original Message -
From: Tim Bunce [EMAIL PROTECTED]
To: John [EMAIL
I want to automate a mysql backup
Can this be done via perl and how?
, but there seems to be
another problem elsewhere.
best regards, John.
--
Versions I was using:
Linux clients (various machines)
Perl: 5.8.0 (as in RH 8)
DBI: 1.35 and 1.43
Net::Daemon: 0.30 and 0.38
PlRPC: 0.2012 and 0.2017
Storable
It's something I've been meaning to test, but I haven't been able to do so
yet, (single-threaded mode meets our needs at present).
So, sorry I can't give the answer I guess you want, but I'd be interested
is anyone else can (especially for ProxyServer running on windows)
John Escott.
for the information and the help...
jwm
-Original Message-
From: Gene Dascher [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 12:48 PM
To: Moon, John
Subject: RE: [CGI] DBI DBD::Oracle
Try looking at this page to see if it can give you any direction:
http://www.fors.com/velpuri2/ERRORS/TWO
client libraries from ORACLE_HOME
or have you changed your ORACLE_HOME?
If yes, you'll need to rebuild DBD::Oracle or correct your ORACLE_HOME.
If no, my guess is that your Oracle 9 SQLNet configuration doesn't
include your new 10g instance.
John
[EMAIL PROTECTED]
Because the script and the database server is on the sampe server.
Now, i start the listener without premitting anyone else to connect to my
system.
- Original Message -
From: Gold, Samuel (Contractor) [EMAIL PROTECTED]
To: John [EMAIL PROTECTED]
Sent: Friday, March 19, 2004 2:49 PM
How to get connected to an oracle server with not listener?
Which one is the correct?
$dbh = DBI-connect('dbi:Oracle:T:Machine:SID','username','password')
$dbh = DBI-connect('dbi:Oracle:','[EMAIL PROTECTED]:Machine:SID','password')
$dbh =
I have a perl script that execute a query from an Oracle 9iR2 (on a SuSE linux)
The script runs in the Linux and then it demolishes the greek language.
The output is not readible.
Do you know what is wrong?
Is the good value? AMERICAN_GREECE.EL8MSWIN1253
?
- Original Message -
From: Gold, Samuel (Contractor) [EMAIL PROTECTED]
To: 'John' [EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 6:32 PM
Subject: RE: perl, oracle languages
It sounds like this has been covered before. Try searching
in DBD::SQLite but nothing jumped out at me, maybe Tim B knows
better since I guess he wrote the code for this.
--
John Cavanaugh
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
);
print Prepare on SQL code returned: $DBI::errstr\n;
my $rc = $sth-execute;
print Execute to DB returned $rc\n;
while (($T1) = $sth-fetchrow_array() ) {
print SQL Query returned $T1\n;
}
$dbh-disconnect;
Thanks!
John W. Herbold Jr.
Peter showed me the error of my ways
my $dbh = DBI-connect('dbi:ODBC:MSSQL', 'ID','password'); if
($DBI::errstr) {print $DBI::errstr;}
And for future reference the error was:
Data source name not found and no default driver specified (SQL-IM002)
Thanks,
John W. Herbold Jr
Does SuSEE 9 pro contains all related database modules and especially DBD::Oracle?
If not then,is there the dbd::oacle for the Perl 5.8.1 on a linux box?
options you'll need to check
the Oracle documentation.
Paul
-Original Message-
From: John [mailto:[EMAIL PROTECTED]
Sent: Friday, December 26, 2003 3:38 PM
To: dbi-users
Subject: Re: Automatng import
Quoting Kevin Moore [EMAIL PROTECTED]:
Try drop user jim cascade
Hi all
I am planning to make a cronjob so i would like to know if tht can be achived through
a perl script.
To be more specific, i have an Oracle RDBMS and i want to execute some commands in the
shell
.
system(sqlplus system/password);
system(drop jim cascade);
can be the above
tables=(table1, table2, table3, ...));
Will the above command work and keep the table(1-Z) every time up to date?
Or should i drop the user first? (that's the difficult part concerning Perl
and internal commands of sqlplus)
- Original Message -
From: Kevin Moore [EMAIL PROTECTED]
To: John
or download MDAC and go back to Microsoft and get the patch.
John
-{NAME}}\n\n\n;
while (($Full_Name,$Street_Address) = $sth-fetchrow_array) {
print $Full_Name$Street_Address\n\n;
}
System:
Windows 2000
pentium II
PERL Active Perl version 1.37 5.8.0.806
MySQL version 2000 version 5.00.2195
Thanks in advance
John in Denver, Colorado USA
dbdimp.h:169: parse error before '}' token
I am lost. Can anyone help?
Kindest regards,
John
All other DB's that I know of are case sensitive.
Thanks,
John W. Herbold Jr.
Security Specialist
501-399-3939
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 11:34 PM
To: Scott R. Godin
Cc: [EMAIL PROTECTED]
Subject: Re: MYSQL where
hi
no- fork YOU and die ...
( 03.10.07 12:31 +0100 ) tvilliers:
I have a mother process which needs to fork off a child at every x
milestone.
Now, the mother has an open database handle, which from my understanding
gets transferred to the child at fork. I want the handle to stay with the
Unfortunately, my application will be a Desktop one and not a cgi.
- Original Message -
From: Ron Savage [EMAIL PROTECTED]
To: [EMAIL PROTECTED] :DBI users [EMAIL PROTECTED]
Sent: Sunday, October 05, 2003 3:03 AM
Subject: Re: Mysql database migration.
On Sat, 4 Oct 2003 10:17:43 +1000,
TO be honest, the actual database is the Access, and i was thinking of
writing a program to pass the data into the mysql and migrate the specifig
mysql database to others.
Thus, my question can be change now to Can perl convert Access to Mysql
directly? :)
- Original Message -
From:
[EMAIL PROTECTED] wrote:
Can I do something like this?
from
$sth = getVUser($dbh, $u, $d);
return $sth-rows();
to
return (getVUser($dbh,$u,$d))-rows();
What happened when you tried it?
John
--
use Perl;
program
fulfillment
)
If you will run the perl script on the database server, use the Oracle
driver instead of ODBC. ODBC performance to Oracle is awful.
Regards,
John
I uninstalled the Oracle 9i and partitioned my harddisk. Then i installed the Oracle
Server on the second half partition (E:).
OracleHomeE=E:\oracle\ora92;
However, i cannot connect to the database as i used to. What should i configure now?
Thanks in advance!
I have already fixed my problem by setting the correct ORACLE_HOME path!
- Original Message -
From: John [EMAIL PROTECTED]
To: DBI-Users [EMAIL PROTECTED]
Sent: Sunday, September 21, 2003 6:54 PM
Subject: Reinstallation problems (Oracle 9.2.0.1)
I uninstalled the Oracle 9i
At 02:12 PM 9/16/2003 -0700, Michael A Chase wrote:
Please keep this discussion on the [EMAIL PROTECTED] list. Other
people may be able to contribute to the exchange or learn from it.
On Tue, 16 Sep 2003 07:40:06 -0700 Mary Sweeney
[EMAIL PROTECTED] wrote:
Thanks for your reply. How do I find
other
dependancy.
John
, and you might get some usable error messages.
John
the finish() out of the loop, then enable some error checking, like RaiseError = 1 in
the connect and see if the execute() is working at all! If the execute fails then at
least you will know and you can fix that before you worry about fetching data.
John
Things are getting better and better :)
Here is my new code
#!/usr/local/bin/perl -w
use DBI;
use Tk;
use strict;
my $max_len = 200;
my $mw=new MainWindow;
my $dbh = DBI-connect( )
or die
Try:
my $dbh = DBI-connect('dbi:mysql:database=helpdesk:host=123.123.123.123',
'user', 'pw');
Thanks,
John W. Herbold Jr.
Security Specialist
501-399-3939
-Original Message-
From: Herbert Braun [mailto:[EMAIL PROTECTED]
Sent: Monday, August 25, 2003 4:53 AM
To: [EMAIL PROTECTED
from
John Brigham
2020 Vine Street
Denver, Colorado 80205
I am working toward an education related, database web site. I envision
this growing very large and being nonprofit.
system
pentuim ii
windows 2000 version 5.00.2195
x86 family 5 model 2
256m ram
2+2gig hard drive
I have installed
Here is my code...
--
use DBI;
$dbh = DBI-connect('DBI:ODBC:LNX1', 'nsite', 'nsite') or die Can't connect
to Oracle database: $DBI::errstr;
#$selstmt = 'SELECT ACCIDENT_EVENT_ID from ACCIDENT_EVENT'; #selstmt1
$selstmt = 'SELECT * from ACCIDENT_EVENT';
On Mon, 4 Aug 2003 21:31:27 +1000
Steve Baldwin [EMAIL PROTECTED] wrote:
= Look through the perldoc for LongReadLen. AFAIK, the only limitation
is = on memory issued by the OS. A word of warning - if you set
LongReadLen = to something large, you should probably set RowCacheSize
to 1.
my problem of last week was associated with variable scoping ... got a
little too quick and the scalars i was trying to insert were not visible
to the subroutine in which the insert command is executed. the command
was therefore being executed with scalars that were not yet defined.
john
to thinking that I
may be running afoul of internal enviroment limitations.
Any perspectives would be appreciated.
john cuson
([EMAIL PROTECTED], [EMAIL PROTECTED])
The world is full of obvious things which nobody by any chance ever
observes
hi
( 03.07.24 14:55 +0100 ) [EMAIL PROTECTED]:
I am running the script from a different server to where the database is
held, and due to security issues I am unable to hardcode the username and
password. I have searched and am unable to find anything to cover this.
if you want 2 automated
=
$clientID;
my $sth = $dbh-prepare($sql);
$sth-execute;
return $sth-fetchall_arrayref;
}
Thanks in advance for any help,
John
to Google
http://groups.google.com/groups?hl=enlr=ie=UTF-8group=perl.dbi.users.
I'm glad you asked--the question motivated me to find a working archive.
Now I can answer one of Tim's earlier questions
Cheers,
John
Is there a searchable archive of this list? I could not find working
links
15, 2003 at 12:56:21PM -0600, Sterin, Ilya wrote:
I'll let Tim respond with contest details, but for what it's worth...
Tim if we would have the contest now, it'd be in time for the
launching of the new DBI site.
Ilya
-Original Message-
From: John Costello
To: [EMAIL PROTECTED
This is part question, part very-late-reminder-to-Ilya. Is there an image
for 'built with DBI' or some such? I recall that someone (Tim?) wanted to
have a contest for the image.
John
cos at indeterminate dot net
Hi Dinesh,
DBI has a built-in function, dbitrace, that allows you to throw fatal
errors and other information to a data file
Check 'perldoc dbi' and look for dbitrace.
Regards,
John
On Jul 1, Rao, Dinesh - eSpeed scribed:
Hi!
I have a DBI program which connects to Sybase database
Hi Tim
Thanks for getting back to me!
On Fri, 13 Jun 2003, Tim Bunce wrote:
Upgrade the server DBI version.
Tim.
On Thu, Jun 12, 2003 at 12:02:29PM +1000, John Cougar wrote:
Heya folks
I've recently upgraded the DBI and DBD packages on a development server,
and I'm now getting
.
___
+-- -++
| John V Cougar __| Voice: +61 2 6208 1683 |
| Cache Manager/ / /\ ++
| Telstra Internet \/_/ \ Direct | E-Mail: [EMAIL PROTECTED] |
+/ ---++
For MySQL you can also use the SQL command DESCRIBE TABLE_NAME and loop
through the answer set just as you would any other DB call.
For DB2 the tables would SYSIBM.SYSCOLUMNS and SYSIBM.SYSTABLES
Thanks,
John Herbold
IS Specialist/DBA
-Original Message-
From: Vinnie Lima
To: Anthony
Do this:
To remove your address from the list, just send a message to
the address in the ``List-Unsubscribe'' header of any list
message. If you haven't changed addresses since subscribing,
you can also send a message to:
[EMAIL PROTECTED]
Ummm two thing about your request...
1) It might help if you give us the error.
2) It might help if you say please.
Thanks,
John W. Herbold Jr.
IS Specialist/DBA
-Original Message-
From: OMKAR (Pramod Shanbhag) [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 7:37 AM
To: [EMAIL
hi
( 03.05.29 18:09 +0530 ) OMKAR (Pramod Shanbhag):
LoveMatch has exited with the following error:
Can't connect to mySQL database. Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Kindly provide us the solution on urgent basis.
too much hate.
--
\js
hi
( 03.05.29 13:08 -0700 ) Brian McLaughlin:
The problem is that the encrypted passwords have non-ascii characters.
How can I copy the contents of one char column to another if the data
contains illegal characters ??
schema change.
--
\js
Do you have a DB2 ODBC client installed like DB2 Connect?
Thanks,
John W. Herbold Jr.
IS Specialist/DBA
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 3:47 PM
To: [EMAIL PROTECTED]
Subject: Re: DBD::DB2
And also is it possible to connect to DB2
, but
with not success.
Suggestions would be appreciated.
--John Costello
the problem, I set
$ENV{ORACLE_HOME} = D:\ORA817;
instead of
$ENV{ORACLE_HOME} = D:\\ORA817;
Once I escaped the \, the script ran fine.
John, glad it is almost the weekend.
--
Ummm...yes. Unless you want a grumpy, borderline psychotic monkeygirl
roaming loose throughout
Number of rows: $num_rows\n;
$sth-finish();
exit(0);
-
John Costello cos AT indeterminate DOT net
Bomb! I order you not to explode!--Dark Star
Foo. I hate being a newbie. Again.
Thank you, Ronald. I'll go back to the perldoc before asking more
questions.
--John
On Fri, 21 Mar 2003, Ronald J Kimball wrote:
On Fri, Mar 21, 2003 at 02:20:51PM -0800, John Costello wrote:
[snip snip]
You have not fetched all the rows from
/lib/site_perl .) at
/usr/opt/perl5/lib/site_perl/5.6.0/aix/DBI/W32ODBC.pm line 50.
BEGIN failed--compilation aborted at
/usr/opt/perl5/lib/site_perl/5.6.0/aix/DBI/W32ODBC.pm line 50.
Compilation failed in require at db_test.pl line 3.
BEGIN failed--compilation aborted at db_test.pl line 3.
John R
Thanks
Mike!
John R. James, Jr.
Unix Engineer FSG V IADTU Acxiom, Corporation (501)-342-0455 Unix Oncall Phone: (501)450-8684
-Original Message-From: Mike Nielsen
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 13, 2003 4:14
PMTo: James John - jrjameCc:
'[EMAIL PROTECTED
You're using strict and need to declare the variables listed.
Also, I would suggest changing your password as soon as possible!
mel awaisi [EMAIL PROTECTED] 3/11/2003 3:28:17 PM
hi,
I am trying to use stat in a perl script with MySQL.i am getting the
following error. do I need to add some
As a postscript, I did a string search on all the elements in my Perl
distribution. oracle.dll was the only element to have a reference to
perl56.dll.
to connect, I receive a message saying that perl56.dll cannot be found
in \perl\bin.. Is there a
variable somewhere that I can change, so that it will try to pick up
perl58.dll (which IS in \perl\bin)?
Thanks,
John Black
When I run ora_explain and hit the login button, I get:
Is there a quick fix
will be greratly
appreciated.
The DBD:: drivers for Microsoft Access are either DBD::ODBC or DBD::ADO.
Go to DBI FAQ (www.xmlproj.com/cgi/fom.cgi) to find PPM sources for the
most current releases.
--
Regards
John McMahon (mailto:[EMAIL PROTECTED])
to re
opt-in every three months!) seems that SPAMANOIA has taken over and much legitimate,
even requested, email is being filtered out.
John
At 07:11 AM 12/20/2002 -0800, Michael A Chase wrote:
On Fri, 20 Dec 2002 06:18:39 -0800 Jonathan Leffler [EMAIL PROTECTED] wrote:
I sent an email
and write it back. I would like to improve efficiency by not having to
prepare the statement each time (as the version I am rewriting does).
Will this work?
I am using latest DBI, DBD, mySQL on Linux with Perl 5.6
John Day
Words Images
You've got two options for interacting with ACT! via Perl.
You can use the Win32::OLE modules to interface with ACT! methods
and you can access the database files via DBD::ODBC or DBD::XBase.
Have fun reading the SDK and the rest of ACT!'s technical support
docs.
John
[EMAIL PROTECTED]
.
Thanks,
John Herbold
IS Specialist/DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 5:39 AM
To: [EMAIL PROTECTED]
Subject: Error handling with DBI
Hi,
I want to write a program that acesses two databases, fetching data from
one
think we'd need more context for the earlier errors.
Thanks,
John A
see me fulminate at http://www.jzip.org/
]};
$type = @{$col[$thing][1]};
$size = @{$col-[$thing][2]};
if ($size) {
$size_n = $size;
$size_n =~ s/^(\d)\.+(\d)/$1$2/g;
$partno = $mfg_n . $type_n . $size_n;
}
No, since you don't ever set $type_n or $mfg_n before you use them.
Thanks,
John A
see
: OCIDescribeAny(view)/LOB refetch) at LoadFile.pl
line 180.
Does anyone know what could be causing it not to see the table?
--
John Whitnack
Gilbert Laustsen Jung
[EMAIL PROTECTED]
(403)-266-9517
From a thread last month
(http:[EMAIL PROTECTED]/msg14522.html) it was
indicated that DBD-Oracle 1.13 would support array inserts. Can anyone
(Tim?) confirm this? If so is there a projected release date and how firm
is that date?
Thanks in advance.
John
Good enough.
I'll keep an eye on the freetds guys and do without in the mean time.
Thanks.
Michael Peppler wrote:
On Wed, 2002-11-27 at 12:26, John Ulmer wrote:
Hello all,
I am trying to use place holders to stream line some database interaction..
RH 8 - kernel 2.4.18-18.7
Freetds
use_place_holder
{
my $sth = $dbh-prepare(q{INSERT INTO issues_vvl (issue) VALUES (?)})
|| die $dbh-errstr;
foreach my $var(@data)
{
$sth-execute($var) || die $dbh-errstr;
}
}
==END CODE CHUNK==
Thanks,
--
John R. Ulmer
Senior Computer Analyst
TPMC Contractor
NOAA Coastal
James,
I tried using DBMS_LOB package and the problem -End of Communications
Channel- got resolved. More over, now I can insert data up to 32KB,
previously, it was limited to 4K.
I believe, you are getting the error only when you try inserting data
greater than 4000 characters.
Here is an
Folks,
I am running into a problem here:
My script is running on:
Solaris SunOS 5.8 Generic_108528-15 sun4u sparc SUNW,Ultra-Enterprise
Perl 5.6.1
DBI 1.18
DBD::Oracle 1.07
It gives the following error while preparing a select query:
DBD::Oracle::db prepare failed: ORA-01062: unable to
-trace(6),\n\nCould not prepare statement:
\n,$dbh_prod-errstr();
Like I said, my perl experience is small, so I'm not sure if maybe
the whole eval testing thing is taking up too much memory or what.
Hope it helps,
- --
sh
- -Original Message-
From: Jibo John [mailto:jijohn;cisco.com
Is there a way to easily lock a table ? so that no updates can happen
untill my script is done?
I am using DBD::Oracle?
Proverbs 3:5 Trust in the Lord with all your heart and lean not on
your own understanding;
enough.
Thanks,
John W. Herbold Jr.
IS Specialist/DBA
-Original Message-
From: Brad Smith [mailto:mata;matatech.tzo.com]
Sent: Tuesday, November 05, 2002 7:56 AM
To: [EMAIL PROTECTED]
Subject: SQL question
I want to run a query that will perform a phrase search on all fields
DBD::CSV. I am just trying to go through the O'Reilly Perl DBI book,
so don't need anything too complex
As an alternative to DBD::CSV have you considered DBD::SQLite for your
situation. SQLite is public domain, DBD::SQLite includes the entire
thing in the distribution.
--
Regards
John
config to include this variable, I want to make sure
that I really *should* be doing that...
Thanks !
John
--
#
# John Foley - LAN Manager #Maildrop: IL02 - RM 0206 #
# Schaumburg BTS
people.) Is there a way to hide the passwords in a file so that perl
can still connect to the db but now allow anyone but me and maybe my
supervisor to see the password?
Thanks.
John Gedeon
Proverbs 3:5 Trust in the Lord with all your heart and lean not on
your own understanding;
Hi
( 02.10.22 11:02 -0700 ) John Gedeon:
Is there a way to hide the passwords in a file so that perl can still
connect to the db but now allow anyone but me and maybe my supervisor
to see the password?
Not really cleanly.
If you're on a UN*X system, you can use file permissions to minimize
Thanks for the tips guys. I will post my solution if any when I get one.
but it seems like someone will always be able to see the passwords...
John
Proverbs 3:5 Trust in the Lord with all your heart and lean not on
your own understanding;
Select col1
from Jenny
where col1 is not null
Should get you all of column 1 where there is not a null.
Thanks,
John W. Herbold Jr.
IS Specialist/DBA
-Original Message-
From: Christopher G Tantalo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 12:46 PM
To: [EMAIL
Try the excellent reference MySQL and Perl for the WEB by Paul Du Bois. (Paul is a
member of this list). He talks at length about session management and tracking - well
worth having on the shelf.
John
At 10:02 AM 10/8/2002 -0400, Hardy Merrill wrote:
I haven't done this yet myself, but I've
You should be able access the user name entered through apache
authentication by accessing the CGI variable REMOTE_USER or
AUTH_USER. (REMOTE_USER is an environment variable as well so you could use
$username = $ENV{'REMOTE_USER'};
HTH
John
At 08:58 AM 10/8/2002, you wrote:
I know this is OT
?
What OS is running on each machine?
-Joe
--- [EMAIL PROTECTED] wrote:
If you are doing selects, you can set the $dbh-RowCacheSize,
perldoc DBI will tell you what you need to know.
On 02-Oct-2002 John-Thomas Beadles wrote:
Help! I'm having a severe performance problem
Forgot to copy my response to the list...
-Original Message-
From: Beadles, John-Thomas [RICH1:2795:EXCH]
The PC is running Win2k, perl 5.6.1, dbi 1.28, dbd-oracle 1.80
The UNIX machine is running HPUX10, with Perl v5.6.0, dbi 1.14, dbd-oracle -
can't tell, don't have access
, October 03, 2002 10:09 AM
To: Beadles, John-Thomas [RICH1:2795:EXCH]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
Then I don't believe this is a dbi issue; most likely a difference in
configuration at the Oracle client or OS level.
Where does
Rich,
Boy, been a while since I've done this - Top shows nowhere near 100%. User
CPU hit about 0.2%, sqlplus was 30% while the query was actually running.
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 10:30 AM
To: Beadles, John-Thomas
Hm, I'll try that. However, the listener appears to be down now, so I can't
try it just yet.
Not sure about the DBD Oracle version, not sure how to find the physical
module. Is there another way to tell?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Ah
701 - 800 of 919 matches
Mail list logo
