Friday , October 20 2017
Home / Oracle DBA / OPTIMAL FLEXIBLE ARCHITECTURE (OFA)

OPTIMAL FLEXIBLE ARCHITECTURE (OFA)

OPTIMAL FLEXIBLE ARCHITECTURE (OFA)

  1. Reading and writing to a hard disk will be done with the help of I/O header.
  2. For a hard disk there will be only one I/O header exists.
  3. As per OFA, oracle recommends to store all the physical files separately in different hard drives.
  4. In such case, different I/O headers will be working for different hard drives thereby increasing database performance.
  5. If not possible, at least we should separate redo log files, archive log files and control files from data files.
Read More:
Background Processors
SMON’s instance recovery with example
COMPONENTS OF ORACLE DATABASE ARCHITECTURE

Comments

comments

Check Also

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

Your email address will not be published. Required fields are marked *