الرجاء المساعدة ... حول كيفية حساب Java_pool_size , Large_pool_size

السلام عليكم و رحمة الله و بركاته

أحبتي الكرام

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

1 Calculate the minimum value for SGA

2 What is the best value for
2.1 JAVA_POOL_SIZE, justify your answer
2.2 LARGE_POOL_SIZE, justify your answer
3 Write the required initialization parameter file to build the database
4 Write the CREATE DATABASE script