Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

2006-11-16 Thread Robert Hicks
Chris Drake wrote: Hi Philip & Robert, Thanks for those excellent references & help offers. Do you (or anyone) know whether or not I should even be *using* a shared server, and have you any idea about how many dedicated connections is "too many" on a dual-3.8ghz Xeon Linux PC with 8gigs or RAM r

Re: DBD Oracle module

2006-11-16 Thread John D Groenveld
In message <[EMAIL PROTECTED]>, "Ke rr Shannon-SKERR1" writes: >Thanks for the reply. The Oracle client libraries are installed at the >same location on all of our servers (Solaris 2.6 and 2.8). I believe >the problem is with the configuration and/or installation procedure and >that's why the lib

Re[2]: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

2006-11-16 Thread Chris Drake
Hi Philip & Robert, Thanks for those excellent references & help offers. Do you (or anyone) know whether or not I should even be *using* a shared server, and have you any idea about how many dedicated connections is "too many" on a dual-3.8ghz Xeon Linux PC with 8gigs or RAM running Oracle 10g? T

How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

2006-11-16 Thread Chris
I'm expanding, and adding extra web servers to handle my load. My Apache/mod_perl environment maintains a new connection for each process, and these processes seem to chew up a lot of server resources. What is the normal acceptable way to maintain large numbers of simultaneous connections? I

Re: Creating XML from an Oracle DB

2006-11-16 Thread Peter J. Holzer
On 2006-11-16 10:49:48 -0500, Garrett, Philip (MAN-Corporate) wrote: > Chris wrote: > > How about trying to create a brand new database using UTF8 *instead* > > of AL32UTF8 ? > > Oracle's "UTF8" char set is old and incomplete. AL32UTF8 is the newer, > more complete version. Oracle's UTF8 is not o

Re: DBD Oracle module

2006-11-16 Thread John D Groenveld
In message <[EMAIL PROTECTED]>, "Ke rr Shannon-SKERR1" writes: >Is this related and if so do you have some advice or guidance I can >share with our computing team that can get this resolved so our >customers don't have to set LD_LIBRARY_PATH to use our tool and we don't >have to develop a wrapper f

RE: Creating XML from an Oracle DB

2006-11-16 Thread Garrett, Philip \(MAN-Corporate\)
Hi, Chris wrote: > How about trying to create a brand new database using UTF8 *instead* > of AL32UTF8 ? Oracle's "UTF8" char set is old and incomplete. AL32UTF8 is the newer, more complete version. See http://tinyurl.com/y4qjd9 (oracle.com). "Oracle recommends that you switch to AL32UTF8 for f

RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

2006-11-16 Thread Garrett, Philip \(MAN-Corporate\)
Chris Drake wrote: > I'm expanding, and adding extra web servers to handle my load. My > Apache/mod_perl environment maintains a new connection for each > process, and these processes seem to chew up a lot of server > resources. > > What is the normal acceptable way to maintain large numbers o

Re: Creating XML from an Oracle DB

2006-11-16 Thread Chris
How about trying to create a brand new database using UTF8 *instead* of AL32UTF8 ? I'm no expert, and I'm not doing the same thing you are, but I solved *my* UTF8 problems thusly:- US7ASCII UTF8 ""Garrett, Philip (MAN-Corporate)"" <[EMAIL PROTECTED]> wrote in message news:[E

DBD Oracle module

2006-11-16 Thread Kerr Shannon-SKERR1
Hello, I'm sorry to bother you, but I saw Dave Moellenhoff's name and email in the DBD::Oracle README.help.txt fie for an issue similar to what our team is seeing when using DBD::Oracle 1.19 that our computing team installed for our development team. I tried contacting him at the provided email a

Re: DBI in a web context

2006-11-16 Thread Chris
Read up on how to connect in the first place - you can pass a switch that tells it to return errors to you, instead of killing your whole script. Look here:- http://search.cpan.org/~pythian/DBD-Oracle-1.19/Oracle.pm#plsql_errstr and search for "RaiseError" "Robert Hicks" <[EMAIL PROTECTED]> wrote

DBD Oracle module

2006-11-16 Thread Kerr Shannon-SKERR1
Hello, I'm sorry to bother you, but I saw Dave Moellenhoff's name and email in the DBD::Oracle README.help.txt fie for an issue similar to what our team is seeing when using DBD::Oracle 1.19 that our computing team installed for our development team. I tried contacting him at the provided email a

How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

2006-11-16 Thread Chris Drake
I'm expanding, and adding extra web servers to handle my load. My Apache/mod_perl environment maintains a new connection for each process, and these processes seem to chew up a lot of server resources. What is the normal acceptable way to maintain large numbers of simultaneous connections? I