This patch is required for all 9.3 Service Pack 1 users. It fixes an issue with curves, a memory overwrite during archiving and a memory leak in ArcSDE for Oracle. It also fixes a separate memory leak and a compression bug in all DBMS implementations.
The ArcSDE 9.3 Service Pack 1 Memory Allocation Patch is to be applied to ArcSDE and ArcSDE clients that already have 9.3 Service Pack 1 installed.
This general ArcSDE patch fixes memory allocation issues that can cause unexpected behavior in versioned geodatabases. One fix addresses inefficient memory use affecting all supported database platforms. Two of the memory allocation issues are specific to the Oracle database. Unexpected behavior can include excessive memory use or a server/application crash after a process (e.g.; a batch reconcile process) runs for several hours. This patch also has some additional fixes in it that having nothing to do with memory allocation. We added fixes for an issue with curves specific to Oracle’s ST_GEOMETRY where an attribute only change incorrectly generalizes the curve. We also fixed a compression bug which affects all DBMS implementations.
Please see the Issues Fixed with this Patch list for details. [...]
Read more: http://support.esri.com/index.cfm?fa=downloads.patchesServicePacks.viewPatch&PID=66&MetaID=1495