Hi, Pertama2x, coba list env param & versi servernya: 1. Operating System 2. Versi Oracle 3. Coba jalankan "show parameter size" dan "show parameter target" 4. Tablenya segede apa?
Quick test: coba naikan value sort_area_size=1048575, atau lebih besar lagi. wijaya --- [email protected] wrote: Message: 14 Date: Thu, 09 Jun 2005 08:52:54 -0000 From: "smileboy_ind85" <[EMAIL PROTECTED]> Subject: alokasi memory gagal haloo para oracle mania saya punya masalah dengan memory begini ceritanya......... pada saat melakukan select yang panjang atau membuat index ke beberapa kolom sekaligus di table yang besar akan terjadi error spt: ERROR at line 39: ORA-04030: out of process memory when trying to allocate 16384 bytes (sort subheap,sort key) ORA-12801: error signaled in parallel query server string jika sharedpool di parameter file ditambah sharedpool awalnya 650m ditambah 50m saja. error spt ini. startup ORA-32004: obsolete and/or deprecated parameter(s) specified ORA-27102: out of memory OSD-00022: additional error information O/S-Error: (OS 8) Not enough storage is available to process this command. kalau pakai ALTER SYSTEM set shared_pool...=700m ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-04033: Insufficient memory to grow pool SGA_MAX_SIZE nya tidak disetting, dan kalu di setting pun tetap error memory 4gb dan pemakaian sga 1.8g pga 900m oracle 10.1.0.2.0 teman2 DBA mohon kasi tau , knp sharedpool tidak bisa dinaikan lagi. trimakasih __________________________________ Discover Yahoo! Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
