oracle 10g performance tuning 12.ppt

Tuning I/O Objectives After completing this lesson, you should be able to do the following: Diagnose database I/O issues Describe the Stripe And Mirror Everything (SAME) concept Explain the benefits of asynchronous I/O Choose appropriate I/O solutions Tune I/O using Automatic Storage Management (ASM) I/O Architecture Oracle Database 10g includes three standard storage options: File system Raw partitions Automatic Storage Management (ASM) File System Characteristics Certain characteristics are better for database use: Write-through-cache ability Write acknowledgement Security Journaling High