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