Query to determine tablespace usage (for both data and temp), taking into account any autoextend settings.
Autoextend is ignored by sys.sm$ts_used, so that view is not really usable. The results from that view are shown in column pct_used_wrong, the correct result is shown in column pct_used.

Execute as sys or system:
select t.tablespace_name , t.status , trunc( nvl(tsu.bytes,0) / 1024) as used_k , trunc( dbf.bytes/1024 ) as size_k , trunc( dbf.maxbytes/1024 ) as maxsize_k , round( nvl(tsu.bytes,0) / dbf.bytes * 100 ) as pct_used_wrong , round( nvl(tsu.bytes,0) / dbf.maxbytes * 100 ) as pct_used from sys.dba_tablespaces t , sys.sm$ts_used tsu , ( select f.tablespace_name , sum(bytes) as bytes , sum( decode( f.autoextensible ,'YES',(case when f.maxbytes<f.bytes then f.bytes else f.maxbytes end) /*case is needed to prevent silly numbers due to configuration errors*/ ,f.bytes ) ) as maxbytes from ( select tablespace_name, bytes, maxbytes, autoextensible from dba_temp_files where status = 'ONLINE' union all select tablespace_name, bytes, maxbytes, autoextensible from dba_data_files where status = 'AVAILABLE' ) f group by f.tablespace_name ) dbf where t.tablespace_name = dbf.tablespace_name (+) and t.tablespace_name = tsu.tablespace_name (+) order by pct_used desc

Find details of datafiles and tempfiles.
Execute as sys or system: select df.file_name , df.tablespace_name , df.bytes , df.maxbytes , df.autoextensible from dba_data_files df where df.status = 'AVAILABLE' union all select tf.file_name , tf.tablespace_name , tf.bytes , tf.maxbytes , tf.autoextensible from dba_temp_files tf where status = 'ONLINE'
Set the maximum autoextend size of a specific data- or tempfile.
Execute as sys or system: ALTER DATABASE DATAFILE '/u02/oradata/ISRP/datafile/o1_mf_int_data_5r7ohy0p_.dbf' AUTOEXTEND ON MAXSIZE 32767M;