makasih pak leon atas sharenya... he3 kebetulan sy ini programmer&ngarangkap 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 <[email protected]> menulis: Dari: Leonard Sukendro <[email protected]> Topik: Re: [indo-oracle] Error ORA 1555 Kepada: [email protected] 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]
