select 
	a.tablespace_name, 
	a.file_id, 
	a.block_id, 
	a.blocks, 
	b.block_id
	from dba_free_space a, dba_free_space b
where 
	a.tablespace_name=b.tablespace_name and
	a.file_id=b.file_id and
	a.block_id + a.blocks= b.block_id and
	A.tablespace_name != 'TEMP' and
	b.tablespace_name != 'TEMP';


SELECT 
	TABLESPACE_NAME, 
	INITIAL_EXTENT,
	NEXT_EXTENT, 
	PCT_INCREASE 
FROM 
	DBA_TABLESPACES
WHERE 
	TABLESPACE_NAME='USERS'