Visit Our UNIX and Linux User Community

Operating Systems AIX Eliminating paging space and interpreting memory utilization Post 302338774 by depam on Tuesday 28th of July 2009 10:35:09 PM
Old 07-28-2009
Eliminating paging space and interpreting memory utilization

I just want to inquire on one of our DB Servers. Currently, we are running on 26GB of memory and 6 CPUs. Though our memory is 70-80 utilized, I can see some paging of around 8-10%. Is there any effective way we can lessen/eliminate paging?
Here is our current VMO Settings:

vmo:
minperm% = "3"

maxperm% = "90"

maxclient% = "90"

lru_file_repage = "0"

maxfree = "8512"

minfree = "8000"


no:

clean_partial_conns = "1"

udp_pmtu_discover = "0"

tcp_pmtu_discover = "0"


Our Memory Utilization:
[root@server1] /home/pri-sys > svmon -G
size inuse free pin virtual

memory 6815744 6712498 103246 1468182 5381921

pg space 4456448 273680


work pers clnt other

pin 1226118 2737 0 239327

in use 5243470 33639 1435389


PageSize PoolSize inuse pgsp pin virtual

s 4 KB - 6518002 273680 1329910 5187425

m 64 KB - 12156 0 8642 12156

[root@server1] /home/pri-sys >

If my computation serves me right, we still have 403MB but how come the topas is reporting that the memory utilization is around 70-83% 80% of 26 GB is 20.8 GB so we should still have 5 GB available. Which is accurate the svmon or the topas?
I have tried to issue the command "svmon -U oraprod -d" to check the utilization of the oracle user ID alone and this is what I get:
==============================================================================
User Inuse Pin Pgsp Virtual

oraprod 4836933 84616 34726 3540729


PageSize Inuse Pin Pgsp Virtual

s 4 KB 4715589 72 34726 3419385

m 64 KB 3488 1188 0 3488


-------------------------------------------------------------------------------

Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd 16MB

742352 oracle 3900150 65584 16119 2596036 Y N N

840094 ksh 21217 2883 0 21154 N N N

357166 oracle 11158 48 2 11160 Y N N

811984 oracle 8946 48 10 8955 Y N N

1585678 oracle 8834 48 58 8893 Y N N

463940 oracle 8785 48 35 8794 Y N N

906186 tnslsnr 8599 51 394 3367 Y Y N

1577536 oracle 8565 48 0 8565 Y N N

50428 oracle 8550 48 0 8550 Y N N

566216 oracle 8342 48 543 8882 Y N N

455406 oracle 8064 48 3 8065 Y N N

672594 oracle 7022 48 0 7022 Y N N

533050 sqlplus 6844 48 0 1022 Y N N

442848 oracle 6290 48 0 6290 Y N N

705284 oracle 6257 48 37 6289 Y N N



Is it clear to say that oracle ID itself is utilizing 18.8 GB of memory and 15.2 of it is being used by process ID 742352?

The problem is that whenever we use paging a lot the hdisk0 and hdisk1 gets busy and that no process it becomes really slow to the point that no work is being done. My understanding is that when we get to lower the memory utlization then it will eliminate the paging as well. I am not sure on this but hope you can shed some light into this.

Thanks.
 
Test Your Knowledge in Computers #871
Difficulty: Medium
Hello World in Lisp is coded as: [ print "Hello world" ]
True or False?

10 More Discussions You Might Find Interesting

1. AIX

swap space / paging space

how do you get the paging space reduced without rebooting the machine ? the os is aix (2 Replies)
Discussion started by: aaronh
2 Replies

2. AIX

Paging space

Hello everyone I have 4g of paging space in my rootvg disk Im going to reduce them to 1gb in my rootvg disk and add 3gb of paging space on my san disk. My rootvg disk is mirror. My question is I can do this on line ? and I can do with the mirror ? or I need to unmirror first my... (2 Replies)
Discussion started by: lo-lp-kl
2 Replies

3. AIX

paging space

Hello everyone I have a doubt about how many paging space can have in the same disk. lsps -a Page Space Physical Volume Volume Group Size %Used Active Auto Type paging00 hdisk0 rootvg 3072MB 1 yes yes lv hd6 hdisk0 ... (4 Replies)
Discussion started by: lo-lp-kl
4 Replies

4. AIX

LV without Paging Space

Hello dear friends, We have VG filevg which consists of 2 PVs when I rechecked the VG there is no Pagingspace LV.. The VG is usually Highly loaded because much reads and writes.. Is this a must to create Paging space on the specified LV? (2 Replies)
Discussion started by: Vit0_Corleone
2 Replies

5. AIX

Paging space

Hi, I have paging size 2048M showed from topas and 10240M showed from "lsps -a", can anyone tell what is the difference? and how to change the PAGING SIZE (showed in topas) to 8192M? Can you please tell in detail step? Thanks! Victor #topas Topas Monitor for host: egsprc01dev ... (10 Replies)
Discussion started by: victorcheung
10 Replies

6. Shell Programming and Scripting

awk: Eliminating white space while setting variable

Hi, I have a large flat file from host without delimiter. I'm transforming this file to a csv file using statements like # Row 03: Customer / field position 3059 +20 WOFABNAM=substr( $0, 3059, 20 ); and deleting the trailing whitespaces before and after with that sub( /^ +/, "",... (4 Replies)
Discussion started by: Celald
4 Replies

7. Shell Programming and Scripting

Eliminating space constraint in grep

here in the below code just a space between 'Info' and '(' is showing that the patter doesnt match... echo "CREATE TABLE Info (" | grep -i "CREATE TABLE Info (" | wc | awk -F' ' '{print $1}' 1 echo "CREATE TABLE Info (" | grep -i "CREATE TABLE Info (" | wc | awk -F' ' '{print $1}' 0 ... (9 Replies)
Discussion started by: vivek d r
9 Replies

8. Solaris

[DOUBT] Memory high in idle process on Solaris 10 (Memory Utilization > 90%)

Hi Experts, Our servers running Solaris 10 with SAP Application. The memory utilization always >90%, but the process on SAP is too less even nothing. Why memory utilization on solaris always looks high? I have statement about memory on solaris, is this true: Memory in solaris is used for... (4 Replies)
Discussion started by: edydsuranta
4 Replies

9. AIX

No Paging Space Available

Whilst perfoming some tests on lvm's I managed to crash our test box. No real problem as it is only used by our tech team. however I would like to know why this was actually caused as the task being performed at the time was one which I though would not have any impact. Using dd I was... (5 Replies)
Discussion started by: tugger
5 Replies

10. Red Hat

CPU Utilization and Memory Utilization of Services and Applications

Hi, i am new to linux/RHEL 6.0 and i have two questions. 1) How to get the CPU utilization and Memory Utilization of all Services running currently? 2) How to get the CPU utilization and Memory Utilization of all Applications running currently? Please help me to find the script. ... (2 Replies)
Discussion started by: nossam
2 Replies

Featured Tech Videos

All times are GMT -4. The time now is 03:53 AM.
Unix & Linux Forums Content Copyright 1993-2020. All Rights Reserved.
Privacy Policy