NQsserver memory not releasing — Oracle Analytics

Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

NQsserver memory not releasing

Received Response
142
Views
4
Comments
920799
920799 Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

Hi All,

We have noticed Bi Server (NQsServer) memory taken 36 GB. (Total 64 GB RAM)

Most of the times noticed NQsserver not releasing the memory used on production windows server. Please let us know what could be the reason.

I see no long running queries, stuck threads. all the services are up and running fine and application report/dashboard navigation response also not slow.

We are worried that NQServer or Saw server may crash if the same continues.  or we may not be able to access the windows server itself.

Regards

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    It would help if you specified the problem more in detail with precise indications of versions, host OS etc etc. You're providing nothing.

  • 920799
    920799 Rank 4 - Community Specialist

    Thank you for the reply,

    Now we don't see any issue with application (working/responding as like normal day), no Stuck threads no long running queries in Manage sessions.

    Only thing we see is NQServer  currently consuming 36 GB. (Windows  2008 server have Total 64 GB RAM). in task manager i see 88% physical memory used for all the system resources.

    we have noticed this before as well that the NQserver memory usage increases day by day, never releases the memory (not sure if this is how it works).

    Currently in our prod server as per task manager we see 88% of Physical memory is used. I dont see this reduced in last 12 hours. But sure this will increase in some time.

    I am worried that if memory usage raises like this it may Crash the application due to no memory availability.

    So trying to find the reason what might be causing memory increase. What do i need to check to know the root cause.

    Thanks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Have you even read what I posted?

  • 920799
    920799 Rank 4 - Community Specialist

    My bad

    Versions: OBIEE 11.1.1.7.140715

    Host OS: Windows 2008 server

    Single node not clustered,

    we do restart our OBIEE services twice a month so we never faced this issue before.

    Thanks & Regards,