Questions about automatic memory allocations in 10g (r1 and r2)
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2005 10:14:39 -0600
Guys,
I was in a meeting yesterday with a vendor who told me (and my manager)
their product running on 10gr1 does not need any DBA intervention when
used because they are using automatic memory management and they use
"all of physical memory ... for the SGA".
Now, this person is no Oracle DBA/expert/guru. He has attended a class
like "New features in 10g" or something like that. When I questioned
this "use all of physical memory" strategy and how that might affect PGA
usage, he was stumped.
Well, this meeting got me to thinking about if this really works or not,
so I went and read up on this new feature on http://tahiti.oracle.com.
My concerns about this center around questions like:
1. Does this really work?
2. How often is the memory usage looked at and adjusted?
3. When an adjustment (shrink) occurs in the shared_pool, are the
cached SQL invalidated?
4. When the buffer_cache shrinks, are the buffers marked as dirty?
Does anyone know about these issues? Can you point me to somewhere
where I might get answers to these questions or set up my own test case
to show how this "feature" might work?
Thanks for any time and effort put into this.
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
Other related posts:
