Hi Guys
DB Version : 11.2.0.3
OS : AIX 6.1
I Have the following issue after upgrading to 11.2.0.3 , the alert log appear "warning heavy swapping observed on system in last 5 mins"
i follow MOS document : WARNING: Heavy Swapping Observed On System In Last 5 Mins.After upgrade to 11.2.0.3 [ID 1452790.1] and apply PSU patch 13923374 with nothing .
Database performance so slow , increase sga , pga with nothing , sharing_cursor set to force
SQL> select name, value/1024/1024 "MB" from v$pgastat where name like '%PGA%';
NAME MB
---------------------------------------------------------------- ----------
aggregate PGA target parameter 1168
aggregate PGA auto target 950.677734
total PGA inuse 117.860352
total PGA allocated 206.938477
maximum PGA allocated 534.009766
total freeable PGA memory 74.1875
PGA memory freed back to OS 13868.8125
total PGA used for auto workareas 6.14453125
maximum PGA used for auto workareas 58.5351563
total PGA used for manual workareas 0
maximum PGA used for manual workareas .263671875
vmstat
System configuration: lcpu=16 mem=12287MB
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
2 2 2471959 10054 0 0 0 3473 6548 0 632 10792 3275 9 2 88 1
SQL> show parameter cache;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_advice string ON
db_cache_size big integer 0
db_flash_cache_file string
db_flash_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_keep_cache_size big integer 0
db_recycle_cache_size big integer 0
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
result_cache_max_result integer 5
result_cache_max_size big integer 30M
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
session_cached_cursors integer 600
SQL> show parameter db_writer;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_writer_processes integer 2
SQL> show parameter buffer;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
db_block_buffers integer 0
log_buffer integer 31457280
use_indirect_data_buffers boolean FALSE
SQL> spool off ;
alert log contain this error only .topas is 87% for oracle process
Just as note : servers are new with 16G RAM,All network connection fiber optics
after applying the patch , the my test taking 20min at max , now more than 1 hour
BR
osama