1-what is the instructions needed to distribute the control files on the three disk
2- and what is the instructions needed to distribute the data files in the following manner
2-1 Data file of the System tablespace on the D: drive
2-2 Data file of the Temp tablespace on the D: Drive
2-3 Data file of the Undo tablespace on the E: Drive

ارجو المساعدة بسرعة وشكرا

Every Oracle database should have at least two control files, each stored on a different disk. If a control file is damaged due to a disk failure, the associated instance must be shut down. Once the disk drive is repaired, the damaged control file can be restored using an intact copy of the control file and the instance can be restarted; no media recovery is required.

The only disadvantage of having multiple control files is that all operations that update the control files (such as adding a datafile or checkpointing the database) can take slightly longer. However, this difference is usually insignificant (especially for operating systems that can perform multiple, concurrent writes) and does not justify using only a single control file.

Oracle strongly recommends that your database has a minimum of two control files on different disks.

Store Datafiles Separate from Redo Log Files

if several disk drives are available to store the database,
consider placing potentially contending datafiles on separate disks.This way,
when users query information, both disk drives can work simultaneously, retrieving data at the same time

.

شكرا كتير استاذ سعيد
لو سمحت في مجال تزوديدي بتعليمات PL*SQL
التابعة لاسئلتي وشكرا

مش فاهم ايه المقصود السؤال الاخير للأسف

مش فاهم ايه المقصود السؤال الاخير للأسف

شكرا اللك كتير

تم تعديل 2 مايو 201114 سنة بواسطة Nour_391