distributed_transactions ada lah static parameter. jadi harus dirubah di init.ora dan di restart
On 8/3/06, Ryant Febrian <[EMAIL PROTECTED]> wrote: > > Ok. Makasih atas tutorial singkatnya tp padat dan bermakna :) > saya ulang ya, hehehehe.. jd klo saya rubah parameter dengan > ALTER SYSTEM SET distributed_transactions = 60; maka database tidak perlu > di restart. Ok, makasih banyak atas bantuannya. > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com>> wrote: hhmmmm... > > V$ adalah dynamic performance view, it is not meant to be updated. > rubah oracle parameter itu menggunakan > 1. 'ALTER SYSTEM SET <parameter name> = <value>' (untuk dynamic parameter) > 2. Ubah di Init.ora file (untuk static & dynamic parameter) > > Untuk static parameter harus di restart databasenya, supaya membaca > parameter yang baru. > > On 8/2/06, Ryant Febrian <[EMAIL PROTECTED] <pejantan_4u%40yahoo.com>> > wrote: > > > > Maaf tanya lg.. hehehehe, masih lemot nie > > bila di tempat saya setelah di show parameter > > > > > > NAME TYPE VALUE > > ------------------------------------ ------- > > ------------------------------ > > distributed_transactions integer 50 > > > > bila saya rubah parameternya, berarti saya update table v$parameter set > > value = 60 where name distributed_transactions; > > harus kah saya restart lg databasenya atau cukup di commit aja? lalu > kira2 > > berpengaruh ga ya nantinya? > > > > sekali lagi saya ucapkan terima kasih atas bantuannya :) > > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> <yoel.ade%40gmail.com>> > wrote: Ini saya coba pake > > > Oracle 8.1.7 > > > > > > SQL> nect / as sysdba > > Connected. > > SQL> show parameter distributed_transactions > > > > NAME TYPE VALUE > > ------------------------------------ ------- > > ------------------------------ > > distributed_transactions integer 500 > > SQL> > > > > kalo misalnya tidak ada di init file ya tinggal di tambahkan saja. > > > > Mengenai nilainya berapa, saya kurang tau. > > karena tidak pernah pakai. Mungkin bisa di coba dinaikan sedikit2. > > tidak bisa lebih dari parameter transactions > > > > Thanks > > > > On 8/1/06, Ryant Febrian <[EMAIL > > PROTECTED]<pejantan_4u%40yahoo.com><pejantan_4u% > 40yahoo.com>> > > wrote: > > > > > > Maaf saya masih belum paham, tentang distributed_transactions > parameter > > > di init.ora file, krn setalah saya cari2 tidak ada > > > distributed_transactions. Apakah ada nama lain dr parameter tersebut > yg > > di > > > rubah? klo di rubah, misal, sampai batas berapakah saya harus > > merubahnya? > > > > > > Terima kasih > > > > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> <yoel.ade%40gmail.com> > <yoel.ade%40gmail.com>> > > > wrote: di init.ora file. > > > > > > > > > > > On 8/1/06, Ryant Febrian <[EMAIL PROTECTED]<pejantan_4u%40yahoo.com> > <pejantan_4u%40yahoo.com><pejantan_4u% > > > 40yahoo.com>> > > > wrote: > > > > > > > > Saya menggunakan oracle versi 8.1.6 OS SunOS. > > > > klo distributed_transactions parameter itu saya tinggal alter aja > > > > menggunakan user sys as sysdba atau di rubah di file init.ora?? > > > > > > > > Terima Kasih > > > > > > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> < > yoel.ade%40gmail.com> <yoel.ade%40gmail.com> > > <yoel.ade%40gmail.com>> > > > > > wrote: ada > > > > > > > DISTRIBUTED_TRANSACTIONS parameter, > > > > > > > > tapi obsolete untuk Oracle 9i R2 ke atas. > > > > > > > > Anda pake version brapa? OSnya apa > > > > > > > > On 8/1/06, Ryant Febrian <[EMAIL PROTECTED]<pejantan_4u%40yahoo.com> > <pejantan_4u%40yahoo.com> > > <pejantan_4u%40yahoo.com><pejantan_4u% > > > > > > 40yahoo.com>> > > > > wrote: > > > > > > > > > > iya, akhirnya saya restart aja mesinnya dan databasenya otomatis > > mati > > > > > dan saya nyalain lagi. tp adakah solusi selain itu?? adakah cara > > > supaya > > > > > distributed transactions nya di perbesar? bila ada apanya yg harus > > > saya > > > > > ubah? Mohon bantuannya. :D > > > > > > > > > > Terima Kasih > > > > > > > > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> < > yoel.ade%40gmail.com> < > > yoel.ade%40gmail.com> <yoel.ade%40gmail.com> > > > <yoel.ade%40gmail.com>> > > > > > > > wrote: taken from oracle > > > > > > > > > documentation > > > > > > > > > > > > > > > ORA-02042: too many distributed transactions Cause: the > distributed > > > > > transaction table was full because too many distributed > transactions > > > > were > > > > > active. > > > > > Action: Run fewer transactions. If you are sure you don't have too > > > many > > > > > concurrent distributed transactions, this indicates an internal > > error > > > > and > > > > > support should be notified. Instance shutdown/restart would be a > > > > > work-around. > > > > > > > > > > On 8/1/06, Ryant Febrian <[EMAIL PROTECTED]<pejantan_4u%40yahoo.com> > <pejantan_4u%40yahoo.com> > > <pejantan_4u%40yahoo.com> > > > <pejantan_4u%40yahoo.com><pejantan_4u% > > > > > > > > > 40yahoo.com>> > > > > > > > > > wrote: > > > > > > > > > > > > Hi rekan2 semua.. > > > > > > > > > > > > Saya mendapatkan eror seperti dibawah ini : > > > > > > > > > > > > ORA-02042: too many distributed transactions > > > > > > > > > > > > Apa yg harus saya lakukan supaya tidak terjadi eror seperti ini > > lg? > > > > > apakah > > > > > > ini ada hubungan dgn file init.ora ? atau adakah yg harus saya > > rubah > > > ? > > > > > > Dan untuk yg connect catalog, net service itu seperti > > > > > > localhost.localdomain kan?? > > > > > > > > > > > > Terima kasih > > > > > > > > > > > > > > > > > > --------------------------------- > > > > > > Groups are talking. We´re listening. Check out the handy > > > changes > > > > > to > > > > > > Yahoo! Groups. > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------- > > > > > Yahoo! Music Unlimited - Access over 1 million songs.Try it free. > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Tired of spam? Yahoo! Mail has the best spam protection around > > > > http://mail.yahoo.com > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > --------------------------------- > > > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great > > rates > > > starting at 1�/min. > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Get on board. You're invited to try the new Yahoo! Mail Beta. > > > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > --------------------------------- > See the all-new, redesigned Yahoo.com. Check it out. > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
