Re: Online 6.0: UPDATE STISTICS needs all memory

tetzlaff@quantum.de (Lars Tetzlaff) wrote: > > I have a problem upgrading form 4.1 to 6.0 > > After i installed my old 4.1 database as a new NLS database > (via dbexport dbimport ), i tried to 'update statistics medium' > on the new database. Executing this statement allocates one > shm-segment after another unil there is no space left (errno ENOMEM)! > It does so even on a table with only 3 rows! Updating on only > one column of this table works. > > Does anyone know this problem (and a solution)? > > My system: > SINIX-L 5.41 D0005 i386 MX300I with Online 6.00.UE1 > > Lars There are known problems with Online 6.0 memory handling. We have been going through some of these bumps as well. Online 7 promises to fix this, so our plan is to upgrade as soon as possible.