Oracle DBF Tablespaces and Perl

2006-05-01 Thread Mark Galbreath
Our Oracle team exports 8 DBF files to a local directory.  Is it possible to use perl to query these tablespace files directly?  Using perl, how would I get them into a MySQL database?  Do I need anything besides DBI.pm?   thx, mark

Re: Oracle DBF Tablespaces and Perl

2006-05-01 Thread Sean Davis
On 5/1/06 11:00 AM, "Mark Galbreath" <[EMAIL PROTECTED]> wrote: > Our Oracle team exports 8 DBF files to a local directory. Is it possible to > use perl to query these tablespace files directly? Using perl, how would I > get them into a MySQL database? Do I need anything besides DBI.pm? I t

Re: Oracle DBF Tablespaces and Perl

2006-05-01 Thread Mark Galbreath
Unfortunately, direct access to the Oracle database is not possible as it is off-site.  All I have to work with are the 8 DBF files and DBI.pm.   ~m>>> Sean Davis [EMAIL PROTECTED]> 01-May-06 11:25:13 AM >>On 5/1/06 11:00 AM, "Mark Galbreath" <[EMAIL PROTECTED]> wrote:> Our Oracle team exports 8

Re: Oracle DBF Tablespaces and Perl

2006-05-01 Thread Sean Davis
On 5/1/06 11:37 AM, "Mark Galbreath" <[EMAIL PROTECTED]> wrote: > Unfortunately, direct access to the Oracle database is not possible as it is > off-site. All I have to work with are the 8 DBF files and DBI.pm. So a search of cpan turns up: http://search.cpan.org/~clotho/CAM-DBF-1.01/lib/CAM

Re: Oracle DBF Tablespaces and Perl

2006-05-01 Thread Perrin Harkins
On Mon, 2006-05-01 at 11:00 -0400, Mark Galbreath wrote: > Our Oracle team exports 8 DBF files to a local directory. Is it > possible to use perl to query these tablespace files directly? Using > perl, how would I get them into a MySQL database? Do I need anything > besides DBI.pm? Mark, This

GTop vs. pmap on Linux

2006-05-01 Thread Bill Moseley
Apache/2.0.55 (Debian) mod_perl/2.0.2 Perl/v5.8.8 I'm testing out a Catalyst application running under mod_perl (was using fastcgi before). I'm trying to get a grasp on the memory used by the processes. Anyone familiar with pmap on linux? There's this description of using pmap to determine sha

Zombie Processes/Mod_Perl 2.0.2

2006-05-01 Thread Stanley Laufer
We are running Mod_Perl 2.0.2 under Apache 2.0.58 on Solaris 9. After executing a certain perl script, we are finding that a defunct subprocess is hanging around. This happens every time the script is executed by Mod_Perl, and so the defunct processes are building up rapidly. The defunct process

Re: GTop vs. pmap on Linux

2006-05-01 Thread Perrin Harkins
On Mon, 2006-05-01 at 10:56 -0700, Bill Moseley wrote: > Anyone familiar with pmap on linux? No. The current best bet is Linux::Smaps, which Apache2::SizeLimit now uses. > I tend (and hope!) to believe GTop. Don't believe it. It's probably getting the same numbers you'd get from /proc/self/sta

what is correct way to use mod_perl2, Apache2, and DBI?

2006-05-01 Thread Matthew
Hey guys, mod_perl newbie here. Our web app was written a year ago as a regular CGI. Now that it gets accessed close to 1000 times a day (business grows) I saw the need to rewrite it using mod_perl2 as a "handler". I'm trying to use mod_perl-2.0.2 and apache 2.0.55. There isn't much documen

Re: what is correct way to use mod_perl2, Apache2, and DBI?

2006-05-01 Thread Jonathan Vanasco
On May 1, 2006, at 5:47 PM, Matthew wrote: use Apache::DBI; // this aint working right what's not working with it? generally I do this + Startup.pl Use Apache::DBI + DB.pl my %_db_config = ( dbType => 'postgresql', dbi => 'dbi:Pg:dbname=x', dbUser =>

Re: what is correct way to use mod_perl2, Apache2, and DBI?

2006-05-01 Thread Perrin Harkins
On Mon, 2006-05-01 at 18:14 -0400, Jonathan Vanasco wrote: > once apache::DBI is loaded, it > caches all connections - so you'll probably get worse performance > with every request sharing 1 connection, than with every request > making/breaking a new request. you want to make sure that you l

Re: what is correct way to use mod_perl2, Apache2, and DBI?

2006-05-01 Thread Perrin Harkins
On Mon, 2006-05-01 at 16:47 -0500, Matthew wrote: > Also, if there is any documentation on how to > correctly use Apache::DBI with mod_perl2 and apache2, that would be > great cause even though I'm "use Apache::DBI", my connections aren't > being cached. As it says in the docs for Apache::DBI,

Spam Filtering is Active

2006-05-01 Thread Technical Support
Dear Valued Customer, This email is to inform you that spam filtering has been activated on this account and provide you with some basic instructions to assist in filtering spam from your email. The filtering software we are using is called DSPAM and is capable of dynamically learning your spec

Problem with installing mod_perl - my_perl undeclared

2006-05-01 Thread Kepi
Hi all, I'm using mod_perl for about two years and have no significant problem. But yesterday I tried to install mod_perl 2.0.2 on my machine and got this: cc -I/usr/local/src/lamps/mod_perl-2.0.2/src/modules/perl -I/usr/local/src/lamps/mod_perl-2.0.2/xs -I/home/www/phpperl/include/apache -I/home

Problems building mod_perl 2.0.2 w/httpd-2.2.2

2006-05-01 Thread Tyler MacDonald
I just upgraded to httpd 2.2.2 and tried to install mod_perl. This upgrade was made on top of my existing 2.2.0 installation. Here's what happens when I run "make" in mod_perl's source directory: $ make cd "src/modules/perl" && make make[1]: Entering directory /home/faraway/src/mod_perl-2.0.2/src/

Re: what is correct way to use mod_perl2, Apache2, and DBI?

2006-05-01 Thread Jonathan Vanasco
On May 1, 2006, at 6:19 PM, Perrin Harkins wrote: No, Apache::DBI will not cache connections made during startup. Trying to share a connection made during startup would lead to worse things than bad performance: segfaults and strange, apparently random DBI errors. Is that a new feature? I

Re: what is correct way to use mod_perl2, Apache2, and DBI?

2006-05-01 Thread Perrin Harkins
On Mon, 2006-05-01 at 18:52 -0400, Jonathan Vanasco wrote: > Is that a new feature? No, it has always checked to see if the server is starting and avoided caching connections if it is. There's a warning that it prints to the logs about skipping the cache during startup if you try to open a connec