Yup. coba cek lagi settingan SGA nya, dan coba cek, sort area sizenya, kegedean ga.
dan dah di coba gather statistict belum mungkin bisa di coba gather stat juga. henri From: [email protected] [[email protected]] On Behalf Of murdi santoso [[email protected]] Sent: Wednesday, July 22, 2009 10:13 AM To: [email protected] Subject: External Email : --> Re: [indo-oracle] DB Oracle Super Lambat saya setuju dengan rekan saya indra, check setingan memory di kernel shmmax dan di oracle parameter sga_max_size, sga_target, jika databasenya menggunakan version 10g silahkan jalankan awr tuk mendapat suggest dari oracle tuk tuning. <font color="#7f003f"><strong>--Murdi Santoso--</strong> </font> ________________________________ From: indrajati chairuddin <[email protected]> To: [email protected] Sent: Wednesday, July 22, 2009 9:21:44 AM Subject: RE: [indo-oracle] DB Oracle Super Lambat Dear kang asep, Cobain shmmax nya disetting lagi dari sisi OS. Teras . parameter sga_max_size dan sga_targetnya juga disetting lagi. _____ From: indo-oracle@ yahoogroups. com [mailto:indo-oracle@ yahoogroups. com] On Behalf Of ASEP APENDI Sent: Wednesday, July 22, 2009 9:15 AM To: indo-oracle@ yahoogroups. com Subject: [indo-oracle] DB Oracle Super Lambat Dear teman-teman, mohon analisanya apa yang terjadi pada db saya, sudah sejak minggu kemarin proses di db oracle sangat lambat, proses insert/update sangat lambat, proses reporting juga sangat lambat, enterprise manager juga tidak bisa dipanggil,bisa dipanggil apabila services-nya direstart tapi 15-20 menit kemudian tidak bisa dipanggil lagi. Saya sudah restart db dan Redhat-nya tetapi masih belum mengobati masalah, apalagi yang harus saya lakukan? Mohon saran dari teman-teman. Terimakasih [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference.
