ini di local bos... :D ** yg jadi bos siapa niii..he he he undo_retention nya dah gw kecilin... sampe 600 dan malah gw shutdown DB nya, karna gw mesti balik .he he he
Tapi, ini sudah solved, gw sudah ikutin cara Mas Trio Samsul.. gw bikin undo baru.... parameter oracle nya gw map ke yg baru.. dan yg lama gw drop... thnx Mas Trio... Thanx best regards Moch Firman N 2008/1/15 Leonard Sukendro <[EMAIL PROTECTED]>: > > to pak firman... > > setau saya (n moga2 saya gk salah :D), isi undotbs itu > jg tgantung dr parameter undo_retention.. > klo mo cepet2 di clear isinya, nilai dr parameter > undo_retention itu di kecilin aja, boss... > cmn kemungkinan efeknya klo nanti ada proses DML yg > lama.. pas proses itu bln kelar, waktu > undo_retentionnya dh tercapai, prosesnya bakal error.. > biasanya kluar error "snapshot too old.. bla2" > > tp selama masi ada proses DML, undo gk mungkin bner2 > kosong, pasti masi ada isinya.. klo mo bner2 kosong, > mesti ikutin cara pak Syamsul, boss... > > moga2 membantu, boss... > > CMIIW, > [L] > > > --- Moch Firman N <[EMAIL PROTECTED] <mochfirman%40gmail.com>> wrote: > > > Thanx ya atas feedback nya..., > > klw soal googling sudah mas.... :D > > > > Oh iya, > > Apa ada cara yg lebih halus.. tanpa meng-drop undo > > yg lama.. :) > > cuma nge-clear ? > > > > danke, > > > > > > On Jan 9, 2008 3:31 PM, Trio Syamsul Benny > > <[EMAIL PROTECTED] <trio198%40gmail.com>> wrote: > > > > > Udah coba googling mas? > > > > > > Dulu pernah juga ngelakuin ini, caranya kira2: > > > - Login as sys. > > > - Create undo tablespace ke dua. > > > SQL> create undo tablespace UNDOTBS2 datafile > > > "/oracle/oradata/codotdb/undotbs2.dbf" size 1000m; > > > - Set undo tablespace ke tablespace yang baru itu > > > SQL> alter system set undo_tablespace=UNDOTBS2; > > > - Drop old undo tablespace lam > > > SQL> drop tablespace UNDOTBS1 including contents; > > > > > > Klo didrop gak bisa, berarti masih dipake > > undotbs1, coba force switch ke > > > log > > > berikutnya. > > > > > > -benny- > > > > > > > > > On 1/9/08, Moch Firman N <[EMAIL PROTECTED]<mochfirman%40gmail.com> > > <mochfirman%40gmail.com>> > > > wrote: > > > > > > > > Dear All, > > > > > > > > Untuk meng-clear tablespace undo cara-nya > > gimana? Ada yg bisa ngasih > > > > penjelasan..!!! > > > > > > > > Terima kasih, > > > > > > > > Best regards > > > > Moch Firman N > > > > > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > > > > > > > [Non-text portions of this message have been > > removed] > > > > > > __________________________________________________________ > Looking for last minute shopping deals? > Find them fast with Yahoo! Search. > http://tools.search.yahoo.com/newsearch/category.php?category=shopping > > [Non-text portions of this message have been removed]
