Identify the statement about ASM that is NOT true.
A.
ASM is easier to manage than file systems.
B.
ASM delivers the performance of raw partitions.
C.
ASM is an extra cost option for Oracle databases.
D.
ASM delivers automatic striping and mirroring.
Explanation:
ASM is a management tool, not a RAW performance tool.
Note:
Automatic Storage Management (ASM) is a new feature that has be introduced in Oracle 10g to
simplify the storage of Oracle datafiles, controlfiles and logfiles.
Automatic Storage Management (ASM) simplifies administration of Oracle related files by allowing
the administrator to reference disk groups rather than individual disks and files, which are
managed by ASM. The ASM functionality is an extention of the Oracle Managed Files (OMF)functionality that also includes striping and mirroring to provide balanced and secure storage. The
new ASM functionality can be used in combination with existing raw and cooked file systems,
along with OMF and manually managed files.
The ASM functionality is controlled by an ASM instance. This is not a full database instance, just
the memory structures and as such is very small and lightweight.
The main components of ASM are disk groups, each of which comprise of several physical disks
that are controlled as a single unit. The physical disks are known as ASM disks, while the files that
reside on the disks are known as ASM files. The locations and names for the files are controlled
by ASM, but user-friendly aliases and directory structures can be defined for ease of reference.
The level of redundancy and the granularity of the striping can be controlled using templates.
Default templates are provided for each file type stored by ASM, but additional templates can be
defined as needed.
Failure groups are defined within a disk group to support the required level of redundancy. For
two-way mirroring you would expect a disk group to contain two failure groups so individual files
are written to two locations.
In summary ASM provides the following functionality:
*Manages groups of disks, called disk groups.
*Manages disk redundancy within a disk group.
*Provides near-optimal I/O balancing without any manual tuning.
*Enables management of database objects without specifying mount points and filenames.
*Supports large files.
Reference: Automatic Storage Management (ASM) in Oracle Database 10g
http://www.oracle-base.com/articles/10g/AutomaticStorageManagement10g.php
C is correct.
C.ASM is an extra cost option for Oracle databases