to pak teguh, waduh, klo utk cari settingan undo retention yg pas, saya jg bingung, pak hehe... klo setau saya, supaya gk kluar "snapshot too old", undo retentionnya msti d kecilin, tp klo undo retention nya kekecilan, long processes bakalan error :(... mungkin perintah "alter tablespace resize datafile" itu bs dcoba, pak... saya ndiri dulu pake perintah tp utk sizenya ms pake cara kuno, trial n error hehe btw, mo gantian nanya, gmana cara ngeluarin hasil "actual undo size" n "need undo size" nya itu ya, pak? :D koq saya query dr v$undostat, hasilnya bkn gtu? thx... CMIIW, [L]
--- On Fri, 5/15/09, Teguh Susanto <[email protected]> wrote: From: Teguh Susanto <[email protected]> Subject: Re: [indo-oracle] Error ORA 1555 To: [email protected] Date: Friday, May 15, 2009, 11:06 AM makasih pak leon atas sharenya... he3 kebetulan sy ini programmer&ngarangk ap admin.... tadi sy coba ALTER SYSTEM SET UNDO_RETENTION = 1200 ini setelah sy query table v$undostat nya ACTUAL UNDE SIZE = 2048.00390625 UNDO RETENTION = 1200 NEED UNDO SIZE = 4.921875 apakah sy harus meng alter : alter tablespace undo_ts_01 add datafile ‘/u006/oradata/ SID1/undo_ ts_01_02. dbf’ <sesuai NEED UNDO SIZE nya?> --- Pada Kam, 14/5/09, Leonard Sukendro <leon_190699@ yahoo.com> menulis: Dari: Leonard Sukendro <leon_190699@ yahoo.com> Topik: Re: [indo-oracle] Error ORA 1555 Kepada: indo-oracle@ yahoogroups. com Tanggal: Kamis, 14 Mei, 2009, 10:33 PM to pak teguh, dl saya prnah punya mslh yg sama, n untungnya bs solve stlh saya extend undo tablespace nya... utk tau ukuran idealnya, mungkin bs d monitor undo usagenya pas proses2 gede itu... ato klo gk bisa, minta tlong programmernya utk commit lbh sering bila ada DML yg besar... misal, commit per-500 record... moga2 bisa membantu, pak... CMIIW, [L] --- On Fri, 5/15/09, Teguh Susanto <teguh4milis@ yahoo.com> wrote: From: Teguh Susanto <teguh4milis@ yahoo.com> Subject: [indo-oracle] Error ORA 1555 To: indo-oracle@ yahoogroups. com Date: Friday, May 15, 2009, 8:54 AM kepada miliser&senior DBA mau minta tolong nich, gimana yach ngatasi error ORA 1555-snapshot too old: rollback segment number setiap sy melakukan query dgn join,union dan transaksi yg banyak pasti error tsb muncul Lebih bersih, Lebih baik, Lebih cepat - Yahoo! Mail: Kini tanpa iklan. Rasakan bedanya! http://id.mail. yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Menambah banyak teman sangatlah mudah dan cepat. Undang teman dari Hotmail, Gmail ke Yahoo! Messenger sekarang! http://id.messenger .yahoo.com/ invite/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
