topic swap in Operating System - HP-UX

swap

YOGI_3 — Mon, 15 Aug 2005 04:35:43 GMT

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

Re: swap

Pedro Cirne — Mon, 15 Aug 2005 04:53:31 GMT

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

Re: swap

Simon Hargrave — Mon, 15 Aug 2005 04:58:12 GMT

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.

Re: swap

Yogeeraj_1 — Mon, 15 Aug 2005 05:14:01 GMT

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

Re: swap

Sameer_Nirmal — Mon, 15 Aug 2005 20:00:18 GMT

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.

Re: swap

FERRARI MARCO — Tue, 16 Aug 2005 04:41:44 GMT

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