Proper way to check ODA usable diskspace(ODA x5-2, Oracle Database 12C)
Hi Team,
ODA x5-2, Oracle Database 12C
I'm confusing why the ASM number will not increase after i deleted tablespace.
ASM sql command
SELECT name AS "DG",
state, type AS "Redundancy",total_mb/1024 AS "Size(GB)" ,
free_mb/1024 AS "Free(GB)",
usable_file_mb/1024 AS "Usable(GB)",
sector_size AS "Secto r Size"
FROM v$asm_diskgroup;
Run the ASM command and the oakcli show dbstorage command in month Aug 2020
ASM Total size 50336GB --- free 7870GB --- usable 2362GB
and oakcli show dbstorage command return
Size 21226GB -- Used- 10615.86GB --Available 10610.14GB
In the month SEP 2020 i have inserted huge volume of data into new tablespace calls testing.tbl, and run sql command to check the ASM command to check diskspace -->