Optimal Flexible Architecture

 Optimal Flexible Architecture

Optimal Flexible Architecture (OFA)

  OFA是oracle数据库中的一个概念 

  Installation and configuration on all supported platforms complies with Optimal Flexible 

  Architecture (OFA). OFA organizes database files by type and usage. Binary files, control 

  files, log files, and administrative files can be spread across multiple disks. 

  Consistent naming convention provides the following benefits: 

     *  Database files can be easily differentiated from other files

     *  It is easy to identify control files, redo log files, and data files

     *  Easier administration of multiple Oracle Homes on the same machine by separating 

        files on different disks and directories 

     *  Better performance is achieved by decreasing disk contention among data files, binary 

        files, and administrative files which can now reside on separate directories and disks


Oracle有灵活的文件目录结构，具体表现在：

1，        能将数据文件，二进制文件，日志文件，控制文件写在不同的磁盘上

2，        数据库的文件能很容易与平台中的其它文件区别开来。

3，        容易确定控制文件，redo日志文件和数据文件

4，        能很容易的在同一machine 上管理多个Oracle Homes，通过将它们各自的文件放在不同的disk和directory里面。

5，        将文件放在不同的磁盘上，这样加快了执行的效率