The Oracle shared pool provides critical services for sharing of complex objects among large numbers of users. Prior to 10g R1, DBAs often spent much time learning about the shared pool memory management to configure and tune shared pool usage; with the tight time constraints and ever-changing workloads, many found this task daunting. The Automatic Shared Memory Management (ASMM) features introduced in 10gR1 solved this problem by providing the DBA a simple, automatic self-tuning mechanism for configuring shared memory components of the SGA, including the buffer cache and shared pool. The Automatic Database Diagnostic Monitor (also introduced in 10gR1) further simplified shared pool related tuning efforts by providing automatic diagnosis and recommendations for application specific issues.
More information : http://download.oracle.com/oowsf2005/003wp.pdf
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