This discussion is archived
11 Replies Latest reply: Feb 12, 2013 4:50 AM by JohnWatson RSS

SGA Tunning for Datawarehouse

ashish 1901 Newbie
Currently Being Moderated
Hi frens
We are having datawarehouse of size 200gb.and our server configuration are 24GB RAM and 1TB disk space..Now my question is i've set
memory_target=14000m
sga_max_size=14000m
sga_target=13000m

will it impact the database perormance in negetive way???plz suggest

Regards
Ashish

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points