Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EBS 12.1.3 - Sales Report Concurrent Program

Beauty_and_dBestNov 7 2019 — edited Feb 9 2021

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

This post has been answered by John_K on Nov 11 2019
Jump to Answer

Comments

Post Details

Added on Nov 7 2019
8 comments
121 views