Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to tune Performance in OBIEE 11.1.17
Answers
-
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 ?
0 -
-
Thanks ,Yes I saw that ,but I confuse how to improve that?
0 -
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.
0 -
user required these columns. they want to down load the cvs files from Insight.
0 -
Run that query in the DB via SQL*Plus from the OBIEE server : only spent 25s
0 -
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?
0 -
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"?
0 -
Don't tune OBIEE ... tune the approach to information in the enterprise ... novel concept!
0 -
I know. Silly, right?
0
