Home » RDBMS Server » Server Administration » Java pool& larg pool (oracle 9i)
Java pool& larg pool [message #389777] Tue, 03 March 2009 09:43 Go to next message
ammar_call
Messages: 11
Registered: March 2009
Junior Member
Hello

i'm sorry for my questions but i'm beginner in Oracle.

how we can calculate Java_pool_size and larg_pool_size?

and what is the rules that we can follow it to define it.

thanx
Re: Java pool& larg pool [message #389779 is a reply to message #389777] Tue, 03 March 2009 09:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams087.htm#REFRN10075

both answered in reference guide to some extent. The reset depends on your environment.
Re: Java pool& larg pool [message #389782 is a reply to message #389779] Tue, 03 March 2009 09:52 Go to previous messageGo to next message
ammar_call
Messages: 11
Registered: March 2009
Junior Member
thank you

Java pool it's an optional is't write?

for examlpe if i get (no java option is reqired with the database) then the java_pool_size=0

is it write??
Re: Java pool& larg pool [message #389788 is a reply to message #389782] Tue, 03 March 2009 10:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

>>is it write??
What do you mean?
it is just an area in memory. If you are using java options/ASM, you need to set up this properly
Re: Java pool& larg pool [message #389791 is a reply to message #389788] Tue, 03 March 2009 10:10 Go to previous messageGo to next message
ammar_call
Messages: 11
Registered: March 2009
Junior Member

I have this requirement:
1. SGA_MAX_SIZE = 256 MB
2. DB_CACHE_SIZE = 50 MB
3. SHARED_POOL_SIZE = 40 MB
4. No Java option is required with the database
5. Dedicated Server mode is used
6. DB_BLOCK_SIZE = 8 K

and the question is
1 What is the best value for
1.1 JAVA_POOL_SIZE, justify your answer
2.1 LARGE_POOL_SIZE, justify your answer

Re: Java pool& larg pool [message #389889 is a reply to message #389791] Tue, 03 March 2009 23:59 Go to previous messageGo to next message
ammar_call
Messages: 11
Registered: March 2009
Junior Member
any comment please
Re: Java pool& larg pool [message #389903 is a reply to message #389889] Wed, 04 March 2009 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Best value depends on workload, describe your workload in details with all the variables you use.

Regards
Michel
Re: Java pool& larg pool [message #390308 is a reply to message #389777] Thu, 05 March 2009 17:35 Go to previous messageGo to next message
7ayatona
Messages: 1
Registered: March 2009
Junior Member
1. Your server has 1 disk drive (C:), a RAM of 512 MB, and Windows 2003 server
2. Oracle R2 is installed, and the installation is OFA-compliant where
• ORACLE_BASE = C:\oracle
• ORACLE_HOME = C:\oracle\ora92
3. Choose your database name and system identifier as your group number (ex: G10)
4. SGA_MAX_SIZE = 256 MB
5. DB_CACHE_SIZE = 50 MB
6. SHARED_POOL_SIZE = 40 MB
7. No Java option is required with the database
8. Dedicated Server mode is used
9. DB_BLOCK_SIZE = 8 K
10. The database should not accept more than 15 datafiles, 3 log groups, and 3 log members during its lifetime
11. One control file
12. 2 groups of redo log files with one member in each one
13. Automatic undo management
14. Tablespaces are

TABLESPACE DATAFILES TYPE
system 2 Dictionary managed
temp_tbls 1 Locally managed
undo_tbls 1 Locally managed
data_tbls 1 Locally managed
index_tbls 1 Locally managed

15. DFAULT profile is applied to all users
16. The database should be available 7/7 days, and 24/24 hours
17. No data loss is allowed during the database lifetime


the question now is :
What is the best value for
1.JAVA_POOL_SIZE, justify your answer
2.LARGE_POOL_SIZE, justify your answer

thanks alot
Re: Java pool& larg pool [message #390335 is a reply to message #390308] Fri, 06 March 2009 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 04 March 2009 07:48
Best value depends on workload...

Regards
Michel

Re: Java pool& larg pool [message #390342 is a reply to message #390308] Fri, 06 March 2009 01:03 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
7ayatona wrote on Fri, 06 March 2009 00:35
7. No Java option is required with the database

the question now is :
What is the best value for
1.JAVA_POOL_SIZE, justify your answer
2.LARGE_POOL_SIZE, justify your answer

thanks alot


I might be missing something, but the first question seems obvious to me... (But, as in /.-speak: IANADBA)
Previous Topic: ORA-01555 caused by sql statement
Next Topic: plz. help me out , oracle 10g database problem
Goto Forum:
  


Current Time: Fri Dec 09 00:29:30 CST 2016

Total time taken to generate the page: 0.07915 seconds