Eliminating paging space and interpreting memory utilization

Thread Tools Search this Thread
Operating Systems AIX Eliminating paging space and interpreting memory utilization
# 1  
Old 07-29-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:

minperm% = "3"

maxperm% = "90"

maxclient% = "90"

lru_file_repage = "0"

maxfree = "8512"

minfree = "8000"


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.

# 2  
Old 07-29-2009

can you please paste output of vmstat -I 10 10?

And yes - the closer your free list goes against 0, the slower your system will be.

A healthy value for a database box is to keep your avm value between 66 and 80% - that always gives your oracle processes themselves enough memory.

If you have a busy database box with lots of connections you can easily have a requirement for 50%-100% more memory than you assigned to the SGAs themselves.

Are you running cio, rac or oracle with rawdevices or is this a plain oracle install.

Please paste the output of vmstat -v as well.

Talk to your DBAs - what are your top sql queries doing - usually you have either a bad execution plan and/or a lot of full table scans if you're having performance issues ...

In addition - try to set your minfree and maxfree value to much lower values and see if it reduces your paging - in my environments I had to set it back to 960/1088 because with higher values the amount of paging was extreme.

By the looks of your outputs you have a db only box - do you run any other applications and what kind of DB do you have - OLTP (many writed, not much reads) or rather reporting (large reads, not much writes).

Thanks and regards
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question