Skip to content

Instantly share code, notes, and snippets.

@cesardba
Created April 28, 2021 12:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cesardba/c403ac598c965cd11542e3e3fd5825aa to your computer and use it in GitHub Desktop.
Save cesardba/c403ac598c965cd11542e3e3fd5825aa to your computer and use it in GitHub Desktop.
set linesize 200
set pagesize 500
set colsep " | "
col "disk_name" format a30
col group_number heading group|number
col header_status format a15
col "group_name" format a10
col path format a40
select group_number,disk_number,mount_status,header_status,mode_status,state,os_mb,total_mb,free_mb,path
from v$asm_disk;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment