ASM Internals - What You Need to Know

8:30 AM–9:30 AM Apr 25, 2018

Palm C


Session ID: 1127


Oracle's ASM storage software is often viewed as a bit of a black box. Typically a DBA creates disk groups, adds tablespaces and disks as needed and forgets about it. Just as a DBA should know how the database works, the astute DBA should have a knowledge of how ASM really works.

A knowledgeable DBA should be able to explain how ASM replicates data, and how this is different than RAID technology. Failgroups are an integral part of ASM, so understanding how they work is critical to understanding ASM.  Allocation units, extents and more will be considered in a discussion of how ASM works.

Many DBA's leave all of the Hardware configuration to System Administrators.  As with DBA's, the quality of System Administrator's work and understand of the systems vary with the individual.  Dedicated DBA's attending Collaborte 2018 will want to know some basic configuration items to verify before proceeding with ASM installations.  Among topics to be covered will be Disk Partitioning and Sector Alignment.

Troubleshooting and extreme recovery methods will be considered as well. If you do not already the risks when the value of Usable_file_MB is a negative value, or how you may extract Oracle datafiles directly from ASM disks, then this presentation is for you.
Whether your databases are on premise or in the cloud, if you are using ASM you need to know how it works.This presentation will show you how ASM works.


Objective 1: Gain an understanding of the basic architecture of Oracle Automatic Storage Management (ASM)

Objective 2: Gain insight into how ASM works behind the scenes. You cannot diagnose what you do not understand.

Objective 3: Learn what tools can be used to diagnose ASM issues.

Audience: In-Depth