Kalo di jelasin rinci panjang, lebih baik baca di sini http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/statspac.htm#34837
Statpack lebih simple preparationnya Kalo kamu pake oracle10g ya bisa setup Database Control atau Grid Control. http://www.oracle.com/pls/db102/portal.portal_db?selected=21 Thanks On 6/30/06, wkus77 <[EMAIL PROTECTED]> wrote: > > > 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] <yoel.ade%40gmail.com>> 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] <wkus77%40yahoo.com>> 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 > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/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/
