Dear Jan, Kemungkinan query yang dipakai developper kebanyakan tidak memakai bind variable usahakan memngoptimalkan pemakaian bind variable.
tapi untuk bisa juga dipaksa dengan merubah cursor_sharing=force (jika db anda sudah 10g) henri From: [email protected] [[email protected]] On Behalf Of jancrot [[email protected]] Sent: Thursday, September 24, 2009 11:06 AM To: [email protected] Subject: External Email : --> [indo-oracle] [Hard parsing SQL Statement] Hik hik... Tolong dongg :(( Salam, Bapak-bapak dan ibu-ibu.. tolong saya dong... Kenapa Enterprise Manager saya mengeluarkan kalimat seperti ini ya? "Hard parsing SQL statements that encountered parse errors was consuming significant database time" Impact (minutes) 25.4 Memang query-nya lambaaat banget (sekitar 1 jam). Apa salahku? Apa salah query-ku? Apa yang harus kuperbuat? Query yang di-invoke adalah query bulk insert dan bulk update. Di dalam query itu memang terdapat beberapa bind variable (sekitar 7).. tetapi masak parsing bind variable sejumlah itu disebut "Hard parsing"?? 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.
