Another doubt in 9.0.1.0.0 database..

2002-02-14 Thread Arul kumar
Hi DBAs, While reducing the JAVA_POOL_SIZE in initfile , i observed that minimum it takes 8M and not less than that. If we dont specify this parameter, default value it takes as 20 M !!. If there is no JAVA related stuff in my application / database..., why should i have this space

Re: Another doubt in 9.0.1.0.0 database..

2002-02-14 Thread Connor McDonald
From the performance guide: Memory for the shared pool and buffer cache is allocated in units of granules. A granule can be 4 MB or 16 MB, depending on the total size of your SGA at the time of instance startup. If the size of your SGA is less than 128 MB, then the granules are 4 MB in size;

Re: Another doubt in 9.0.1.0.0 database..

2002-02-14 Thread Joe Testa
read admin guide. joe Arul kumar wrote: Hi DBAs, While reducing the JAVA_POOL_SIZE in initfile , i observed that minimum it takes *8M* and not less than that. If we dont specify this parameter, default value it takes as *20 M *!!. If there is no JAVA related stuff in my

RE: Another doubt in 9.0.1.0.0 database..

2002-02-14 Thread Enrique Orbegozo
$sgastat. Remark:-- Bug:2084844 is initially fixed in version 9.2. . -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Arul kumarEnviado el: Jueves, 14 de Febrero de 2002 03:08 a.m.Para: Multiple recipients of list