Trimakasih pak Andrew atas masukannya. Dalam hal ini yg diset di init.ora undo_management=AUTO dan undo_retention=3600 apakah undo_retention perlu dibesarkan lgi misalkan menjadi undo_retention=7200 dan klo diperbesar ada efek sampingnya ga...? trimakasih atas bantuannya. thx Bambang
"Andrew E.K." <[EMAIL PROTECTED]> wrote: Ini saya ambil dari documentation: Cause: Rollback records needed by a reader for consistent read are overwritten by other writers. Action: If in Automatic Undo Management mode, increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments. Value pada Undo_retention(detik) dapat disesuaikan keperluan, seberapa lama transaksi disimpan pada undo segment sebelum di overwrite transakasi lain. Jika untuk transaksi yang cukup panjang anda bisa memperbesar rollback segment anda (tablespace UNDOTBS jika default) agar memiliki cukup space transaksi yang sedang berlangsung. Semoga membantu :) Andrew --- Bambang Irianto <[EMAIL PROTECTED]> wrote: > Pada waktu mau close accounting periode di inventory > pada oracle apps 11.5.9 and db 9.2.0 terjadi error > 'CSTACPCS:20ORA-01555: snapshot too old: rollback > segment number 2 with name "_SYSSMU2$" too small'. > Mau tanya nih kira2 ada yg pernah ngalami seperti > itu and klo ada solusinya boleh dong di share. Atas > perhatiannya terimakasih. > > Thx > > Bambang > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > [Non-text portions of this message have been > removed] > > __________________________________ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 -- -----------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 Visit your group "indo-oracle" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] -- -----------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/
