You can minimize the time spent making decisions regarding file structure and naming, and you have fewer file management tasks. They simplify creation of test and development databases. This also simplifies the administrative task of removing files that are no longer required on disk and prevents the mistake of deleting the wrong file. Much disk space is wasted in large systems simply because no one is sure if a particular file is still required. Oracle Database automatically removes old Oracle Managed Files when they are no longer needed. They reduce wasted disk space consumed by obsolete files. Using two different names that refer to the same file is another mistake that causes major corruptions. Using the same file in two different databases is a common mistake that can cause very large down times and loss of committed transactions. They reduce corruption caused by administrators specifying the wrong file.Įach Oracle managed file and file name is unique. The file system defines the characteristics of the storage and the pool where it is allocated. A consistent set of rules is used to name all relevant files. There is no need to invent file names and define specific storage requirements. They make the administration of the database easier. Multiple file systems are constructed to give different storage characteristics to different files as well as to divide the available disk space into pools that do not affect each other.Ĭonsider the following benefits of using Oracle Managed Files: However some LVM/FM combinations allow space to be added or removed from a file system.Īn operating system can support multiple file systems. Space available in one file system does not affect space in another file system. If a file system is out of space, then none of the files in that file system can grow. A file system is a single pool of storage that is shared by all the files in the file system. Thus all the files in a particular file system have the same performance, reliability, and availability characteristics inherited from the underlying logical volume. Each file has a name associated with it that is used to refer to the file.Ī file system is commonly built on top of a logical volume constructed by an LVM. Files can be created, read, written, resized, and deleted. The files may not actually be contiguous within the disk space of the file system. Each file is made to appear as a contiguous address space to applications such as Oracle Database. The primary task of a file manager is to allocate and deallocate disk space into files within a file system.Ī file system allows the disk space to be allocated to a large number of files. This feature does not affect the creation or naming of administrative files such as trace files, audit files, alert logs, and core files.Īll operating systems have file managers. The database then ensures that a unique file, an Oracle managed file, is created and deleted when no longer needed. Through initialization parameters, you specify the file system directory to be used for a particular type of file. The database internally uses standard file system interfaces to create and delete files as needed for the following database structures: This feature works well with a logical volume manager (LVM). For example, you need only specify that you want to create a tablespace you do not need to specify the name and path of the tablespace's data file with the DATAFILE clause. With Oracle Managed Files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. Using Oracle Managed Files does not eliminate any existing functionality.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |