| Java pool& larg pool [message #389777] |
Tue, 03 March 2009 09:43  |
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 #389791 is a reply to message #389788] |
Tue, 03 March 2009 10:10  |
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 #390308 is a reply to message #389777] |
Thu, 05 March 2009 17:35 |
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 #390342 is a reply to message #390308] |
Fri, 06 March 2009 01:03 |
Frank
Messages: 7901
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)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
