It used to be a challenge to size the various memory pools that comprise the Oracle System Global Area (SGA) for optimal performance. But that was before Oracle Database 10g. First introduced in Oracle Database 10g and further enhanced in Oracle Database 10g Release 2, Automatic Shared Memory Management (ASMM) automatically sizes many of the memory pools while the database is running, allocating and de-allocating memory as needed. As the workload composition changes, Oracle Database 10g enlarges the appropriate pools and reduces the sizes of other automatically sized pools accordingly. In short, ASMM can save a lot of trouble - and improve overall performance as well.
More information : http://www.oracle.com/technology/oramag/oracle/05-sep/o55tuning.html
Blast from the Past: I Don't Like Your Examples!
-
Originally written in 2000, I thought you might like to check this out in
2016.
I Don't Like Your Examples! 10/11/2000
I have been writing books about t...
8 years ago
0 comments:
Post a Comment