Такой вопрос, что даже и не знаешь, стоит ли на него отвечать .
Должность у Вас какая, за что вы отвечаете?

авторselect file_name, BYTES, blocks, autoextensible,
nvl(increment_by, 0) increment_by, maxbytes, maxblocks, status, maxblocks maxextend, file_id
from sys.dba_data_files
where TABLESPACE_NAME = 'USERS';


авторSelect DECODE (partition_name,
NULL, segment_name,
segment_name || ':' || partition_name
) segment_name,
owner, tablespace_name, segment_type, initial_extent, next_extent, extents, bytes, max_extents
from dba_segments
WHERE tablespace_name = 'USERS'
order by owner, segment_name;

авторSELECT SEGMENT_TYPE, owner,
DECODE( PARTITION_NAME, NULL, segment_name, segment_name || ':' || PARTITION_NAME) segment_name, tablespace_name,
file_id, block_id, blocks, bytes
FROM DBA_EXTENTS
WHERE tablespace_name ='USERS'
order by bytes desc;