Database Tuning (MOSC)

MOSC Banner

Database performance is slow after upgrade from 10g to 11g

edited Feb 27, 2013 8:55PM in Database Tuning (MOSC) 6 commentsAnswered
I upgraded the database into 11g, in the alert log I see the warning message
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [4.36%] pct of memory swapped out [0.31%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly.

Can anyone provide the suggestion on this?  Thanks

SQL> show parameter sga

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
lock_sga                             boolean                          TRUE
pre_page_sga                         boolean                          FALSE
sga_max_size                         big integer                      40576M
sga_target                           big integer                      0
SQL> show parameter pga

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
pga_aggregate_target                 big integer                      20G

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center