SUMMARY: Oracle dblinks slow after upgrade to 5.1b PK2

From: Medaglia, Chris (cmedagli@Lifelinesys.com)
Date: Fri Aug 08 2003 - 10:51:45 EDT


Hi all,
  The problem here ended up being the kernel parameter new_wire_method.
Oracle recommends this to be set to zero, by default it is one. We have it
set to zero on all our other systems, and this may or may not have changed
during the PK2 patch upgrade. I don't know, because we didn't have an output
of our kernel parameters before the upgrade. Anyway, setting it to zero
solved out performance issues.

Chris Medaglia



This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:49:30 EDT