View the. SQL of the user's default table space.
Select Username,default_tablespace from Dba_users;
View the disk footprint of each table space. sql:
Select
b.file_id file ID number,
B.tablespace_name table space Name,
b.bytes/1024/1024| | ' M ' byte number,
(B.bytes-sum (NVL (a.bytes,0))/1024/1024| | ' M ' has been used,
Sum (NVL (a.bytes,0))/1024/1024| | ' M ' remaining space,
100-sum (NVL (a.bytes,0))/(b.bytes) *100 percent occupancy
From Dba_free_space A,dba_data_files b
where a.file_id=b.file_id
GROUP BY B.tablespace_name,b.file_id,b.bytes
ORDER BY b.file_id
The above 2 associations are the SQL statements that view user default table space usage:
Select *
From
(select Username,default_tablespace from dba_users) UT,
(SELECT
--b.file_id file ID number,
B.tablespace_name table space Name,
b.bytes/1024/1024| | ' M ' byte number,
(B.bytes-sum (NVL (a.bytes,0))/1024/1024| | ' M ' has been used,
Sum (NVL (a.bytes,0))/1024/1024| | ' M ' remaining space,
100-sum (NVL (a.bytes,0))/(b.bytes) *100 percent occupancy
From Dba_free_space A,dba_data_files b
where a.file_id=b.file_id
GROUP BY B.tablespace_name,b.file_id,b.bytes
ORDER by b.file_id) Tsu
Where ut.default_tablespace = tsu. Table space Name
ORDER BY Ut.username