I assume you are talking about the performance of a server? if so then yes it can.
What version of Hyperion (Including patch level)(e.g HP 220.127.116.11.007,Calc Manager 18.104.22.168.010) or are you cloud PBCS?
Is this a new environment?
Was it always this way or did it just start occurring?
What changed prior to the issue?
What feedback did Oracle provide after you opened your Oracle SR?
Are all users experiencing the issue or just those in a certain area(e.g Latin America)
Have you had your IT team restart the enviroment?
Is the issue on both your PROD and Test environments?
What all have you done to troubleshoot so far?
The performance of the server is OK. I am talking about the performance of Planning. It seems to be a problem in the "connection" between Planning and Essbase, so when I try to launch something fromPlanning that implies a query in the Essbase database, it lasts a lot (we are talking that now a simple query in Smart View can last up to 30-40 seconds and before it lasted 1 second).
We simply applied an increment of the RAM memory from 16GB TO 32GB to the Planning/EPMA/CalcMgr/Foundation server, but in principle it has not implied a change in the Hyperion configuration. They told me that they had some problems and that they had to recover a backup of the Unit C of the server (but Hyperion is installed in another Unit, i.e. D). We also increased some Heaps Size of the Planning and Essbase services in order to take advantage of the increment fo the RAM memory of the Planning Server.
The versions ar the following:
Calculation Manager - 22.214.171.124.010.005
Oracle Hyperion Planning, Fusion Edition - 126.96.36.199.007.05
Oracle Hyperion Provider Services - 188.8.131.52.020.012
Oracle Hyperion Enterprise Performance Management Architect, Fusion Edition - 184.108.40.206.000.2614
Oracle Essbase Administration Services 220.127.116.11.020.7
The issue is experimented by all the users. The IT team has restarted the server a lot of times and always the same. The issue just happens in the Production environment, which is the one that we have change the RAM memory, but the Test environment works as always.
Any suggestion? The IT team doesn't understand why a simple increment in RAM memory can imply a reduce in performance.
An increase in memory should not cause the performance issues you are seeing, though I think there is more to it with the following statement
They told me that they had some problems and that they had to recover a backup of the Unit C of the server (but Hyperion is installed in another Unit, i.e. D).
You need to ascertain whether the server is operating as it should be, I don't know what has been done to the server but it doesn't sound as smooth as a simple memory upgrade.
It could even be that the servers are virtual and changes were made to resource allocation, without investigating in more detail it is not easy to say what has happened.
I think you need to spend some time getting into the detail or get somebody in to perform a health check on the system.
As all of you told me, the upgrade RAM memory was not as smooth as it sounded.
There was a problem with the configuration of the DNS suffix that made to work slowly the connection between the servers (ie. Planning and Essbase).
Solved! Thank you for your help and your time.