Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE Admin tool performance

Hi,

OBIEE 12.2.1.3

The Admin tool is installed on Windows Server 2012R2 machine. The machine is having 18 GH of memory.

But still when I work with RPD, its dead slow!, I can experince slowness even to go up and down in the BMM and other layers!

The infra team says server is not even reaching 30% of utilization, not sure what is going on can somone help me with how can I improve the performance of Admin tool.

Regards

Hesh

Find more posts tagged with

Accepted answers

All comments

Hesh

Can someone please help me with this... even any reference read I can do.

Regards

Hesh

Gianni Ceresa

What kind of work is it: online or offline?

How big is your RPD?

Does it behave differently when using the admin tool somewhere else than on that environment?

I don't remember having ever seen a document about "admin tool" performance.

[Deleted User]

Adding to Gianni: why are you still on 12.2.1.3? There were 3 major releases since then and countless bundle patches.

Hesh

Thank you Gianni,Christian ..

The RPD size is 1 MB and we are working offline.

We will try the RPD in some other environment, we need to sort out permissions for that.

The version is not upgrated for sometime now! any potential issues with the current one i.e. 12.2.1.3 ?

Any specific memory settings we need to have for the Admin tool?

like I was reading somewhere about Java heap size, not sure if that is related but anything similar we can consider to have to review?

Regards

Hesh

Gianni Ceresa

To what numbers of objects does the 1Mb translate? (subject areas, business models, .... some generic numbers to have an idea about what's inside that RPD).

The Admin tool isn't Java (and that's why it works only on Windows), so java settings aren't going to do much.

Hesh

Thanks Gianni,

Following is the number of objects in BMM layer currently ...

I was also requesting IT to install Admin tool in some other server , but they are raising issues as there could be some licencing required . Not sure if we need any licencing for Admin tool .

i) DWarehouse -- 89 Dim and 30 Fact

iI) XYZ Model -- 30 Dim and 6 Fact

iiI) DQ Model -- 1 Dim and 1 Fact

iv) ETL Stats -- 3 Dim and 1 Fact

v) Usage Tracking -- 4 Dim and 1 Fact

Dimensional Hierarchies list as same as no. of dim tables

Regards

Hesh

Gianni Ceresa

Based on your numbers, your RPD isn't huge but already a good size with 120 elements in a logical model.

More than on another server I would try on a client: the admin tool is developed to be used on a laptop or desktop PC, it is a client.

There is no licensing, you can install 200 admin tools, you are paying for the server licenses.

Hesh

Thanks Gianni,

We have tested this RPD in local environment now and the performance looks very good.

Now its clear that the issue is not with the RPD, something should be wrong with that Remote server, I believe as this is a GUI toolthe screen movement over a remote environment slowign down this, can't say anything!

Regards

Hesh

Hi Gianni,

While going through the Certification Matrix of the Admin tool 12.2.1.3 is compatable with Windows 7, 8.1, & 10 only.

But our machine where the tool is installed is of Windows server 2012 R2, do we have anything available to support this version of Windows?

Regards

Hesh

Gianni Ceresa

As far as I know no, because the concept of the Admin tool is to be a client tool, not a server tool. Therefore the certification is for clients OS (and not server OS).