أرجو المساعدة في تصميم قاعدة البيانات هذه ؟

SGA_MAX_SIZE = 256 MB
DB_CACHE_SIZE = 50 MB
SHARED_POOL_SIZE = 40 MB
DB_BLOCK_SIZE = 8 K

No Java option is required with the database, and Dedicated Server mode is used .
The database should not accept more than 15 datafiles, 3 log groups, and 3 log members during its lifetime .
One control file , 2 groups of redo log files with one member in each one, Automatic undo management .

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

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

الاخ rodos_sa85 راجع الرابط اعلاه سوف يفيدك كثيرا فى هذا الموضوع

إضغط هنا