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 <[email protected]> wrote: From: Teguh Susanto <[email protected]> Subject: [indo-oracle] Error ORA 1555 To: [email protected] 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]
