Hi,
in my old database 9.2 (on AIX) i see high paging space usage for background processes.
#> svmon -Pg -t 1 |grep Pid ; svmon -Pg -t 10 |grep "N"
Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd 16MB
2285578 oracle 304609 81552 500909 605395 Y N N
3350676 oracle 304588 81552 500643 605149 Y N N
1794254 oracle 304592 81552 500634 605126 Y N N
2744508 oracle 304567 81552 500189 604671 Y N N
2588796 oracle 304700 81552 499905 604421 Y N N
708788 oracle 304657 81552 499842 604336 Y N N
598034 oracle 304621 81552 499696 604182 Y N N
3035252 oracle 304666 81552 499662 604167 Y N N
2736282 oracle 239031 81552 418381 522499 Y N N
1220740 oracle 238960 81552 418310 522410 Y N N
#> ps -eaf|grep 2285578
ora9R2 2285578 1 0 Mar 01 - 0:28 ora_pmon_MYDB
#> ps -eaf|grep 3350676
ora9R2 3350676 1 0 Mar 01 - 0:34 ora_dbw0_MYDB
#> ps -eaf|grep 1794254
ora9R2 1794254 1 0 Mar 01 - 1:24 ora_ckpt_EGOV
The database do nothing (from 9 am to 5 pm):
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 852.37 37,511.73
Logical reads: 31.39 1,381.25
Block changes: 3.35 147.35
Physical reads: 0.09 3.96
Physical writes: 0.16 6.89
User calls: 2.24 98.51
Parses: 1.33 58.34
Hard parses: 0.10 4.27
Sorts: 0.63 27.93
Logons: 0.01 0.61
Executes: 2.07 91.04
Transactions: 0.02
But latch free is at 40%:
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
latch free 1,580 88 42.63
Filesystem mount options are correct (cio for dbf, etc)
Parameter:
filesystemio_options string async
disk_asynch_io boolean TRUE
optimizer_mode string RULE
Any ideas why it uses so many paging space?
Thank you.