Hi Yoel, bisa tolong jelaskan lebih rinci tentang generate statpack untuk database dan gimana cara check top five wait eventnya???
terima kasih sebelumnya Widhi --- Yoel <[EMAIL PROTECTED]> wrote: > Hi Widhi, > > Lebih baik Anda generate Statpack untuk database > Anda untuk periode dimana > server Anda lambat. > Terus bisa di check Top Five Wait Event nya. > Dari situ mungkin bisa di tindak lanjutin. > Dari pada terus menebak2. > > Thanks > > > On 6/29/06, wkus77 <[EMAIL PROTECTED]> wrote: > > > > Dear rekan-rekan .... > > > > server di tempat saya mulai lama lagi, padahal > saya > > sudah reindex tabel-tabel yang bikin lama... > mungkin > > nggak sich karena space hardisk sisanya tinggal 11 > Gb, > > server jadi lambat... lalu apa yang harus > sayalakukan. > > tablespace rbs dah mencapai 3Gb, 3 tablespace > > transaksi dah mencapai 6Gb-an. tapi kalo saya > lihat > > dari free space di masing-masing tablespace masih > > kira-kira 80% free. > > > > saya lihat diserver statistik: > > redo space wait ratio--> unknown > > chained fetch ratio -->PCTFREE too low for a table > > Parse to execute ratio --> High parse to execute > ratio > > lalu apa yang harus saya lakukan??? > > > > Please help... > > Terima kasih sebelumnya > > > > Widhi > > > > __________________________________________________ > > 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] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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/
