Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system?
A. 20%SGA, 80%PGA
B. 25%SGA, 75%PGA
C. 50%SGA, 50%PGA
D. 75%SGA, 25%PGA
E. 80%SGA, 20%PGA
答案:(E)
解析:
对系统来说,一般把80%的内存给oracle,包括SGA+PGA,其中SGA分配80%,PGA分配20%
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1310379/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1310379/