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] ------------------------ 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/
