OBIEE Tuning

Adam Wickes

Hi all,

Another quick question, this time regarding tuning.
I have used a combination of Oracle's tuning white paper and this link: INSTALLATION DOCUMENTS BY RAVI: PERFORMANCE TUNING OBIEE 12C

Our machine has 64gb of memory so I have allocated as follows:

setStartupEnv.cmd

start up froup = "BISUITE-MAN-SVR"

@REM 64 bit JVM memory settings

set SERVER_MEM_ARGS_64=-Xms32768m -Xmx32768m

set SERVER_MEM_ARGS_64HotSpot=-Xms32768m -Xmx32768m

set SERVER_MEM_ARGS_64JRockit=-Xms32768m -Xmx32768m

Start up group = "AdminServerStartupGroup"

@REM 64 bit JVM memory settings

set SERVER_MEM_ARGS_64=-Xms8192m -Xmx8192m

set SERVER_MEM_ARGS_64HotSpot=-Xms8192m -Xmx8192m

set SERVER_MEM_ARGS_64JRockit=-Xms8192m -Xmx8192m

Start up group = ""

@REM 64 bit JVM memory settings

set SERVER_MEM_ARGS_64=-Xms8192m -Xmx8192m

set SERVER_MEM_ARGS_64HotSpot=-Xms8192m -Xmx8192m

set SERVER_MEM_ARGS_64JRockit=-Xms8192m -Xmx8192m

Node Manager Java Heap Size (CommBaseEnv.cmd)

:oracle_prod_mode

set JAVA_VM=-jrockit

set MEM_ARGS=-Xms8192m -Xmx8192m

set UTILS_MEM_ARGS=-Xms32m -Xmx1024m

goto continue

Note: We are also using Singleton Data Directory (Using SAN).

The issue is that i'm noticing that it is quite slow to navigate around the OBIEE folders.
When you save a data model for example, it will take a few seconds to display the save icon.

When you open a BIP schedule, it errors saying that it can't find the job meta data, yet after clicking ok and waiting another few seconds, the schedule populates correctly.

It feels like there is definitely a bottleneck somewhere but unsure how to dermine where it is.

If anyone has an opinion on the memory allocation above or might have an idea as to why our environment might be a bit laggy, it would be much appreciated.

Thanks in advance,
Adam

Ahmad Al-Baik

Dear;

I have similar to your problem, but don't find the solution yet, the login process take a long time. also getting permission of folder or items also take a long time to appear,

Best regards,

Adam Wickes

Do you have any long running variables or bad connections in your RPD? We had a connection pool with the wrong password that one of our session variables was using and that ran forever and ever and EVER before finally giving up and letting the user log in.

Adam Wickes

This is a friendly bump before I take it to Oracle support.
Thanks everyone.