Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle is consuming a lot of swap space

511831Apr 6 2009 — edited Apr 8 2009

We are running oracle 10.2.0.2 on Sun Solaris 5.10
We have change our:
SGA from 32 GB to SGA_TARGET=54 GB and SGA_MAX_SIZE=64G
PGA=32 G from 16G

After this change, swap usage has doubled and reached to 80G and its not coming down.

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 64G
pga_aggregate_target big integer 32G

Does someone have any idea what's causing swap to increase and how will it comes back to normal ?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2009

Added on Apr 6 2009

#general-database-discussions

11 comments

1,003 views