Why there are lots of page-in and almost no page-out?

Hi,
 
We are running Oracle 9.2.0.4.0 on Solaris 9 and please see the output from 
"vmstat".
Do you think we have a paging problem? We are using plain UFS and I do not think
direct/IO is turn on.
 
 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  si  so pi po fr de sr m0 m1 m2 m3   in   sy   cs us sy id
 0 4 0 39801136 3904288 0 0 16143 0 0 0  0  0  0  0  0 3695 265656 10852 29 17 
54
 0 4 0 39801896 3855120 0 0 15839 0 0 0  0  0  0  0  0 3682 272089 11466 30 18 
52
 1 5 0 39801968 3797184 0 0 16324 0 0 0  0  3  0  0  0 4581 264212 12353 34 20 
46
 0 4 0 39800944 3731264 0 0 16621 0 0 0  0  0  0  0  0 3543 260497 7478 32 15 53
 0 6 0 39790192 3683472 0 0 17886 23 22 0 0 9  0  0  0 4156 263808 8699 36 17 47
 1 4 0 39849448 3703192 0 0 19163 120 118 0 0 12 0 0 0 3946 266400 8450 26 20 54
 0 4 0 39856712 3687056 0 0 29968 0 0 0  0  0  0  0  0 3581 259144 6849 18 16 66
 0 4 0 39829712 3660880 0 0 28806 0 0 0  0  0  0  0  0 4012 263250 7811 19 17 64
 0 3 0 39834344 3656008 0 0 26243 0 0 0  0  4  0  0  0 3329 259558 5811 12 16 72
 0 4 0 39842832 3647712 0 0 28400 2 2 0  0  2  0  0  0 3304 258537 6332 10 16 75
 0 3 0 39842120 3656584 0 0 35551 1 1 0  0  0  0  0  0 3286 258547 5548 17 17 67
 0 2 0 39840288 3719912 0 0 34262 2 2 0  0  6  0  0  0 2970 259133 5698 13 19 68
 0 4 0 39844992 3768392 0 0 18624 0 0 0  0  0  0  0  0 3054 258509 6063 15 15 70
 0 3 0 39840976 3814888 0 0 31934 0 0 0  0  0  0  0  0 3248 257820 6280 20 19 62
 0 3 0 39840224 3907664 0 0 31176 0 0 0  0  3  0  0  0 3176 259234 5640 17 20 63
 0 4 0 39847584 3998720 0 0 34630 0 0 0  0  0  0  0  0 3488 260525 6840 20 19 61
 0 3 0 39858424 4032768 0 0 19069 0 0 0  0  0  0  0  0 3098 260524 6446 15 15 69
 0 4 0 39858336 3993040 0 0 7692 0 0  0  0  3  0  0  0 3108 260011 6712 12 15 73
 0 4 0 39858600 3942776 0 0 9740 0 0  0  0  0  0  0  0 3171 259880 6937 12 13 75
 
     memory           page          executable      anonymous      filesystem
   swap  free  re  mf  fr  de  sr  epi  epo  epf  api  apo  apf  fpi  fpo  fpf
 39804056 4130480 2748 1520 0 0 0    0    0    0    0    0    0 28605   0    0
 39804016 4127472 2252 1347 0 0 0    0    0    0    0    0    0 23829   0    0
 39804056 4124496 2245 1669 0 0 0    0    0    0    0    0    0 23592   0    0
 39803984 4124216 2117 1715 2 0 0    0    0    0    0    0    0 28010   2    2
 39781936 4119888 2162 3941 260 0 0 214   0    0    0    0    0 28899 265  260
 39779352 4120344 1758 1503 0 0 0    0    0    0    0    0    0 25800   0    0
 39776664 4115952 1940 2918 40 0 0  13    0    0    0    0    0 25665  42   40
 39767152 4111776 1940 1443 0 0 0    0    0    0    0    0    0 31032   0    0
 39779344 4108168 1809 1585 2 0 0    0    0    0    0    0    0 27424   2    2
 39779344 4101272 1682 1523 0 0 0    0    0    0    0    0    0 29180   0    0
 39779344 4092368 1860 1614 0 0 0    0    0    0    0    0    0 30319   0    0
 39779312 4085720 2018 1523 0 0 0    0    0    0    0    0    0 34400   0    0
 39779336 4079408 2195 1437 0 0 0    0    0    0    0    0    0 41669   0    0
 39779400 4075680 2488 1392 0 0 0    0    0    0    0    0    0 45167   0    0
 39779408 4071824 1689 1702 0 0 0    2    0    0    0    0    0 25451   0    0
 39779400 4068040 1705 1637 2 0 0    0    0    0    0    0    0 25214   2    2
 39779376 4065136 1916 1522 0 0 0    0    0    0    0    0    0 29627   0    0
 39779288 4062560 2198 1481 0 0 0    0    0    0    0    0    0 32415   0    0
 39779072 4060016 2148 1528 0 0 0    2    0    0    0    0    0 32013   0    0
 
Thanks,
Roger Xu 
Database Administrator 
Dr Pepper Bottling Company of Texas 
(972)721-8337 

 

This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. Any 
review, dissemination, copying, printing or other use of this e-mail by persons 
or entities other than the addressee is prohibited. If you have received this 
e-mail in error, please contact the sender immediately and delete the material. 
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security 
System. Any questions please call 972-721-8257 or email your request to 
tech_support@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: