RSS

what is the DXE Execution in OBIEE 11G Session log?

30 Sep

In OBIEE 11G if we look at Session logs, we will see a new status called ‘DXE Execution’ with amount of time its been executed. I did some research on this to answer my burning questions ‘ What this new alien will do? and How it is helpful for Performance tuning?.

Then I founded interesting news about this and actually the DXE Execution means “Data Transformation Engine which handles post-processing of the BIServer results within OBIPS”.

The post-processing can involve resorting, filtering, aggregating, and/or indexing the original BIServer result set so that the data can be consumed by a view’s renderer. And It can be automatically kicked off when the BIServer query finishes.

So if the DXE Execution is running long time, Then it’s time to open your arms to tune your report UI/Presentation Server.

Of course if the sql query is taking long time, We know how to tune DB(A)’s  :).

 

 

Thanks,

Shiva.

Advertisements
 
9 Comments

Posted by on September 30, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , , , , , , ,

9 responses to “what is the DXE Execution in OBIEE 11G Session log?

  1. Nir

    October 3, 2011 at 11:27 am

    And how do I ‘tune your report UI/Presentation Server’?

     
  2. Robin Moffatt (@rnm1978)

    February 2, 2012 at 8:51 am

    Hi Shiva,

    This sounds a useful metric. Can you clarify where it’s found; do you mean in the front end Manage Sessions, or in nqquery.log? I’ve looked in both and couldn’t see it.

    thanks, Robin.

     
    • Shiva Molabanti

      September 7, 2013 at 5:37 pm

      It can be found in OBIEE manage sessions for every report log.

      Thanks,
      Shiva

       
  3. Saichand

    July 25, 2012 at 9:38 am

    Today I came across with same issues ‘DXE Execution:parent cursor IDs=35178,cache key=35178~6p5t1fn1uq1l855kdh5csthude’

    OBIEE report(Direct DB) is taking ages to complete and same query in DB 5sec

     
    • Shiva Molabanti

      September 7, 2013 at 5:38 pm

      Check your OBI PS cache and JVM. Looks like you have lot of Post BI operations (aggregations, Sortings etc.,..).

      Thanks,
      Shiva

       
  4. Jagadeesha

    August 28, 2013 at 10:25 am

    Hi Shiva,

    Excellent information. Thank you.

    But in your post, you have told indexing,aggregation and filter by DXE. Could you please elaborate on this.

    As of my knowledge aggegation,filtering and indexing will all happen in backend only. Please explain me you again the DXE does there things again.

    Thanks
    Jagadeesh

     
    • Shiva Molabanti

      September 7, 2013 at 5:36 pm

      Jagadeesha,
      The OBI PS will store the data in its tmp files and will do the resorting or report level aggregates on top of that. All the Post BI server operations will be handled by DXE.

      Thanks,
      Shiva

       
  5. yağmur

    April 10, 2015 at 2:53 pm

    Hi Shiva, firstly thanks for your post.

    I am getting same error after changing Oracle BI server from Windows Server 2008 R2 to Windows Server 2012 R2. After changing server only one of my report gets same error “DXE Execution:parent cursor IDs=46139,cache key=…”

    I found many pages on internet about this problem but no one have any solution about it. Could you help me?

     
  6. Pavan

    June 16, 2015 at 9:00 am

    HI Siva,

    I facing same issue . DB query getting result in 5mins where as DXE query taking 20+mins . Can you tell me how to tune the query

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: