{"id":2015,"date":"2024-06-28T15:17:29","date_gmt":"2024-06-28T15:17:29","guid":{"rendered":"https:\/\/www.w3computing.com\/articles\/?p=2015"},"modified":"2024-06-28T15:17:34","modified_gmt":"2024-06-28T15:17:34","slug":"how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage","status":"publish","type":"post","link":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/","title":{"rendered":"How to Use Oracle&#8217;s Automatic Storage Management (ASM) for Efficient Storage"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle&#8217;s Automatic Storage Management (ASM) is a powerful feature designed to simplify the management of database storage by providing an easy-to-use interface for database administrators. ASM integrates with Oracle databases to offer high performance, scalability, and reliability while reducing the complexity of managing storage systems. This tutorial is aimed at non-beginners who are already familiar with Oracle databases and storage concepts. We will explore the architecture, configuration, management, and optimization techniques for using ASM effectively.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Introduction to Oracle ASM<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle ASM provides a robust and flexible storage management solution for Oracle databases. It abstracts the physical storage into logical units, making storage management simpler and more efficient. ASM performs automated striping and mirroring, thus improving performance and reliability. With ASM, DBAs can manage database storage using a consistent and integrated approach, reducing the complexity and overhead typically associated with traditional storage management.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. ASM Architecture and Components<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Understanding the architecture and key components of ASM is crucial for effectively utilizing its capabilities. ASM consists of several core components, including the ASM instance, ASM disk groups, ASM disks, and ASM files.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ASM Instance<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">An ASM instance is a special type of Oracle instance that manages ASM disk groups. It is similar to a database instance but does not require a data dictionary. The ASM instance is responsible for managing metadata and performing tasks such as disk group creation, resizing, and rebalancing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ASM Disk Groups<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM disk groups are logical storage units that consist of multiple ASM disks. Disk groups provide the foundation for ASM storage management. Each disk group can be configured with different redundancy levels (normal, high, or external) to ensure data protection and availability.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ASM Disks<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM disks are the physical storage devices that make up an ASM disk group. These can be physical disks, partitions, or logical volumes. ASM manages the disks, performing operations like striping and mirroring to optimize performance and reliability.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ASM Files<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM files are the actual database files stored within ASM disk groups. These files include data files, control files, redo log files, and others. ASM files are managed by the ASM instance, which ensures efficient storage allocation and access.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Installing and Configuring ASM<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before using ASM, it must be properly installed and configured. This section covers the prerequisites, installation steps, and configuration of ASM instances and disk groups.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Prerequisites<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Before installing ASM, ensure the following prerequisites are met:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Grid Infrastructure software is installed.<\/li>\n\n\n\n<li>Sufficient storage devices (disks or partitions) are available for ASM disk groups.<\/li>\n\n\n\n<li>Proper user permissions and groups are configured (usually the <code>oracle<\/code> user and <code>dba<\/code> group).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Installing ASM<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM is installed as part of Oracle Grid Infrastructure. Follow these steps to install ASM:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Download and extract Oracle Grid Infrastructure<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"Bash\" data-shcb-language-slug=\"bash\"><span><code class=\"hljs language-bash\">   unzip grid.zip -d \/u01\/app\/grid<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Bash<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">bash<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Run the Oracle Universal Installer (OUI)<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"Bash\" data-shcb-language-slug=\"bash\"><span><code class=\"hljs language-bash\">   \/u01\/app\/grid\/gridSetup.sh<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Bash<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">bash<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li><strong>Follow the installation wizard<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select &#8220;Install and Configure Grid Infrastructure for a Standalone Server&#8221;.<\/li>\n\n\n\n<li>Choose the appropriate Oracle Base and Software locations.<\/li>\n\n\n\n<li>Configure the ASM disk groups by specifying the available storage devices.<\/li>\n\n\n\n<li>Complete the installation and verify the ASM instance is running.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Creating ASM Instances<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Once ASM is installed, create and configure ASM instances using the following steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Create ASM initialization parameter file<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"Bash\" data-shcb-language-slug=\"bash\"><span><code class=\"hljs language-bash\">   vi \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/dbs\/init+ASM.ora<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Bash<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">bash<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p class=\"wp-block-paragraph\">Add the following parameters:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"plaintext\" data-shcb-language-slug=\"plaintext\"><span><code class=\"hljs language-plaintext\">   INSTANCE_TYPE=ASM\n   ASM_POWER_LIMIT=11\n   ASM_DISKSTRING='\/dev\/oracleasm\/disks\/*'<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">plaintext<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">plaintext<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Start the ASM instance<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   sqlplus \/ as sysasm\n   startup<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li><strong>Create ASM disk groups<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> <span class=\"hljs-keyword\">EXTERNAL<\/span> REDUNDANCY\n   DISK <span class=\"hljs-string\">'\/dev\/oracleasm\/disks\/DISK1'<\/span>,\n        <span class=\"hljs-string\">'\/dev\/oracleasm\/disks\/DISK2'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\">Creating ASM Disk Groups<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM disk groups are created during the ASM instance configuration. Additional disk groups can be created as needed using SQL commands:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Add a new disk group<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> FRA <span class=\"hljs-keyword\">NORMAL<\/span> REDUNDANCY\n   DISK <span class=\"hljs-string\">'\/dev\/oracleasm\/disks\/DISK3'<\/span>,\n        <span class=\"hljs-string\">'\/dev\/oracleasm\/disks\/DISK4'<\/span>,\n        <span class=\"hljs-string\">'\/dev\/oracleasm\/disks\/DISK5'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>List existing disk groups<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">NAME<\/span>, STATE, <span class=\"hljs-keyword\">TYPE<\/span> <span class=\"hljs-keyword\">FROM<\/span> V$ASM_DISKGROUP;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">4. Managing ASM Disk Groups and Disks<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Efficient management of ASM disk groups and disks is essential for maintaining optimal performance and reliability. This section covers adding and removing disks, rebalancing disk groups, and monitoring their status.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Adding and Removing Disks<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM allows dynamic addition and removal of disks to disk groups, enabling flexible storage management.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Add a disk to a disk group<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> <span class=\"hljs-keyword\">ADD<\/span> DISK <span class=\"hljs-string\">'\/dev\/oracleasm\/disks\/DISK6'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Drop a disk from a disk group<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> <span class=\"hljs-keyword\">DROP<\/span> DISK <span class=\"hljs-string\">'DISK6'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li><strong>Check the status of disks<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">NAME<\/span>, STATE, MOUNT_STATUS <span class=\"hljs-keyword\">FROM<\/span> V$ASM_DISK;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\">Rebalancing Disk Groups<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM automatically rebalances disk groups when disks are added or removed. The rebalancing operation redistributes data to maintain optimal performance.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Manually initiate rebalancing<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> REBALANCE <span class=\"hljs-keyword\">POWER<\/span> <span class=\"hljs-number\">5<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Monitor rebalancing status<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">SELECT<\/span> GROUP_NUMBER, OPERATION, STATE, <span class=\"hljs-keyword\">POWER<\/span>, SOFAR, EST_WORK, EST_RATE, EST_MINUTES\n   <span class=\"hljs-keyword\">FROM<\/span> V$ASM_OPERATION;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\">Monitoring ASM Disk Groups<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Regular monitoring of ASM disk groups ensures they operate efficiently and helps identify potential issues early.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>View disk group usage<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-14\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">NAME<\/span>, TOTAL_MB, FREE_MB, USABLE_FILE_MB, OFFLINE_DISKS\n   <span class=\"hljs-keyword\">FROM<\/span> V$ASM_DISKGROUP;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Check for alerts and warnings<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-15\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">SELECT<\/span> MESSAGE, <span class=\"hljs-built_in\">TIME<\/span>\n   <span class=\"hljs-keyword\">FROM<\/span> V$ALERT_HISTORY\n   <span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">MODULE<\/span> = <span class=\"hljs-string\">'ASM'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">5. ASM File Management<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Managing ASM files involves creating, managing, and accessing files stored within ASM disk groups. This section covers essential file management tasks and integrating ASM with Oracle databases.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Creating and Managing ASM Files<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM files are created and managed using SQL commands or Oracle tools such as Oracle Enterprise Manager (OEM).<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Create a tablespace using ASM<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-16\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLESPACE<\/span> myts <span class=\"hljs-keyword\">DATAFILE<\/span> <span class=\"hljs-string\">'+DATA'<\/span> <span class=\"hljs-keyword\">SIZE<\/span> <span class=\"hljs-number\">100<\/span>M;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-16\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Move an existing file to ASM<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-17\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DATABASE<\/span> <span class=\"hljs-keyword\">MOVE<\/span> <span class=\"hljs-keyword\">DATAFILE<\/span> <span class=\"hljs-string\">'\/u01\/app\/oracle\/oradata\/mydb\/system01.dbf'<\/span> <span class=\"hljs-keyword\">TO<\/span> <span class=\"hljs-string\">'+DATA'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-17\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li><strong>List ASM files<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-18\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">SELECT<\/span> FILE_NUMBER, FILE_TYPE, TABLESPACE_NAME, <span class=\"hljs-keyword\">BYTES<\/span>\n   <span class=\"hljs-keyword\">FROM<\/span> V$ASM_FILE;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-18\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\">Using ASM with Oracle Database<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Integrating ASM with Oracle Database involves configuring the database to use ASM for storage.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Set the <code>DB_CREATE_FILE_DEST<\/code> parameter<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-19\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">SYSTEM<\/span> <span class=\"hljs-keyword\">SET<\/span> DB_CREATE_FILE_DEST = <span class=\"hljs-string\">'+DATA'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-19\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Create database objects using ASM<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-20\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> mytable (<span class=\"hljs-keyword\">id<\/span> <span class=\"hljs-built_in\">NUMBER<\/span>, <span class=\"hljs-keyword\">name<\/span> <span class=\"hljs-built_in\">VARCHAR2<\/span>(<span class=\"hljs-number\">50<\/span>))\n   <span class=\"hljs-keyword\">TABLESPACE<\/span> myts;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-20\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li><strong>Manage ASM file access permissions<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-21\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> <span class=\"hljs-keyword\">SET<\/span> <span class=\"hljs-keyword\">ATTRIBUTE<\/span> <span class=\"hljs-string\">'access_control.enabled'<\/span> = <span class=\"hljs-string\">'true'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-21\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\">ASM Templates<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM templates define the default properties for ASM files, such as redundancy and striping.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Create a custom ASM template<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-22\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> <span class=\"hljs-keyword\">ADD<\/span> <span class=\"hljs-keyword\">TEMPLATE<\/span> mytemplate <span class=\"hljs-keyword\">ATTRIBUTES<\/span> (REDUNDANCY <span class=\"hljs-keyword\">HIGH<\/span>, STRIPE_WIDTH <span class=\"hljs-number\">1<\/span>M);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-22\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Use a template when creating a tablespace<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-23\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLESPACE<\/span> myts <span class=\"hljs-keyword\">DATAFILE<\/span> <span class=\"hljs-string\">'+DATA(mytemplate)'<\/span> <span class=\"hljs-keyword\">SIZE<\/span> <span class=\"hljs-number\">100<\/span>M;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-23\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h1 class=\"wp-block-heading\">6. Performance Tuning and Optimization<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Optimizing ASM performance involves following best practices, tuning disk groups, and monitoring performance metrics.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ASM Best Practices<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Distribute I\/O evenly across disks<\/strong>: Ensure disks in a disk group have similar performance characteristics.<\/li>\n\n\n\n<li><strong>Use appropriate redundancy levels<\/strong>: Choose the right level of redundancy based on performance and availability requirements.<\/li>\n\n\n\n<li><strong>Regularly monitor and maintain ASM<\/strong>: Use Oracle tools and scripts to monitor disk group usage and performance.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Tuning ASM Disk Groups<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Adjust rebalancing power<\/strong>: Set the rebalancing power to balance between performance and rebalancing speed.<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-24\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> REBALANCE <span class=\"hljs-keyword\">POWER<\/span> <span class=\"hljs-number\">10<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-24\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Optimize disk group configuration<\/strong>: Regularly review and adjust the configuration to ensure optimal performance.<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-25\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> <span class=\"hljs-keyword\">RESIZE<\/span> <span class=\"hljs-keyword\">ALL<\/span> <span class=\"hljs-keyword\">SIZE<\/span> <span class=\"hljs-number\">200<\/span>G;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-25\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li><strong>Use intelligent data placement<\/strong>: Leverage ASM\u2019s intelligent data placement feature to optimize data location based on access patterns.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Monitoring and Troubleshooting Performance<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Use Oracle Enterprise Manager (OEM)<\/strong>: OEM provides comprehensive tools for monitoring and managing ASM performance.<\/li>\n\n\n\n<li><strong>Monitor performance metrics<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-26\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">SELECT<\/span> GROUP_NUMBER, TOTAL_MB, FREE_MB, USABLE_FILE_MB, OFFLINE_DISKS\n   <span class=\"hljs-keyword\">FROM<\/span> V$ASM_DISKGROUP;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-26\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li><strong>Analyze wait events<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-27\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">EVENT<\/span>, TOTAL_WAITS, TIME_WAITED\n   <span class=\"hljs-keyword\">FROM<\/span> V$SYSTEM_EVENT\n   <span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">EVENT<\/span> <span class=\"hljs-keyword\">LIKE<\/span> <span class=\"hljs-string\">'asm%'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-27\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">7. ASM Backup and Recovery<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Backing up and recovering ASM metadata and disk groups is crucial for ensuring data availability and integrity.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Backing Up ASM Metadata<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Use the ASMCMD utility<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-28\" data-shcb-language-name=\"Bash\" data-shcb-language-slug=\"bash\"><span><code class=\"hljs language-bash\">   asmcmd md_backup \/u01\/app\/oracle\/backup\/asm_metadata.bak<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-28\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Bash<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">bash<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Schedule regular backups<\/strong>: Automate ASM metadata backups using cron jobs or Oracle Scheduler.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Recovering ASM Disk Groups<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Restore ASM metadata<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-29\" data-shcb-language-name=\"Bash\" data-shcb-language-slug=\"bash\"><span><code class=\"hljs language-bash\">   asmcmd md_restore \/u01\/app\/oracle\/backup\/asm_metadata.bak<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-29\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Bash<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">bash<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Recover from disk failures<\/strong>: Replace failed disks and use the ASM recovery commands to restore data.<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-30\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> <span class=\"hljs-keyword\">DATA<\/span> <span class=\"hljs-keyword\">MOUNT<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-30\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">8. Advanced ASM Features<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">ASM offers several advanced features to enhance its capabilities and integration with other Oracle technologies.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ASM Flex and Flex Redundancy<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM Flex provides flexible deployment options for ASM instances and disk groups, improving scalability and availability.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Enable ASM Flex<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-31\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">SYSTEM<\/span> <span class=\"hljs-keyword\">SET<\/span> asm_flex_enabled = <span class=\"hljs-literal\">TRUE<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-31\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Configure Flex redundancy<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-32\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">   <span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">DISKGROUP<\/span> FLEXDATA FLEX REDUNDANCY DISK <span class=\"hljs-string\">'\/dev\/oracleasm\/disks\/DISK1'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-32\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\">ASM Cluster File System (ACFS)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ACFS extends ASM capabilities to provide a scalable, high-performance file system.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Create an ACFS file system<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-33\" data-shcb-language-name=\"Bash\" data-shcb-language-slug=\"bash\"><span><code class=\"hljs language-bash\">   asmcmd mkfs -t acfs +DATA\/vol1<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-33\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Bash<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">bash<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li><strong>Mount the ACFS file system<\/strong>:<\/li>\n<\/ol>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-34\" data-shcb-language-name=\"Bash\" data-shcb-language-slug=\"bash\"><span><code class=\"hljs language-bash\">   mount -t acfs \/dev\/asm\/vol1-123 \/mnt\/acfs<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-34\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Bash<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">bash<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\">Integration with Oracle Cloud<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ASM integrates seamlessly with Oracle Cloud, enabling hybrid and cloud-native deployments.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Configure ASM for Oracle Cloud Infrastructure (OCI)<\/strong>: Use Oracle Cloud tools and APIs to manage ASM storage in cloud environments.<\/li>\n\n\n\n<li><strong>Leverage cloud-native features<\/strong>: Integrate ASM with Oracle Autonomous Database and other cloud services for enhanced performance and scalability.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">9. Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle ASM provides a comprehensive solution for managing database storage efficiently. By understanding its architecture, configuring and managing disk groups, optimizing performance, and leveraging advanced features, database administrators can ensure high performance, scalability, and reliability for their Oracle databases. This tutorial has covered the essential aspects of using ASM, providing a solid foundation for mastering this powerful storage management tool.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Oracle&#8217;s Automatic Storage Management (ASM) is a powerful feature designed to simplify the management of database storage by providing an easy-to-use interface for database administrators. ASM integrates with Oracle databases to offer high performance, scalability, and reliability while reducing the complexity of managing storage systems. This tutorial is aimed at non-beginners who are already [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[14,25],"tags":[],"class_list":["post-2015","post","type-post","status-publish","format-standard","category-database-development","category-oracle-database","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using Oracle&#039;s ASM for Efficient Storage<\/title>\n<meta name=\"description\" content=\"Oracle&#039;s Automatic Storage Management (ASM) is a powerful feature designed to simplify the management of database storage\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Oracle&#039;s ASM for Efficient Storage\" \/>\n<meta property=\"og:description\" content=\"Oracle&#039;s Automatic Storage Management (ASM) is a powerful feature designed to simplify the management of database storage\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-28T15:17:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-28T15:17:34+00:00\" \/>\n<meta name=\"author\" content=\"w3compadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"w3compadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\\\/\"},\"author\":{\"name\":\"w3compadmin\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#\\\/schema\\\/person\\\/a550b3e20d78bb4f79b7c6b7b53f0561\"},\"headline\":\"How to Use Oracle&#8217;s Automatic Storage Management (ASM) for Efficient Storage\",\"datePublished\":\"2024-06-28T15:17:29+00:00\",\"dateModified\":\"2024-06-28T15:17:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\\\/\"},\"wordCount\":1232,\"articleSection\":[\"Database Development\",\"Oracle Database\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\\\/\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\\\/\",\"name\":\"Using Oracle's ASM for Efficient Storage\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#website\"},\"datePublished\":\"2024-06-28T15:17:29+00:00\",\"dateModified\":\"2024-06-28T15:17:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#\\\/schema\\\/person\\\/a550b3e20d78bb4f79b7c6b7b53f0561\"},\"description\":\"Oracle's Automatic Storage Management (ASM) is a powerful feature designed to simplify the management of database storage\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Articles Home\",\"item\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Development\",\"item\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/database-development\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Use Oracle&#8217;s Automatic Storage Management (ASM) for Efficient Storage\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#website\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/\",\"name\":\"Developer Articles Hub\",\"description\":\"\",\"alternateName\":\"Developer Articles\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#\\\/schema\\\/person\\\/a550b3e20d78bb4f79b7c6b7b53f0561\",\"name\":\"w3compadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/wp-content\\\/litespeed\\\/avatar\\\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1781957457\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/wp-content\\\/litespeed\\\/avatar\\\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1781957457\",\"contentUrl\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/wp-content\\\/litespeed\\\/avatar\\\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1781957457\",\"caption\":\"w3compadmin\"},\"sameAs\":[\"http:\\\/\\\/w3computing.com\\\/articles\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Oracle's ASM for Efficient Storage","description":"Oracle's Automatic Storage Management (ASM) is a powerful feature designed to simplify the management of database storage","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/","og_locale":"en_US","og_type":"article","og_title":"Using Oracle's ASM for Efficient Storage","og_description":"Oracle's Automatic Storage Management (ASM) is a powerful feature designed to simplify the management of database storage","og_url":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/","article_published_time":"2024-06-28T15:17:29+00:00","article_modified_time":"2024-06-28T15:17:34+00:00","author":"w3compadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"w3compadmin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/#article","isPartOf":{"@id":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/"},"author":{"name":"w3compadmin","@id":"https:\/\/www.w3computing.com\/articles\/#\/schema\/person\/a550b3e20d78bb4f79b7c6b7b53f0561"},"headline":"How to Use Oracle&#8217;s Automatic Storage Management (ASM) for Efficient Storage","datePublished":"2024-06-28T15:17:29+00:00","dateModified":"2024-06-28T15:17:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/"},"wordCount":1232,"articleSection":["Database Development","Oracle Database"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/","url":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/","name":"Using Oracle's ASM for Efficient Storage","isPartOf":{"@id":"https:\/\/www.w3computing.com\/articles\/#website"},"datePublished":"2024-06-28T15:17:29+00:00","dateModified":"2024-06-28T15:17:34+00:00","author":{"@id":"https:\/\/www.w3computing.com\/articles\/#\/schema\/person\/a550b3e20d78bb4f79b7c6b7b53f0561"},"description":"Oracle's Automatic Storage Management (ASM) is a powerful feature designed to simplify the management of database storage","breadcrumb":{"@id":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.w3computing.com\/articles\/how-to-use-oracles-automatic-storage-management-asm-for-efficient-storage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Articles Home","item":"https:\/\/www.w3computing.com\/articles\/"},{"@type":"ListItem","position":2,"name":"Database Development","item":"https:\/\/www.w3computing.com\/articles\/database-development\/"},{"@type":"ListItem","position":3,"name":"How to Use Oracle&#8217;s Automatic Storage Management (ASM) for Efficient Storage"}]},{"@type":"WebSite","@id":"https:\/\/www.w3computing.com\/articles\/#website","url":"https:\/\/www.w3computing.com\/articles\/","name":"Developer Articles Hub","description":"","alternateName":"Developer Articles","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.w3computing.com\/articles\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.w3computing.com\/articles\/#\/schema\/person\/a550b3e20d78bb4f79b7c6b7b53f0561","name":"w3compadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.w3computing.com\/articles\/wp-content\/litespeed\/avatar\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1781957457","url":"https:\/\/www.w3computing.com\/articles\/wp-content\/litespeed\/avatar\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1781957457","contentUrl":"https:\/\/www.w3computing.com\/articles\/wp-content\/litespeed\/avatar\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1781957457","caption":"w3compadmin"},"sameAs":["http:\/\/w3computing.com\/articles"]}]}},"featured_image_src":null,"featured_image_src_square":null,"author_info":{"display_name":"w3compadmin","author_link":"https:\/\/www.w3computing.com\/articles\/author\/w3compadmin\/"},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/posts\/2015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/comments?post=2015"}],"version-history":[{"count":1,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/posts\/2015\/revisions"}],"predecessor-version":[{"id":2016,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/posts\/2015\/revisions\/2016"}],"wp:attachment":[{"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/media?parent=2015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/categories?post=2015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/tags?post=2015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}