On 12/13/2010 12:04 PM, ericbamba...@discover.com wrote: > Martin, John, list
> Any ideas list? I like the direction the threading idea was going > but unless someone can re-explain it to me I think the fact that only the > execute() is slow and not the commi() it doesn't make sense. sqlplus's > execute would be on my thread and should take just as long as DBD::Oracle. > > Thanks for your help but the DBA and I are fresh out of ideas and > performance is still terrible :( > > Server 1: > AIX 6.1 > Perl (v5.12.2) > $DBI::VERSION = "1.615" > $DBD::Oracle::VERSION = '1.26' > Server 2: > AIX 5.3 > Perl v5.8.8 > $DBI::VERSION = "1.51"; > $DBD::Oracle::VERSION = '1.17'; > > Have you tried strace or wireshark/tcpdump? -r