How to check how many extents are used totally in an oracle database.

select sum(bytes/1024/1024/1024) gb from dba_extents;

This entry was posted in Oracle. Bookmark the permalink.