This content has been marked as final. Show 6 replies
Hi,1 person found this helpful
Difficult to say anything on performance issue until we dont get fiddler report, Smartview log files etc...
Try below if it helps :
In Smartview go to Options->advance and make sure the following options
1. Improve metadata storage.
2. Reduce Excel file size
Tim Tow wrote a blog on Samrt view performance, you can google it. Two things he mentions is1 person found this helpful
1. Make sure Use Excel formatting is turned on
2. Make sure repeat member names is set properly (I don't remember offhand if it should be on or off).
I did find a bug (already documented) you get weird results if you have checked retain formatting on formulasand comments . After a while you get lots of blank rows between each row of a retrieve
Edited by: GlennS_3 on Nov 2, 2012 9:27 AM
Does your virus scanner exclude the ORACLE_HOME directory?1 person found this helpful
Excellent "left field" suggestion.
At the moment, we cannot access the settings for the AV application so I cannot confirm nor deny that this is the case.
Have you noticed a relationship between the AV excluding the ORACLE_HOME directory and performance?
For anyone\everyone following this thread, a colleague mentioned the following URL which contains useful references\comments by Jeff McAhren and Tim Tow:
We'll give the suggestions a shot and I will come back at a later stage to post our findings along with the configuration we have.
Thank you all for your posts.
Yes, a refresh that was taking over 45 seconds improved to less than a second immediately after the virus scanner was updated to exclude the ORACLE_HOME folder and subfolders.
That was a McAfee based system.
Hope this helps.