Re: How to calculate the shared pool size when increasing the processes parameter

AFAIK there is probably a bit more than that. However, I wouldn't bother at all for such "microscopic" change unless shared pool sizing is really tight.

On 11/20/06, Anand Rao <panandrao_at_gmail.com> wrote:
> Hi,
>
> V$SGASTAT could be your friend.
>
> select * from v$sgastat where name = 'processes' ;
>
> V$SGASTAT also contains details regarding other parts of the SGA. In 10g,
> there is more detail in this view compared to Oracle 9i R2.
>
> curiously, in a 9.2 database, for a value of 500 for processes, the amount
> of memory used is around 628K.
>
>
> SQL> select * from v$sgastat where name = 'processes' ;
>
> POOL NAME BYTES
> -------------- -------------------------- ----------
> shared pool processes 644000
>
>
> In 10.2.0.1.0 for a processes value of 300,
>
> POOL NAME BYTES
> ------------ -------------------------- ----------
> shared pool processes 2400
>
> It only uses 2400 bytes.
>
> Not sure why there is so much memory used up in 9.2.
>
> check it before and after you change the processes value. also,
> V$RESOURCE_LIMIT can be useful.
>
> regards
> anand
>
>
> On 20/11/06, genegurevich_at_discoverfinancial.com
> <genegurevich_at_discoverfinancial.com> wrote:
> > Everybody:
> >
> > I am planning to increase the value of processes parameter in my databases
> > from 100 to 150. How do I calculate
> > the increase in the memory related parameters (shared pool etc) to
> > correspond to this increase? Are there any formulas
> > to at least do a ballpart estimate?
> >
> > thank you
> >
> > Gene Gurevich
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l