Re: How many Private SQL Areas....

Satmika wrote:

> Can someone clarify this for me please.
>
> Oracle Manual says:
> >Be sure that your application can open enough Private SQL areas to
 accommodate
> >all your SQL statements.
>
> -How many Private SQL Areas can a session open?
> -Does it depend on the combination of
> Open Cursors parameter and Shared Pool size for MTS and
> Open Cursors and OS memory limits for Dedicated Server (as the Private
> SQL Area will be in PGA)
>
> Am I not talking the right language here?
>
> Thanks in advance

You questions are right to the point. Session opens as many private areas as it have open cursors. So it's not a big amount for an average session. With MTS, you need enough shared_pool_size to accomodate all private sql areas for all MTS sessions. For dedicated servers, OS memory limit is the only restriction. Open cursors paraemeter is usually big enough for average session. There is one problem here. You won't see message "cannot allocate private sql area". You'll see something like "cannot allocate 24 bytes of memory in shared pool" for the MTS configuration. Received on Sat Jul 21 2001 - 16:34:58 CDT