Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Performance Issue - per_availability_details.Get_availability_details
We've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over an hour to complete, despite a moderate record count.
The only potential bottleneck I've identified is the use of the per_availability_details.Get_availability_details function in the SQL query.
How can we identify the specific table or join causing performance issues?
I'd appreciate guidance on troubleshooting the root cause of this performance issue
Tagged:
0