Hi Mladen,
Thanks for sharing the nice links.
Went through the link
http://nocoug.org/download/2004-11/Optimising_Oracle9i_Instance_Memory3.pdf
Have a query....
It is mentioned that for dedicated server connections the PGA holds the
cursor information that persists across multiple executions of the same
statement such as, *bind details, data type conversion*, etc. The persistent
area is de-allocated when the cursor is closed.
Before going through the doc. I knew that the cursor & other binding info.
was stored in Library Cache area of the SGA. Can anyone please elaborate on
this.....
Regards,
Deepak
On 10/20/05, Gogala, Mladen <MGogala_at_allegientsystems.com> wrote:
>
> Tahiti is not the way to go for this one. I'd recommend
> http://integrid.info/memory_latching.pdf
>
> or the classic article http://www.vldb.org/conf/2002/S29P03.pdf . Ramesh
> Ramaswamy of Quest
>
> software also wrote a good article which can be found at:
>
>
> http://nocoug.org/download/2004-11/Optimising_Oracle9i_Instance_Memory3.pdf
>
> --
>
> Mladen Gogala
>
> Ext. 121
> ------------------------------
>
> *From:* Reidy, Ron [mailto:Ron.Reidy_at_arraybiopharma.com]
> *Sent:* Thursday, October 20, 2005 12:15 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Questions about automatic memory allocations in 10g (r1 and r2)
>
> 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.
>
>
--
Regards,
Deepak
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 21 2005 - 02:48:03 CDT
