Mungkin link berikut ini bisa sedikit memberi bantuan mengenai sizing di undotbs.
Optimize oracle Undo parameters semoga membantu ya.. ________________________________ Dari: Leonard Sukendro <[email protected]> Kepada: [email protected] Terkirim: Jumat, 15 Mei, 2009 14:44:33 Topik: Re: [indo-oracle] Error ORA 1555 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 <teguh4milis@ yahoo.com> wrote: From: Teguh Susanto <teguh4milis@ yahoo.com> Subject: Re: [indo-oracle] Error ORA 1555 To: indo-oracle@ yahoogroups. com 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] Cepat, Bebas Iklan, Kapasitas Tanpa Batas - Dengan Yahoo! Mail Anda bisa mendapatkan semuanya. http://id.mail.yahoo.com [Non-text portions of this message have been removed]
