This discussion is archived
1 Reply Latest reply: May 17, 2013 7:08 AM by fritshoogland RSS

BusinessObjects Query Preventing Exadata loading process?

1007849 Newbie
Currently Being Moderated
We use BusinessObjects to query an Exadata back end. Recently, we had an issue where the overnight DW load failed entirely - this was explained as a "resource locking issue caused by a long-running BusinessObjects report".

Does this sound plausible to the people here? My understanding is that both BusinessObjects and Exadata have preventative measures available to prevent such issues arising.

Thanks in advance.
  • 1. Re: BusinessObjects Query Preventing Exadata loading process?
    fritshoogland Oracle ACE
    Currently Being Moderated
    Please mind there is way too few information to truly know what happened. It requires at least traces of both operations to understand what truly happened.

    One thing which could have happened is the following:

    - if the BO reports use smartscans/offloading, they do full scans on the segments in the query via direct path.
    - data loading requires access to the segments it's about to load or change. This can not be done when these segments are scanned via direct path.

    Regular (non-direct path) access does not require the same protection from the database, so loads can co-exists with them much better.

    If you can get more information about where the load did wait for, we can do a little more analysis.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points