Dba_extents
Identifying User Tablespaces and Space Usage in Oracle
Feb 4, 2024 / · 3 min read · database administration resource optimization performance monitoring data management tablespace dba_extents user space user ·Query to Display All Tablespaces Used by A Specified User and The Total Space Occupied (rounded to MB) Sample SQL Command 1select tablespace_name 2, ceil(sum(bytes) / 1024 / 1024) "MB" 3from dba_extents 4where owner like '&user_id' 5group by tablespace_name 6order by tablespace_name 7/ Sample Oracle Output …
Read More