V$asm_operation
Oracle ASM Disk Balancing: Monitor with v$asm_operation
Jan 14, 2024 / · 2 min read · oracle asm oracle disk information storage management diskgroup v$asm_operation ·Monitoring ASM Operations in Oracle Database, Using thev$asm_operationView SQL Code 1select * 2from v$asm_operation 3/ Mount/dismount disk groups 1alter diskgroup all mount 2/ 1alter diskgroup data1 mount 2/ 1alter diskgroup all dismount 2/ 1alter diskgroup data1 dismount 2/ Description of the Oracle Database SQL code …
Read MoreQuerying ASM Disk Information in Oracle
Jan 7, 2024 / · 6 min read · Oracle ASM Oracle Disk Information Storage Management v$asm_disk v$asm_disk_stat v$asm_diskgroup v$asm_file v$asm_operation ·Querying ASM Disk Information in Oracle A disk group that reports plenty of free space can still be one disk failure away from trouble, and a LUN the storage team says is ready can still be invisible to ASM. Both show up in one query against v$asm_disk: the per-disk free space, and the group 0 rows for disks not yet in …
Read MoreVisualizing Disk Groups in Oracle ASM with SQL
Jan 6, 2024 / · 5 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 v$asm_disk_stat ·Visualizing Disk Groups in Oracle ASM with SQL Purpose V$ASM_DISK is the view that lists every disk the Oracle ASM instance finds, including disks that are not part of any disk group. The query below reads six of its columns and sorts the rows by disk group number. The result is a plain text listing in SQL*Plus, one …
Read More