Database Memory & 4030/4031 (MOSC)

MOSC Banner

100% Memory Utilisation on AIX 5.3 DB Server

edited Oct 25, 2009 11:40AM in Database Memory & 4030/4031 (MOSC) 1 commentAnswered
 Hi

I am facing issue with Memory utilisation on DB Server Aix 5.3, I am having around 96 GB of Memory on the Server out of which I have allocated 20 GB to SGA and 8 GB of PGA. The only software installed on this server is oracle 10.2.0.2 with a single database. Whenever I check the memory utilisation on the server it is allways around 100%. There is no paging activity on the server. I have checked that using vmsat.

When I have queried v$process with PGA_ALLOC_MEM total allocation is just 10 GB.

Suggest how to diagnose this issue? Is there any way to realease unused memory.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center