pak rohmad, anehnya kalau dilihat dari dalam oracle gv$servicemetric, jelas2 gak balance. kalau dari sisi OS balance hanya terlihat "process running saja" masing2 node kelahatan process running (dgn top) memang balance, tapi dari sisi utilisasi cpu, memory, disk beda banget..
so ada yg pernah mengalami? and how to solve? kemarin sempat balance karena saya coba re-register PMON terhadap service yg sedang running dgn merubah parameter local_listener, cuman ya itu dia kadang2 rada angot, load balance nya jadi dodol lagi....tapi besoknya jadi balance lagi..... he...he.... seperti teka-teki silang :) -- thanks and regards ujang | oracle dba jakarta - indonesia On Mon, Jun 23, 2008 at 10:35 AM, rohmadsan <[EMAIL PROTECTED]> wrote: > Hallo... > > Memory dan CPU sudah balance, itu berarti "load balance" sudah > tercapai. CMIIW, term "load balance" itu menitik beratkan pada load > system secara keseluruhan, bukan semata-mata jumlah session di > masing-masing instance. > > Kadang (bahkan sering) jumlah session tidak berbanding lurus dengan > load (pemakaian resource). Load untuk 1 session transaksi insert 1 row > BERBEDA dengan load untuk 1 session yang melakukan deleting 1m rows. > > Salam, > Rohmad > http://rohmad.net/category/database-oracle/ > > --- In [email protected], "Ujang Jaenudin" > > <[EMAIL PROTECTED]> wrote: >> >> lists, >> >> i have rac environment: >> hp-ux itanium >> 2 node rac >> db 10.2.0.2 >> hp-serviceguard >> >> now we got problem may be bug... >> from the OS side it seem balance, that the currently processes running >> is same (throughtop/glance) >> the memory utilization is almost balance as well as cpu >> >> but from inside oracle node2 has 70% from total sessions. >> i have configured server-side and client side load balancing altogether. >> clb_goal set to short, throughput in the service >> >> from SR support told me that querying V$osstat on this platform return >> no rows, that may be the root cause. >> >> does anyone have this kind of case? >> thanks for sharing >> >> >> -- >> thanks and regards >> ujang | oracle dba >> jakarta - indonesia
