{"id":5360,"date":"2026-02-01T20:34:52","date_gmt":"2026-02-01T15:04:52","guid":{"rendered":"https:\/\/w3buddy.com\/?p=5360"},"modified":"2026-02-01T20:34:53","modified_gmt":"2026-02-01T15:04:53","slug":"how-to-create-and-configure-asm-disk-groups-on-oracle-exadata-database-machine","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/how-to-create-and-configure-asm-disk-groups-on-oracle-exadata-database-machine\/","title":{"rendered":"How to Create and Configure ASM Disk Groups on Oracle Exadata Database Machine"},"content":{"rendered":"\n

Oracle Automatic Storage Management (ASM) serves as the foundational storage management layer for Oracle Exadata environments. By organizing grid disks into logical disk groups, database administrators can achieve optimal redundancy, enhanced performance, and seamless integration with Exadata’s intelligent storage features like Smart Scan offloading.<\/p>\n\n\n\n

This comprehensive guide walks you through the complete process of creating ASM disk groups, understanding critical configuration parameters, and implementing proven strategies for production environments.<\/p>\n\n\n\n

Complete Implementation Guide<\/h2>\n\n\n\n

Initial Setup: Establishing ASM Connection<\/h3>\n\n\n\n

Before creating disk groups, you must establish a connection to the ASM instance with appropriate privileges.<\/p>\n\n\n\n

Configure your environment variable to point to the correct ASM instance:<\/p>\n\n\n\n

$ export ORACLE_SID=+ASM1<\/code><\/pre>\n\n\n\n
Access the ASM instance using SYSASM administrative privileges:<\/p>\n\n\n\n
$ sqlplus \/ as sysasm<\/code><\/pre>\n\n\n\n
Inventory Assessment: Discovering Available Storage<\/h3>\n\n\n\n
Before provisioning new disk groups, examine the available grid disks in your Exadata environment:<\/p>\n\n\n\n
sql<\/p>\n\n\n\n
SQL> SELECT path, header_status \nFROM v$asm_disk \nWHERE path LIKE 'o\/%'\nORDER BY path;<\/code><\/pre>\n\n\n\n
This query returns all Exadata-managed grid disks and their current assignment status, helping you identify unallocated storage resources.<\/p>\n\n\n\n
Disk Group Creation Examples<\/h3>\n\n\n\n
Primary Data Storage (High Redundancy Configuration)<\/h4>\n\n\n\n
For mission-critical database files requiring maximum protection:<\/p>\n\n\n\n
CREATE DISKGROUP primary_data HIGH REDUNDANCY\nDISK 'o\/*\/DATA_CD_*'\nATTRIBUTE 'au_size' = '4M',\n          'content.type' = 'data',\n          'compatible.rdbms' = '12.2.0.1',\n          'compatible.asm' = '21.0.0.0',\n          'cell.smart_scan_capable' = 'TRUE';<\/code><\/pre>\n\n\n\n
Recovery Area Storage (High Redundancy Configuration)<\/h4>\n\n\n\n
For archived redo logs, RMAN backups, and flashback logs:<\/p>\n\n\n\n
CREATE DISKGROUP fast_recovery HIGH REDUNDANCY\nDISK 'o\/*\/RECO_CD_*'\nATTRIBUTE 'au_size' = '4M',\n          'content.type' = 'recovery',\n          'compatible.rdbms' = '12.2.0.1',\n          'compatible.asm' = '21.0.0.0';<\/code><\/pre>\n\n\n\n
System Files Storage (For Earlier Exadata Models)<\/h4>\n\n\n\n
On pre-X8 Exadata systems, configure the system disk group:<\/p>\n\n\n\n
ALTER DISKGROUP system_files SET ATTRIBUTE \n'content.type' = 'system',\n'compatible.rdbms' = '12.2.0.1',\n'compatible.asm' = '21.0.0.0';<\/code><\/pre>\n\n\n\n
Sparse Disk Group (For Snapshot and Clone Operations)<\/h4>\n\n\n\n
Enable thin provisioning for test\/development clones:<\/p>\n\n\n\n
CREATE DISKGROUP snapshot_storage NORMAL REDUNDANCY\nDISK 'o\/*\/SPARSE_CD_*'\nATTRIBUTE 'au_size' = '4M',\n          'content.type' = 'data',\n          'cell.smart_scan_capable' = 'TRUE',\n          'compatible.rdbms' = '12.2.0.1',\n          'compatible.asm' = '21.0.0.0',\n          'cell.sparse_dg' = 'allsparse';<\/code><\/pre>\n\n\n\n
Critical Configuration Parameters<\/h2>\n\n\n\n
Version Compatibility Guidelines<\/h3>\n\n\n\n
The compatibility settings determine which Oracle features your disk group can utilize. Sparse disk groups specifically require both compatible.asm<\/code> and compatible.rdbms<\/code> set to version 12.2.0.1 or higher. Remember that disk group compatibility attributes take precedence over ASM instance-level compatibility settings, so plan your version strategy carefully.<\/p>\n\n\n\n
Allocation Unit Sizing<\/h3>\n\n\n\n
The allocation unit size determines how ASM allocates space within the disk group. For Exadata environments, Oracle recommends setting au_size<\/code> to 4MB to optimize parallel query performance and Smart Scan efficiency. This sizing balances metadata overhead with I\/O performance for typical Exadata workloads.<\/p>\n\n\n\n
Verifying Disk Group Configuration<\/h3>\n\n\n\n
After creating disk groups, validate their configuration using ASM dynamic performance views:<\/p>\n\n\n\n
SQL> SELECT dg.name AS diskgroup_name, \n            a.name AS attribute_name, \n            a.value AS attribute_value\nFROM v$asm_diskgroup dg \nJOIN v$asm_attribute a ON dg.group_number = a.group_number\nWHERE dg.name IN ('PRIMARY_DATA', 'FAST_RECOVERY')\nORDER BY dg.name, a.name;<\/code><\/pre>\n\n\n\n
Sample Attribute Configuration<\/h2>\n\n\n\n
Disk Group Name<\/th>Attribute<\/th>Configured Value<\/th><\/tr><\/thead>
PRIMARY_DATA<\/td>compatible.rdbms<\/td>12.2.0.1<\/td><\/tr>
PRIMARY_DATA<\/td>compatible.asm<\/td>21.0.0.0<\/td><\/tr>
PRIMARY_DATA<\/td>au_size<\/td>4194304 (4 MB)<\/td><\/tr>
PRIMARY_DATA<\/td>disk_repair_time<\/td>3.6h<\/td><\/tr>
PRIMARY_DATA<\/td>cell.smart_scan_capable<\/td>TRUE<\/td><\/tr>
FAST_RECOVERY<\/td>content.type<\/td>recovery<\/td><\/tr>
FAST_RECOVERY<\/td>au_size<\/td>4194304 (4 MB)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Implementing Tablespaces on ASM Disk Groups<\/h2>\n\n\n\n
Once your disk groups are configured, create tablespaces that leverage Exadata’s intelligent storage capabilities:<\/p>\n\n\n\n
SQL> CREATE TABLESPACE app_data \nDATAFILE '+PRIMARY_DATA' \nSIZE 10G \nAUTOEXTEND ON \nNEXT 1G \nMAXSIZE UNLIMITED;<\/code><\/pre>\n\n\n\n
Confirming Smart Scan Enablement<\/h3>\n\n\n\n
Verify that your tablespace is configured for storage-side query processing:<\/p>\n\n\n\n
SQL> SELECT tablespace_name, \n            predicate_evaluation,\n            def_inmemory\nFROM dba_tablespaces \nWHERE tablespace_name = 'APP_DATA';<\/code><\/pre>\n\n\n\n
When predicate_evaluation<\/code> displays ‘STORAGE’, your queries can be offloaded to Exadata storage servers, dramatically reducing the volume of data transferred to database servers and accelerating analytical query performance.<\/p>\n\n\n\n
Production Best Practices<\/h2>\n\n\n\n
    \n
  • Standardize allocation unit sizing<\/strong> by consistently using 4MB allocation units across all Exadata disk groups to ensure optimal Smart Scan performance and minimize storage fragmentation.<\/li>\n\n\n\n
  • Apply appropriate content classification<\/strong> by setting correct content.type<\/code> values for each disk group purpose. This classification enables ASM to apply appropriate failure group policies and helps with capacity planning and performance monitoring.<\/li>\n\n\n\n
  • Maintain storage homogeneity<\/strong> by ensuring disk groups contain only Exadata grid disks. Mixing storage types can lead to performance unpredictability and complicate troubleshooting.<\/li>\n\n\n\n
  • Implement regular validation routines<\/strong> by periodically querying ASM dynamic views to verify disk group attributes remain correctly configured, especially after maintenance windows or system upgrades.<\/li>\n\n\n\n
  • Optimize for query offloading<\/strong> by placing frequently accessed analytical tables in disk groups configured with Smart Scan capability enabled. This maximizes the performance benefits of Exadata’s storage intelligence.<\/li>\n\n\n\n
  • Plan compatibility progression<\/strong> before upgrading ASM or database software by understanding that compatibility attribute changes are one-way operations. Always test compatibility upgrades in non-production environments first.<\/li>\n\n\n\n
  • Monitor disk repair time settings<\/strong> to ensure failed disk replacement windows align with your availability requirements. The default 3.6-hour setting works well for most Exadata configurations with Oracle support SLAs.<\/li>\n<\/ul>\n\n\n\n
    Summary<\/h2>\n\n\n\n
    Properly configured ASM disk groups form the foundation of reliable, high-performance Oracle Exadata deployments. By understanding allocation unit sizing, compatibility requirements, redundancy levels, and content classification, you can build storage architectures that maximize Exadata’s unique capabilities while ensuring data protection and operational flexibility. The configuration examples and validation techniques provided here enable you to implement disk groups that meet both current operational needs and future scalability requirements.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Oracle Automatic Storage Management (ASM) serves as the foundational storage management layer for Oracle Exadata environments. By organizing grid disks into logical disk groups, database administrators can achieve optimal redundancy, enhanced performance, and seamless integration with Exadata’s intelligent storage features like Smart Scan offloading. This comprehensive guide walks you through the complete process of creating […]<\/p>\n","protected":false},"author":1,"featured_media":5362,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-5360","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/5360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=5360"}],"version-history":[{"count":1,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/5360\/revisions"}],"predecessor-version":[{"id":5361,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/5360\/revisions\/5361"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media\/5362"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=5360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=5360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=5360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}