Automatic Storage Management

From Wikipedia, the free encyclopedia

 This article or section needs to be wikified to meet Wikipedia's quality standards.
Please help improve this article with relevant internal links. (March 2008)

Automatic Storage Management is a feature provided in Oracle 10g (since rev1) that aims to simplify the database files management. To do so, ASM provides file system and volume management capabilities directly inside the Oracle database kernel, allowing volumes and disks management with familiar SQL statements in Oracle. Therefore, the DBA doesn't need extra skills on specific file systems or volume managers usually provided by the operating system.

With ASM:

  • IOs can be spread over all the disks available
  • Automatic online redistribution when you add or remove some storage
  • Maintains redundant copies and provides 3rd party RAID functionalities
  • Support 3rd party multipathing IO technologies (failover or load balancing to SAN access, etc.)
  • Eliminates the needs for hot spares

Features:

  • ASMCMD useful for users not familiar with SQL (you can write scripts with it)

References [[ASM presentation][1]]

Languages