Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBA > Storage > Datafile view and autoextend tables

Danno_AECCFeb 28 2020 — edited Feb 28 2020

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

This post has been answered by thatJeffSmith-Oracle on Feb 28 2020
Jump to Answer
Comments
Post Details
Added on Feb 28 2020
4 comments
220 views