Saran saya lebih baik migrate ke PB 9.0, soalnya saya juga pernah ngalamin masalah yang mirip yaitu mau tampilin report dengan jumlah hal 2000 an meski memory sudah diexpand dari 256 ke 1GB gak solve soalnya PB 7.0 cuma pake memory optimal 200 MB aja. Namun setelah saya coba compile ulang dengan PB 9.0, meskipun memory tetap 256MB bisa jalan.
regards, Deny ----- Original Message ----- From: "agus sofyandi" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, February 21, 2005 5:47 PM Subject: RE: [indopb] Re: out of memory > > coba script sqlnya di pecah lagi menjadi beberapa function . > > > > >From: "Muhammad Santosa" <[EMAIL PROTECTED]> > >Reply-To: [email protected] > >To: [email protected] > >Subject: [indopb] Re: out of memory > >Date: Thu, 17 Feb 2005 02:13:06 -0000 > > > > > > > >Autocommit sudah di set = true ? > >kalo belum set terlebih dahulu sebelum sql syntaxnya > >sqlca.autocommit = true > > > > > >--- In [email protected], "mugi" <[EMAIL PROTECTED]> wrote: > > > > > > ----- Original Message ----- > > > From: mugi > > > To: [email protected] > > > > > > database saya menggunakan oracle pb ver 7, saya melakukan proses > > > looping untuk insert row(melalu perintah sql), kenapa sering > >terjadi > > > out of memory (terjadi ketika proses pada rec yang ke + 13000-an > > > > > > sudah dilakukan commit tetapi masih aja out of memory > > > > > > > > > > _________________________________________________________________ > FREE pop-up blocking with the new MSN Toolbar - get it now! > http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ > > > > ----------------------------------------------- > INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT > ----------------------------------------------- > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > > > ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
