We are currently experiencing performance issues with Oracle Analytics Server. One of the bottlenecks identified is hard parsing, caused by the absence of bind variables in our SQL queries (not supported in Oracle Analytics). Instead, literals are being sent for every dashboard prompt and filter value. Consequently, each time users apply different prompts or filter values, the database generates a new SQL ID. This not only increases the overhead associated with hard parsing but also complicates performance debugging efforts.

Introducing the use of bind variables would greatly alleviate these issues. Reference:

Improve SQL Query Performance by Using Bind Variables