(518)The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application.
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/