I am trying to understand the memory used by IE (version 9) using Task Manager for OBIEE (188.8.131.52.0) sessions.
I have a few dashboards. One of them is very simple. It has a single page that has no prompt, just one Analysis that displays a row with three columns from a database table (and the table has a single row so no filters applied) using a standard Table view. Other dashboards have got pages, prompts, standard graph and table views along with filters within respective analyses.
When the OBIEE pages are visited I notice that the memory shown by Windows Task Manager goes on increasing even if I visit a simplest dashboard like the above. The task manager shows reduced memory HOWEVER that is not significant. The table below give you a trend.
|Page||Complexity||# of Analyses||# of prompts||Memory (Cumulative)||Comments|
|5||Medium||1||15||132 K||Just went through the page prompts without re-running the page.|
|1||Simple||1||None||126 K||Page 1, when visted first time used 56 K, then 112 K, then 119 K.|
|2||Medium||1||12||135 K||Just went through the page prompts without re-running the page.|
|Logged Out||136 K||Waited for 5 minutes|
|Logged In||135 K||Clicked 'here' of the "To sign in again, click here" message on the sign out page.|
|Home Page||140 K|
|1||Simple||1||None||145 K||Why initially for the same page the Task Manager showed only 56 K and now more value.|
|4||Complex||7||2||256 K||For the same page, same prompt values why more memory usage when initially 216 K was shown.|
|3||Complex||12||2||213 K||Initially, the task manager showed 154 K for this page (same prompt values).|
|1||Simple||1||None||180 K||The last time, the task manager showed 140 K for this simple page.|
|Logged Out||174 K||Waited for about four minutes.|
|Logged In||Clicked 'here' of the "To sign in again, click here" message on the sign out page.|
|Home Page||178 K|
|4||Complex||7||2||289 K||Last time, the task manager showed 256 K.|
|5||Medium||1||15||203 K||Last time, the task manager showed 123 K.|
|1||Simple||1||None||201 K||First time, 56 K and the last time, 180 K.|
I am trying to understand whether there is any parameter, any fine tuning process that can be considered to keep the values within acceptance. Please think from users perspective who are busy during the day, may not logout, attend some meetings, come back to the desk only to find later during the day the memory usage is getting higher and higher and subsequently, unable to run the reports quicker.