Performance - EBS (MOSC)

MOSC Banner

Report sometimes running for indefinite when using bom explode function

edited Jul 10, 2019 11:45PM in Performance - EBS (MOSC) 8 commentsAnswered

We have a Report usually running around 50mins, but sometimes it can run for 5hrs or more, we have to kill it. The report will run a package bompexpl.explosion_report, and query the result.

When the report run 5hrs or more, we will killed it, and bounce the DB. The report will run as normal, ard 50mins.

We noticed that it may due to the archived log switch, this will happened.

Is it when performing huge bompexpl.explosion_report that using the temporary table, and at the moment archived log switch happened, will cause this issue?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center