مساعدة في : Homework

[ahmadkassem]

السلام عليكم

اخوتي الكرام لدي موضوع في الاوراكل و أرجو من الأخوة الأفاضل مساعدتي في حل هذا الموضوع و لكم جزيل الشكر

هذا رابط الموضوع

http://www.mediafire.com/download/6b99d9swy9fqq3s/file.docx

أرجو المساعدة بالسرعة الفائقة

و السلام عليكم

 

 

 

Homework text

 

You've been asked as a DBA to create an Oracle database as part of a company application that meets the following requirements with the best performance:

 

Server Hardware Specifications

 

1.    Oracle 11gis installed.

2.    Operating System is Windows Server.

3.    Four disk drives (C, D, E and F).

4.    Your server total RAM is 2 GB.

 

Application Specifications

5.    Small size ERP application.

6.    The application consists of the following modules:

a.    Human Resources Module (ذاتية الموظفين).

b.    Finance Module (محاسبة ورواتب).

c.    Sales Module (مبيعات).

7.    6 employees are only allowed to connect concurrently to the database using their company desktops. No access is allowed from the internet.

8.    No Java option is required with the application or database.

 

Database Specifications

9.    Database name should be the same as your group (Example: G2 or G9).

10.  Database Memory:

a.    Our oracle database systemwide usable memory shall be 25% of the server memory.

b.    Our oracle database systemwide usable memory shall not exceed 25% of the server memory during its lifetime.

c.    Automatic Memory Management is enabled.

11.  The database should not accept more than 75 database files during its lifetime.

12.  Automatic undo management is required.

13.  The database should be available 7/7 days, and 24/24 hours.

14.  No data loss is allowed during the database lifetime.

 

requests

 

Please answer the following questions with respect to all the previous requirements:

 

Server Mode

1       What is the best server connection mode for our database? Justify your answer.

 

SettingInitialization Parameters

2       What is the initialization parameter file type you are going to use? Justify your answer.

3       What are the values of DB_NAME and DB_DOMAIN?

4       What is the best value for LARGE_POOL_SIZE? Justify your answer.

5       What is the best value for JAVA_POOL_SIZE? Justify your answer.

6       What are the required initialization parametersrelated to memory that should be used to create the database?List these parameters with suitable values.

7       What is the value of CONTROL_FILES?

8       What is the value of DB_BLOCK_SIZE? Justify your answer.

9       What is the value of PROCESSES? Justify your answer.

10     List the initialization parameters related to the Undo management with their suitable values.

11     What is the value of COMPATIBLE?

12     How can you satisfy the specification number 11?

 

Logical & Physical Structures

13     List all the required tablespaces with respect to all the previous conditions, justify your answer.

14     List all the required Log and control files with their location considering all the specifications especially 13 & 14.

15     How can you satisfy specification 14? Justify your answer.

 

Database Creation

16     Write the CREATE DATABASE script.