Home » RDBMS Server » Server Administration » Java pool, Log Buffer and Granules
Java pool, Log Buffer and Granules [message #219894] Fri, 16 February 2007 10:20 Go to next message
sandhyaa
Messages: 79
Registered: February 2007
Member
Hi All,
I am relatively new in Oracle Database administration. I was going through the Oracle Concepts - Memory Architecture where I came to know about Granules and v$sga_dynamic_components.

When I queried this view I am able to see Shared Pool, Large Pool and Buffer Cache with granule size of 16MB. However I am not able to see Java Pool and Log Buffer? Can anyone explain the reason behind this?
Java_Pool has been defined in the init parameter file.


Thanks in advance
Sandi
Re: Java pool, Log Buffer and Granules [message #219903 is a reply to message #219894] Fri, 16 February 2007 10:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Always post your version.
This view has to do with ASMM. Did you enable it?
>>Java_Pool has been defined in the init parameter file.
To enable it, you are supposed to use SPFILE not PFILE
and
set SGA_TARGET.

[Updated on: Fri, 16 February 2007 10:42]

Report message to a moderator

Re: Java pool, Log Buffer and Granules [message #219904 is a reply to message #219903] Fri, 16 February 2007 11:00 Go to previous message
sandhyaa
Messages: 79
Registered: February 2007
Member
Hi,
Sorry for not including the version. I am on Oracle Enterprise 9.2.0.6.
I have put JAVA_POOL_SIZE in init parameter and the same is getting reflected when I query v$parameter.
I could not understand why it need to be defined in spfile.
SGA_TARGET_SIZE is also set in init file.

Currently I am not using SPFILE.
What did you mean by ASMM??

Can you please elaborate?

Thanks
Sandi
Previous Topic: same user connecting from 10 machines
Next Topic: accout is locked
Goto Forum:
  


Current Time: Fri Sep 20 05:48:03 CDT 2024