Automatic Storage Management

Automatic Storage Management (ASM) is a feature provided by Oracle Corporation within the Oracle Database from release Oracle 10g (revision 1) onwards. ASM aims to simplify the management of database files. To do so, it provides tools to manage file systems and volumes directly inside the database, allowing database administrators (DBAs) to control volumes and disks with familiar SQL statements in standard Oracle environments. Thus DBAs do not need extra skills in specific file systems or volume managers (which usually operate at the level of the operating system).

With ASM:

  • IO channels can take advantage of data striping and software mirroring
  • DBAs can automate online redistribution of data, along with the addition and removal of disks/storage
  • the system maintains redundant copies and provides 3rd-party RAID functionality
  • Oracle supports third-party multipathing IO technologies (such as failover or load balancing to SAN access)
  • the need for hot spares diminishes

Read more about Automatic Storage Management:  Features, Architecture Overview, Implementation and Usage, Functionality, Striping, Redundancy, Directory Structure, Comparison With Other LVMs, Advantages For Database Administrators

Famous quotes containing the words automatic, storage and/or management:

    Predictions of the future are never anything but projections of present automatic processes and procedures, that is, of occurrences that are likely to come to pass if men do not act and if nothing unexpected happens; every action, for better or worse, and every accident necessarily destroys the whole pattern in whose frame the prediction moves and where it finds its evidence.
    Hannah Arendt (1906–1975)

    Many of our houses, both public and private, with their almost innumerable apartments, their huge halls and their cellars for the storage of wines and other munitions of peace, appear to me extravagantly large for their inhabitants. They are so vast and magnificent that the latter seem to be only vermin which infest them.
    Henry David Thoreau (1817–1862)

    Why not draft executive and management brains to prepare and produce the equipment the $21-a-month draftee must use and forget this dollar-a-year tommyrot? Would we send an army into the field under a dollar-a-year General who had to be home Mondays, Wednesdays and Fridays?
    Lyndon Baines Johnson (1908–1973)