swap

[YOGI_3]

Hi all..
I am facing one problem replated to Database.
When i m connecting to database it takes 15-20 mins...

when iam checking for swap mem its showing following information...
In the last line its showing PCT USED 84%..
is this the issue of PCT USED 84%?


# swapinfo -a
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4194304 67752 4126552 2% 0 - 1 /dev/vg00/lvol2
dev 18432000 67728 18364272 0% 0 - 1 /dev/vg00/lvol9
reserve - 2851828 -2851828
memory 9697952 8103656 1594296 84%
-----------------
waiting for ur replies

[Pedro Cirne · Accepted solution]

Hi,

I don't think you have a problem with SWAP.
You just have to be concerned with SWAP if page out or page deactivation occurs.

Check "top", what is the cpu load? Do you have a process called "vhand" running?

Check "sar -w 5 0" do you have any swap/out?

Enjoy :)

Pedro

[Simon Hargrave]

If you look at your dev swap usage (the top 2 lines) then there's hardly any used, so it doesn't look like you've got memory issues.

To be sure, run "vmstat 5 5" and check the "po" column. If this is zero then there's no active paging out activity.

You do appear to have a lot of swap configured though, (22Gb in a system with ~16Gb RAM)

Also I recommend you use swapinfo -tam for a more useful output.

[Yogeeraj_1]

hi yogi,

since when are you having this problem?
any new installation, system level changes, changes at the Oracle Database level?

might be high time for a tuning at the database level also...

regards
yogeeraj

[Sameer_Nirmal]

With the swapinfo output, its clear that
system is swapping as the swap space used.
You can get more clear picture about swapping
through vmstat and sar -w.

Well there are more aspects need to be considered to know the cause of slow connection to Oracle, current system resources utilization ,network response etc.
Hows the response while running sql queries ?

Do you know the Size of SGA ? If not , run top command and see the SIZE column for a oracle process whcih would be somewhat similar to almost all oracle processes.

How much system real memory you have?
It may be possible that Oracle SGA is being swapped which would definatly make Oracle slow whatsover it is doing.

[FERRARI MARCO]

Is it fast if you ssh/telnet into the system ?
DNS problems ?
Marco