Re: How to calculate the shared pool size when increasing the processes parameter
- From: "Anand Rao" <panandrao@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- Date: Tue, 21 Nov 2006 10:08:49 +0530
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@xxxxxxxxxxxxxxxxxxxxx <
genegurevich@xxxxxxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
