V$asm_disk
Oracle ASM: Add a Disk to an Existing Disk Group
Jan 10, 2024 / · 2 min read · Oracle ASM Oracle Disk Information Storage Management diskgroup v$asm_disk ·Expanding Storage Capacity in Oracle Database, Adding a Disk to Diskgroup Data1 SQL Code Note: Wildcards can be used for raw device names (eg. raw* 1alter diskgroup data1 2add disk '/dev/raw/raw4' 3/ Sample Oracle Output 1no rows selected 2SQL> Description of the Oracle Database SQL code Purpose: The primary purpose of …
Read MoreQuerying ASM Disk Information in Oracle
Jan 7, 2024 / · 2 min read · Oracle ASM Oracle Disk Information Storage Management v$asm_disk v$asm_diskgroup v$asm_file v$asm_operation ·Querying ASM Disk Information in Oracle SQL Code 1select name 2, group_number 3, disk_number 4, total_mb 5, free_mb 6from v$asm_disk 7order by group_number 8/ Sample Oracle Output 1no rows selected 2SQL> Purpose: Retrieves and displays key information about Automatic Storage Management (ASM) disks within the database. …
Read MoreVisualizing Disk Groups in Oracle ASM with SQL
Jan 6, 2024 / · 2 min read · disk space analysis oracle storage capacity monitoring asm disk utilization asm v$asm_disk v$asm_diskgroup v$asm_file v$asm_operation ·Visualizing Disk Groups in Oracle ASM with SQL Note: A group number of zero his indicates that a disk is available but hasn't yet been assigned to a disk group. SQL Code 1set lines 100 2col name format a10 3col path format a30 4select name 5, group_number 6, disk_number 7, mount_status 8, state 9, path 10from …
Read More