Witango won't give you any options automatically.
One option you have is to manually create a cached query. I'm not sure how to do this on Oracle, but in SQL Server it would be sp_prepare() followed by multiple sp_execute(). That's probably a tricky implementation, and so I may suggest using a pre-compiled stored procedure. Witango allows for the DirectDBMS action to contains "EXEC namedStoredProcedure" for this purpose. Robert From: Jeyakumar, Prabakaran [mailto:prabakaran.jeyaku...@accenture.com] Sent: Wednesday, October 02, 2019 8:36 PM To: TeraScript-Talk@terascript.com Subject: TeraScript-Talk: How to reduce parse call count in Oracle fromWitango Hi Team, When i am executing the select query using Witango search action in for loop, most of the times the parse call count is equivalent to the number of execution when we are checking the DB stats pack. In this case performance is getting impacted. Is there any way to reduce the parse call count ? Thanks & Regards Prabakaran _____ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy. Your privacy is important to us. Accenture uses your personal data only in compliance with data protection laws. For further information on how Accenture processes your personal data, please see our privacy statement at https://www.accenture.com/us-en/privacy-policy. ______________________________________________________________________________________ www.accenture.com <http://www.accenture.com> _____ To unsubscribe from this list, please send an email to lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.
