V$asm_file
Querying 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