Databasenya pakai archive mode. Mungkin saja sih archive lognya penuh caranya memperbesar archive log gimana ya?
Sorry ya newbie banget sih.... On Thu, 21 Jul 2005 10:15:28 +0800 (CST) yoga fm <[EMAIL PROTECTED]> wrote: > 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 > > > > > > ======================================================================================== 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 <*> 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/
