Mas Ali, terima kasih atas tanggapannya, saya rasa index saya corrupt, dan saya sudah coba drop indexnya dan buat index baru tapi pada salah satu table ada constraint yang tidak bisa dienable dan muncul pesan error :
ORA-00604: error occurred at recursive SQL level 1 ORA-03232: unable to allocate an extent of 10 blocks from tablespace 3 ada solusinya nggak mas... please help.. Thanks Widhi --- Ali Imran <[EMAIL PROTECTED]> wrote: > Mas Widhi, > > Sebenarnya kalo satu table diakses lebih dari satu > user atau report atau program ya gak masalah, > mungkin tablenya mas widhi belum di index? > Bisa juga report yang prosesnya lambat itu karena > dari query-nya. Biasanya report kan pake range > tanggal, coba dites querynya satu persatu. > Semoga membantu.. > > CMIIW > Ali > -------------------------------------------------------- > PT. Reasuransi Nasional Indonesia > Jl. Cikini Raya 99 > Jakarta 10330 Indonesia > Phone (62)021-3140009 > FAX (62) 0999999 > 0815 10385802 > http://aliimran.wordpress.com > ----- Original Message ----- > From: wkus77 > To: [email protected] > Sent: Friday, April 07, 2006 4:39 PM > Subject: [indo-oracle] Report lambat jika ada bbrp > report lain yang akses ke table yang sama > > > Halo rekan-rekan,... > > saya mo tanya.. mungkin ada yang tahu... > > saya punya beberapa report yang purposenya beda > tapi > akses ke table yang sama(table yang tumbuhnya > sangat > cepat cth :table x,y). nah kalo ada beberapa user > yang > menjalankan report ini. report jalan, tapi sangat > lambat sekali. saya sudah pisahkan table yang > tumbuhnya cepat ini disatu tablespace terpisah... > saya > juga sudah jalankan Analyze table ... validate > structure. tapi tetap report tersebut jalannya > lambat > jika ada beberapa report lain yang akses ke table > yang > sama(table X,Y). sebelumnya (sebelum saya pindah > ke > server yang dual procesor) masing-masing report > ini > bisa jalan bareng tapi gak lambat. > > ada solusi nggak.... please help.... usernya > cerewet2 > bgt.... > > Thanks in advance > > Widhi > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User > Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > SPONSORED LINKS Membership database software > Database mortgage software Pda database software > Database management software Oracle > database administration Oracle database management > > > > ------------------------------------------------------------------------------ > YAHOO! GROUPS LINKS > > a.. Visit your group "indo-oracle" on the web. > > b.. To unsubscribe from this group, send an > email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > ------------------------------------------------------------------------------ > > > > [Non-text portions of this message have been > removed] > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- 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/
