Issue: High paging on AIX oracle DB server
Background/Observation:
i. AIX server with version 6.1 TL 7 (6100-07-06-1241)
running standalone Oracle DB 10.2.0.5
ii. Huge paging memory utilization found to be
caused by db processes mainly
#lsps -s
Total Paging Space Percent Used
30720MB 40%
#ps -ealf | head -1 ; ps -ealf | sort -rn +9 | head
F S UID
PID PPID C PRI NI ADDR SZ
WCHAN STIME TTY
TIME CMD
240001 A ora10g 3736258
1 0 60 20 f60b76590 152524 Jul 31 -
4:40 ora_dbw0_ORADB
240001 A ora10g 2883690
1 0 60 20 5c0bdc590 143288 Jul 31 -
4:29 ora_dbw1_ORADB
240001 A ora10g 1835488
1 0 60 20 ad0c2d590 125636 Jul 31 -
8:33 ora_lgwr_ORADB
240001 A ora10g 13041936 1
0 60 20 d95259590 118304 Jul 31 - 203:28 oracleORADB (LOCAL=NO)
240001 A ora10g 5046804 1 0 60 20 4321c3590 118292 Jul 31 - 176:28 oracleORADB (LOCAL=NO)
240001 A ora10g 9044626 1 5 62 20 1e5c9e590 118220 Jul 31
- 160:27 oracleORADB (LOCAL=NO)
240001 A ora10g 2228980 1 0 60 20 5513d5590 117520 Jul 31 - 176:38 oracleORADB (LOCAL=NO)
240001 A ora10g 11534512 1
0 60 20 5e7cde590 109812 Jul 31
- 185:14 oracleORADB (LOCAL=NO)
240001 A ora10g 6619604 1 0 60 20 6e0bee590 109796 Jul 31 -
2:12 ora_arc1_ORADB
240001 A ora10g 3801228 1 0 60 20 af0a2f590 109796 Jul 31
- 2:17 ora_arc0_ORADB