he..he... artikel dari si gemblung toh :-) saya coba buat test case dgn env: oracle 10.2.0.4 on winblowz + shared server;
kalau diperhatikan pada test case sederhana dibawah ini, kita sudah dapat menyimpulkan kalau dgn work_area_size_policy auto, maka *area_size akan diignore, tapi kalau diset manual, maka akan dipakai, even jika saya isi *area_size ketika work_area_size_policy auto, hasilnya akan sama 71 optimal passes. ========================================================= restart db NAME TYPE VALUE ------------------------------------ ----------- ------- sort_area_retained_size integer 0 sort_area_size integer 0 workarea_size_policy string AUTO pga_aggregate_target big integer 142M other session check sorting statistic (init): PROFILE CNT PERCENTAGE --------------------------------- ---------- ---------- workarea executions - optimal 41 100 workarea executions - onepass 0 0 workarea executions - multipass 0 0 SQL> select * from sh.sales order by amount_sold; other session check sorting statistic (after sort done): PROFILE CNT PERCENTAGE --------------------------------- ---------- ---------- workarea executions - optimal 112 100 workarea executions - onepass 0 0 workarea executions - multipass 0 0 -- 71 optimal passes ========================================================= restart db NAME TYPE VALUE ------------------------------------ ----------- ------- sort_area_retained_size integer 5120 sort_area_size integer 5120 workarea_size_policy string MANUAL pga_aggregate_target big integer 142M other session check sorting statistic (init): PROFILE CNT PERCENTAGE --------------------------------- ---------- ---------- workarea executions - optimal 87 100 workarea executions - onepass 0 0 workarea executions - multipass 0 0 SQL> select * from sh.sales order by amount_sold; other session check sorting statistic (after sort done): PROFILE CNT PERCENTAGE --------------------------------- ---------- ---------- workarea executions - optimal 245 100 workarea executions - onepass 0 0 workarea executions - multipass 0 0 -- 158 optimal passes ========================================================= 2009/5/25 martin <[email protected]>: >> ada url? > ada banyak salah satunya > http://www.dba-oracle.com/p_sort_area_size.htm > gimana ada ide bila pakai share server?? > > >> namun begitu, jika memang memakai shared server, kenapa harus >> memperhatikan sorting? > Untuk report ( biasanya haus akan sort ) > >> asumsi saya kalau memperhatikan sorting means ada reporting or batch >> process yg membutuhkan waktu lama. > benar ( report bulanan / 3 bln an / thn ) > >> by design shared server is "slower" than dedicated, karena adanya >> proses antrian diantara dispatcher dan shared server nya sendiri. > > benar tapi kalau memory kurang dan utk beli agak susah mungkin ini bisa > solusi untuk ini. bisa juga bisa sudah salah install ( mau pilih > dedicate malah kepilih share ) > > >> rule of thumb pemakaian shared server,adalah untuk short transaction >> dimana <1 detik per transaksi per session. >> > Untuk ini thank's atas infonya > > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > 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 > > > > -- thanks and regards ujang | oracle dba | mysql dba http://ora62.wordpress.com
