Alo.. jangan lupa liat... database nya dibuat pake archive mode atau gak? kalo archive...liat space buat archive log nya.. biasanya kalo sudah penuh..jadi hang.. tapi applikasi jalan normal... yoga
Abang Napi <[EMAIL PROTECTED]> wrote: 1. cek file log nya di bdump , biasanya namanya alert_<SID>.log 2. cek juga top SQL nya di OEM. lihat cost nya. 3. cek juga process mana yg makan resource paling besar. (kalau UNIX/linux , bisa lihat top nya, kalau windows lihat di task manager) 4. cek juga setting parameter di init.ora 5. coba execute statspack. there's a lot of information you can get about your oracle from this. On 7/20/05, Abu-NAufal <[EMAIL PROTECTED]> wrote: > Para Senior, > > Saya mau nanya, > Oracle saya kok sering nge hang ya ? > Padahal aplikasi yang jalan di server yang sama tidak > masalah, berarti masalahnya di oraclenya kan ? > Saya coba buka SQL Plus juga nggak bisa (not responding > terus). > Baru kalau restart server bisa jalan lagi tapi kalau > sering-sering begini kan jadi lucu > Mohon bantuannya > > > Terima Kasih > Ardhian > ======================================================================================== > Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % khusus untuk wilayah > Jawa Timur. > Informasi selengkapnya di www.telkomnetinstan.com atau hub 0800-1-INSTAN > (467826) > ======================================================================================== > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com SPONSORED LINKS Database development software Database management software Database software Inventory database software Membership database software Citrix terminal server --------------------------------- YAHOO! GROUPS LINKS Visit your group "indo-oracle" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - 1GB free storage! [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.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/
