First page Back Continue Last page Graphics

Performance Factors


Notes:

Let's discuss the factors that will impact the performance of your RMAN operations. I will list them here (with a brief note on each), then look at each in more detail and incorporate these factors in case studies throughout the remainder of this lesson.
The performance factors include:
Disk configuration – The number of disks you have containing the Oracle data to be backed up will have a definite impact on RMAN performance. Using an extreme example, imagine the performance bottleneck if only a single device was available to hold all your Oracle data. The backup or restore operation could not go any faster that the transfer rate of that one device. The SAME document summarizes the issue “stripe data to equalize the workload across disks and eliminate hotspots” and “stripe data to enable many disks to serve requests for any subset of data”. Striping will have a positive impact on performance. device transfer rate will limit performance. The SAME methodology also finds that, for availability, mirroring will perform better that RAID-5.


Notes for this slide continue on the next page…