ga ada pak Iw Many Thanks,
2009/4/21 Iwe <[email protected]> > > > Saya ada pertanyaan, apakah di table yang di insert dan select tsb ada tipe > data LOB? > > Iw > > ________________________________ > From: Andes Febrian <[email protected] <pejantan4u%40gmail.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Tuesday, April 21, 2009 3:00:32 PM > Subject: Re: [indo-oracle] Re: PX Deq Credit: send blkd di "Top 5 Timed > Event" > > > pak bw, ga ada di query2 yg di gunakan, menggunakan hint /*+ PARALEL( ) */ > > tp bukan cuma process insert yg "PX Deq Credit: send blkd" tinggi, select > pun sama. > > apa yg harus di lakukan pak ? > > Many Thanks, > > 2009/4/21 Yulius Wibowo <[email protected]<yulius_wibowo%40yahoo.com> > > > > > > > > > Kalau dilihat dari wait events nya, > > 1. PX Deq Credit: send blkd > > 2. enq: HW - contention > > 3. User I/O PX qreflatch > > > > Sepertinya user(aplikasi) menjalankan perintah insert secara parallel. > > Coba dichek pada SQL statementnya, apakah terdapat hint /*+ PARALLEL > (...) > > */. > > Kalau ada, usahakan nilai jangan terlalu tinggi. > > CPU count = 4, threads per CPU (default=2) ...jadi max 8. > > > > bw > > > > > > --- In [email protected] > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, Andes > > > Febrian <pejanta...@...> wrote: > > > > > > Dear gurus, > > > > > > pada AWR yg saya punya, selalu terlihat PX Deq Credit: send blkd berada > > di > > > top 5 timed event dan sangat tinggi sekali. dan saya jg bisa lihat di > top > > > activity. SGA = 8GB, PGA 2GB dan memory physic = 16GB, processor 4 dgn > > dual > > > core 3Ghz > > > > > > pertanyaan adalah, > > > 1. kenapa PX Deq Credit: send blkd selalu tinggi dan PX Deq Credit: > send > > > blkd ini buat apa ? > > > 2. gimana cara menangani masalah PX Deq Credit: send blkd ini ? apa ada > > > hubungan dengan paralel_max_server ? > > > > > > user sering restart aplikasi di karena kan performance database lambat, > > > setiap kali user mau restart, saya lihat di top activity bahwa graphic > PX > > > Deq Credit: send blkd sangat tinggi. > > > > > > berikut hasil dari top 5 timed event: > > > > > > Top 5 Timed Events > > > EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class CPU time 1,165 > > 55.0 > > > PX Deq Credit: send blkd 12,474 573 46 27.0Other enq: HW - > > > contention 99776763.6 > > > Configuration db file sequential read 10,279 57 6 2.7User I/O PX qref > > > latch11,2342821.3 > > > Other > > > mohon pencerahannya, > > > Many Thanks, > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > -- > Cheers, > ^_^ Andes ^_^ > > [Non-text portions of this message have been removed] > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
