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]> 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>> 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>> > 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>> > wrote: di init.ora file. > > > > > > > On 8/1/06, Ryant Febrian <[EMAIL > > PROTECTED]<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>> > > > 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>> > > > 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>> > > > > > 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>> > > > > > > > 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] -- -----------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/
