Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

New platform, Solaris 10, 64 bit. Oracle is 64 bit. Do I need to install a 64 bit perl so I can use DBD::Oracle? How do I know if I need -Dusethreads? If I install gcc 4.9 optimized for the T4 CPU will the Perl I compile be faster than using the stock compiler? Any extra tips about GCC welcome. Thanks.

Replies are listed 'Best First'.
Re: Do I need to build a 64bit Perl
by jellisii2 (Hermit) on May 20, 2014 at 15:04 UTC
    Since DBI uses sockets to connect, I don't think 32/64 bit will matter from the perl end, as long as it matches your chosen perl. I think I'm not out of line in suggesting http://perlbrew.pl as an option for your perl as to not cause problems with your system perl.
[reply]
Re: Do I need to build a 64bit Perl
by Tux (Canon) on May 21, 2014 at 16:30 UTC

    Those are two simple questions. The second is easy to answer: DBD::Oracle does NOT need -Dusethreads. But when you build perl to be used for Oracle, be sure to link in -lpthread. You might also need -lcl.

    The first question really depends on what client library you are linking DBD::Oracle to. A 32bit client library will talk to a 64bit server (even on the same machine), but if the database is running as 64bit on the same machine, it is much easier to link to 64bit client libraries. The bitness of the perl binary has to match the bitness of the client library.

    If your Oracle installation is installed with both 32it and 64bit client libraries, you are free to pick the one that matches your perl.


    Enjoy, Have FUN! H.Merijn
[reply]
[d/l]
[select]
Re: Do I need to build a 64bit Perl
by karlgoethebier (Abbot) on May 21, 2014 at 11:58 UTC
[reply]

Back to Seekers of Perl Wisdom