EBS 12.1.3
11.1.0.7
OL6
Hi ALL,
We have a custom Sales Report that usually runs for 3 hours, but last night it runs for 10 hours.
How do I trace the report if it needs new indexing?
How do I use Statspack to analyze this report as a concurrent program?
Can I use TKPROF to analyze this report?
How do I enable tracing in a concurrent program?
What other ways can I make it improve its performance?
Please help....
Kind regards,
jc