How to tune Performance in OBIEE 11.1.17

2933551

Thanks .I think the type report logic is showing the sql time  in Administartion , could you help to explain why the type DXEExecution is very slow ?

Robert Angel

Have you seen; -

Information about DXE Execution in OBIEE Sessions (Doc ID 1527672.1)

https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=525649128479542&id=1527672.1&_afrWindowMode=0…

2933551

Thanks ,Yes I saw that ,but I confuse how to improve that?

Gianni Ceresa

2933551 wrote:Thanks ,Yes I saw that ,but I confuse how to improve that?

By understanding what happen exactly and for how long when you open that dashboard.

We are back at "response time profiling", identifying which part of the the dashboard takes long and why.

Seeing already that your analysis has 86 columns ... I would question the design of the analysis itself. But again it would require a full analysis of what happen when and where and why. There isn't a universal answer.

2933551

user required these columns. they want to down load the cvs files from Insight.

2933551

Run that query in the DB via SQL*Plus from the OBIEE server : only spent 25s

Robert Angel

Hi,

simple test re: Gianni's comment - simplify the analysis to 10 core columns, run it.

Is the runtime massively faster - if yes then you know that the problem comes because of the scale of the data that must be presented in the web.

Stand back - think would you be better doing this kind of data dump via BI Publisher?

[Deleted User]

2933551 wrote:user required these columns. they want to down load the cvs files from Insight.

1.) Data dumps are not analytics. You are using the wrong tool for the wrong requirements.

2.) Why not provide the data directly from the database?

3.) Moving data from the DB to the OBIS to the OBIPS to the browser and then to the desktop is pretty much the lesst performant way of doing things.

4.) "the user asked for it" is a poor exucse. You are the specialist. It is your job to tell him what the best solution is. Or should a doctor do the surgery a certain way because "the patient required it"?

Thomas Dodds

Don't tune OBIEE ... tune the approach to information in the enterprise ... novel concept!

[Deleted User]

I know. Silly, right?