oracle login slow

[Akif_1]

Any valuable input will be appreciated .....

[Dennis Handly]

>But below output shows system swapping 65% where as real time memory RAM only 12%,

This isn't what that means.

TYPE AVAIL USED FREE USED
dev 4096 734 3362 18%
dev 4092 738 3354 18%
dev 4092 738 3354 18%
localfs 800 0 800 0%
reserve - 9625 -9625
memory 6301 762 5539 12%
total 19381 12597 6784 65%

What this says is:
65% of your total swap has been reserved.
Only 12% of pseudo swap is being used.

So this means that you may have asked for 12.6 Gb of VM. You may have only touched a very small part of it.

So you have reserved 12.6 Gb of VM but you haven't started actively swapping the whole 12.6 Gb. From vmstat(1m) po field.

You have reserved 9.6 Gb and only used 2.1 Gb of your device swap.

[Akif_1]

Thanks Dennis for your feedbackup ,

How can i use this memory completely for smooth production.

I mean which area need to be workout to over come with this issue.

Thanks & Regard's

[Akif_1]

Hello Dennis,


Is this bcz i change dbc_max_pct=20 from dbc_max_pct=50 where as on the other node like database dbc_max_pct=35 from dbc_max_pct50.

And the DB memory consumption is 77% swapping 44%.

Do i need to make the application dbc_max_pct=35 , so it use the memory as DB.

Regard's

[Dennis Handly]

>Is this because I change dbc_max_pct=20 from 50 where as on the other node like database dbc_max_pct=35 from 50.

>Do I need to make the application dbc_max_pct=35, so it use the memory as DB.

I assume you don't have Oracle on this machine?
Yes, you could try increasing it.

[Arockiasamy K]

Dear Akif,

Please check the resolv.conf, wheather the DNS server is reachable or not.

That maybe a problem.

Regards,
Arockiasamy K