Database Administration (MOSC)

MOSC Banner

Does increasing SGA improve performance of database?

Does increasing SGA improve performance of database?


Example: 

oracle version-> 12.1.0.2

OS RAM -> 32GB

SGA->

NAME                        TYPE    VALUE                                                 

-------------------------------------------------- ----------- --------------------------------------

lock_sga                      boolean   FALSE                                                 

pre_page_sga                    boolean   TRUE                                                 

sga_max_size                    big integer 4896M                                                 

sga_target                     big integer 4896M                                                 

unified_audit_sga_queue_size            integer   1048576                                                



Used SGA   -> 4783.81 MB

Please suggest if SGA should be increased?

Thanks

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