SUMMARY: ex. top in oracle environment

From: Markham, Richard <RMarkham_at_hafeleamericas.com>
Date: Thu Apr 18 2002 - 12:43:51 EDT
thanks considerably for all the responses, I wont list names, but you 
know who you are.  Again the list has proved priceless to shed light
on anything I've ever needed.

key document: the Solaris Memory System
http://www.sun.com/sun-on-net/performance/vmsizing.pdf
:
given below the top information says I had 2254M swap in use.
that's interpreted as the system is using 2gb of the 8gb of VM
on the machine (8VM = 4gb RAM + 4gb diskswap).

The `swap -l` output shows I have no diskswap in use.
swapfile             dev  swaplo blocks   free
/dev/vx/dsk/swapvol 159,8      16 8389632 8389632

another thing to consider is that sleeping processes will be
paged out until they are used again.  the document was really
good in that explained the different types of swapping 
(ie, hard/soft).

we've had a few complaints about the instance being slow so hence the
magnifying glass on memory usage.  the above doc talked about Direct I/O
(the Veritas equivalent, I believe is 'Quick I/O')
which explained some things that are definitely worth considering.  

Thanks again.



-----Original Message-----
From: Markham, Richard [mailto:RMarkham@hafeleamericas.com]
Sent: Wednesday, April 17, 2002 3:29 PM
To: Sunman (E-mail)
Subject: ex. top in oracle environment


Below I have put the top output of a system running an oracle database
with two instances.  At this time there was only a handful of users in
either of the instances total and most are relatively idle.  Noone at 
the time was doing any heavy transations or loads.  

My question is that with the above given is it normal to have over 
2gb of swap in use? Comments and suggestions for things to check would
be greatly appreciated.  Thank you.

********-----------------------------------------------------********
last pid:  6940;  load averages:  2.07,  2.74,  2.73

15:18:35
263 processes: 261 sleeping, 2 on cpu
CPU states: 39.1% idle, 51.3% user,  8.7% kernel,  0.9% iowait,  0.0% swap
Memory: 4096M real, 962M free, 2254M swap in use, 4939M swap free

   PID USERNAME THR PRI NICE  SIZE   RES STATE    TIME    CPU COMMAND
  3308 oradev     1  40    0  575M  556M sleep  243:09 13.65% oracle
  3433 oratest    1  22    0  647M  631M cpu/1  181:12 11.29% oracle
  3284 oradev     1   0    0  575M  555M sleep  139:53  5.12% oracle
  3391 oratest   11   0    0  648M  631M sleep   45:57  2.67% oracle
  6725 oradev     1   0    0  574M  553M sleep    1:04  1.23% oracle
  6921 oradev     1   0    0  574M  552M sleep    0:07  1.23% oracle
  6804 oradev     1   0    0  574M  553M sleep    0:36  1.19% oracle
  6867 oradev     1  10    0  574M  552M sleep    0:16  1.18% oracle
  6833 oradev     1   0    0  574M  553M sleep    0:27  0.99% oracle
  6495 oratest    1  59    0  647M  628M sleep    1:31  0.96% oracle
  6764 oratest    1   0    0  646M  627M sleep    0:28  0.93% oracle
  6605 oratest    1  59    0  646M  627M sleep    1:06  0.79% oracle
  3445 oratest    1   0    0  647M  629M sleep    4:37  0.77% oracle
  3483 oratest    1   0    0  647M  629M sleep    4:36  0.74% oracle
  6642 oratest    1  59    0  646M  627M sleep    0:56  0.63% oracle
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
Received on Thu Apr 18 13:05:48 2002

This archive was generated by hypermail 2.1.8 : Thu Mar 03 2016 - 06:42:40 EST