apps-infra

    Forum Stats

  • 3,874,037 Users
  • 2,266,666 Discussions
  • 7,911,700 Comments

Discussions

OBIEE Tuning

Adam Wickes
Adam Wickes Member Posts: 249 Blue Ribbon

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

Answers

apps-infra