Virtual memory paging

[noufal_y]

Dear all,

I got a performance alert as " significant virtual memory paging was detected on host "
is this a big issue? how can i resolve this?
Please give me advices.

Thanks & regards,

[zargon]

Dear all,

I got a performance alert as " significant virtual memory paging was detected on host "
is this a big issue? how can i resolve this?
Please give me advices.

Thanks & regards,

It's very likely your SGA is very large and it may exceed the limits of the installed RAM (you can't have all of it allocated to your shared_pool because the O/S needs some memory to function and you do need memory for connected sessions). Resize your shared pool to a smaller value and see if that corrects the problem.

[noufal_y]

Dear Zargon,

I checked the memory,
Total SGA is 1200MB ,Maximum SGA 1200MB
Shared pool 128,Buffer cache 1024, Lpool 16,jpool 16 and other 16

System Pro(virtual memory)

initial 2048, maximum 6141

So can you tell me where i have to reset
Thanks verymuch for the support.

Regards

[zargon]

Dear Zargon,

I checked the memory,
Total SGA is 1200MB ,Maximum SGA 1200MB
Shared pool 128,Buffer cache 1024, Lpool 16,jpool 16 and other 16

System Pro(virtual memory)

initial 2048, maximum 6141

So can you tell me where i have to reset
Thanks verymuch for the support.

Regards

Virtual memory is swap, it's not the installed RAM. How much RAM is installed?

[noufal_y]

Hi ,

Its 4GB.
I need to clear this alert.
Please advice.

Regards,

[zargon]

Hi ,

Its 4GB.
I need to clear this alert.
Please advice.

Regards,

WHERE did you see this alert?? OEM/Grid Control? Was it in reference to a database instance or the operating system? You need to provide more inforomation on where this alert was reported and in what context.

[noufal_y]

Its in OEM.
I beleive this in OS config.
The exact alert is
" Significant virtual memory paging was detected on the host "
It listed in ADDM findings also.

[zargon]

Its in OEM.
I beleive this in OS config.
The exact alert is
" Significant virtual memory paging was detected on the host "
It listed in ADDM findings also.

You then need to work with the System Administrator to discover what is causing all of this paging/swap activity. It may be Oracle, it may be some other process. Simply because OEM reports this is not an indication that Oracle is at fault.

[halim]

Someone Says:

"Who lives with GUI, He died with GUI"


Regards
Halim

[zargon]

Someone Says:

"Who lives with GUI, He died with GUI"


Regards
Halim

Which means what, exactly? Who is this 'someone'? Of what relevance is your 'contribution' to the thread? What value does it provide?