How to tell ASM space usage vd Database space usage?
Hi All:
I need expert advice to correctly check diskspace(ASM) usage vs database size, am I in the correct direction?
Check ASM:
(1)ASMCMD line: 'lsdg' or 'du'.
(2)v$asm_disk(total_mb, free_mb)
Check Total Database size: dba_data_files, dba_temp_files, sys.v_$log
$ asmcmd -p
ASMCMD [+] > lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N N 512 4096 1048576 1567611 458212 0 458212 0 DATADG1/
MOUNTED EXTERN N N 512 4096 1048576 136403 136292 0 136292 0 DSS_DATA/
MOUNTED EXTERN N N 512 4096 1048576 272806 209733 0 209733 0 FLASHBACK_1/
DATADG1 Total in GB: 1567.611
DSS_DATA Total in GB: 136.403
FLASHBACK_1 Total in GB: 272.806
I need expert advice to correctly check diskspace(ASM) usage vs database size, am I in the correct direction?
Check ASM:
(1)ASMCMD line: 'lsdg' or 'du'.
(2)v$asm_disk(total_mb, free_mb)
Check Total Database size: dba_data_files, dba_temp_files, sys.v_$log
$ asmcmd -p
ASMCMD [+] > lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N N 512 4096 1048576 1567611 458212 0 458212 0 DATADG1/
MOUNTED EXTERN N N 512 4096 1048576 136403 136292 0 136292 0 DSS_DATA/
MOUNTED EXTERN N N 512 4096 1048576 272806 209733 0 209733 0 FLASHBACK_1/
DATADG1 Total in GB: 1567.611
DSS_DATA Total in GB: 136.403
FLASHBACK_1 Total in GB: 272.806
0