Four Data Storage Methods in Oracle10g

1. Operating System Files

This is the most common method and the most common form of non-commercial operation mode (such as the testing environment in the development or development phase. When you install Oracle, if you choose the operating system file storage format, the Oracle data will be stored in the operating system and stored as files. It's like we play some single-host games, and your archive is the file of the operating system. The advantage of storing data in the form of files is that the database is easy to move. For example, if you copy ORACLE data files directly to a computer, you can quickly copy the same database system. When reading and writing files, the operating system usually provides a cache for reading and writing, so as to avoid the damage caused by too many hard disks. Therefore, storing data in the form of operating system files is equivalent to obtaining the operating system cache function.

2. Raw Partition

Raw partitions are used to write databases directly on disks without passing through the operating system layer. Oracle specifically reads and writes this partition. Without the operating system, the speed and performance of reading and writing are a general leap. In some database applications that frequently read and write ORACLE data, using bare partitions to store data can even improve performance by more than 30%. Of course, if the data is stored in the operating system file, if raid is used in UNIX, it is also a means to improve the performance when file read/write operations are frequent.

3. Automatic Storage Management

Automatic Storage Management, also known as ASM, is a new storage format provided after 10 Gb of oracle. This storage format seems to be a compromise between the first two storage formats. It is neither a file system of the host operating system nor a raw partition that is directly read and written by Oracle. It can be viewed as an oracle-specific file system. Data files, control files, and log files can be stored on ASM. in ASM, these files also exist in the form of files, in this case, the file format is the Oracle ASM format. In Linux, similar to ASM is LVM (logical volume management), which can also be seen as a new file system form.

4. Cluster System OCFS (RAC)

What is the full name of RAC? Real Application Cluster is a database storage form that is shared in the Cluster environment. In our database, if it is a standalone database, when the data file disk cannot be accessed, the database will be suspended. If a cluster shares a database, one of the methods is to store data files on a node, and the rest of the databases are shared through NFS or Samba, although the data processing capability of the database has been greatly improved, if the storage node fails, the database will also go down. OCFS is a non-resumable storage mode. It gives people the feeling that each data server has its own file system, however, these file systems seem to be the same file system, because data updates or other operations are unified. Even if a computer crashes, the rest of the servers still run without database exceptions, and it is very easy to add a new server. It is particularly suitable for commercial 7x24 service forms.