Oracle Communities

Oracle Analytics and AI

Child Item

Dashboard prompts taking too long

Summary

Dashboard prompts taking too long

Content

I have a dashboard prompt that is taking too long to populate list values, the column is index and it seems to happen on one specific prompt selection, i have tried everything under the book but still not getting any resolution. anyone else that has come across this issue?

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

3337789 wrote:i have tried everything under the book but still not getting any resolution

Like what? What have you tried? We can't know what "book" you mean and what it contains...

ForSly

I have changed the order of the prompts so that each prompt filter filters data based on the filter above it, i have recreated the indexes for the columns and still having same issue.

ForSly

I dont have access to log file but i can look at SQL execution. what should i be looking at exactly on the SQL execution?

[Deleted User]

Well the explain plan...

[Deleted User]

Have you looked at the log files? Checked the exact SQL and execution?