4 Replies Latest reply on Feb 28, 2020 7:57 PM by Danno_AECC

    DBA > Storage > Datafile view and autoextend tables

    Danno_AECC

      We use AutoExtend and, as far as I can tell, the Datafile gui will only show current usage of files. This also rolls up to the tablespace view that will show a tablespace being out of space when, in fact, it has heaps of extendable space. Is there a way to have the output show the % used of extendable space? In this example below, both files are the same size (32 GB) but I feel like it is misleading for SQL Developer to show the tablespace as 100% used (no space left) and both of these datafiles at 100% capacity.

       

      SQL Developer datafile example.png