Tablespace script is not alerting on ORA-1652: unable to extend temp segment by 128 in tablespace

Hi DBAs,

I need your help on the below one.

OS = RHEL AS4
DB=10.2.0.4
Storage = File system

We have the following script to alert us on whenever any tablespace having less than 5 GB.

Script :

select TABSPACE "Tablespace Name", FREESPACE "Free Space", TOTSPACE "Total Space", USEDSPACE "Used Space" from (
 select tablespace_name "TABSPACE", round(sum(maxbytes/(1024 * 1024 * 1024)),2) - round(sum(bytes/(1024 * 1024 * 1024)),2) "FREESPACE",
        round(sum(maxbytes/(1024 * 1024 * 1024)),2) "TOTSPACE",
        round(sum(bytes/(1024 * 1024 * 1024)),2) "USEDSPACE"
   from dba_data_files
  where autoextensible = 'YES'
  group by tablespace_name )
    where FREESPACE < 5;


Its working fine. But the problem is, we are not receiving following alert throw above script.


ORA-1652: unable to extend temp segment by 128 in tablespace METRICS_INDEX_2011