Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

Proper way to check ODA usable diskspace(ODA x5-2, Oracle Database 12C)

edited Oct 26, 2020 6:19AM in Oracle Database Appliance (ODA) (MOSC) 6 commentsAnswered

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 -->

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center