> cat ts_df.sh
#!/bin/ksh
 
sql_rows=`sqlplus -s / <<EOF
spool /tmp/tmp_${0};
set heading on
set pagesize 1000
set tab on
set linesize 120 wrap off
column "Path" format a15
--column "No_Of_files" format a10
select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files 
 group by rollup ( tablespace_name, substr(file_name,1,instr(file_name,'/',1,2))) order by 1 asc;
spool off;
--exit
EOF`
 
while read sql_rec
do
if [[ $sql_rec != +(#) ]]  
then
        if [[ $(echo $sql_rec | grep -c '/') = 0 ]]
        then
                echo $sql_rec
        else
                mp="$(echo $sql_rec|awk '{print $2}')"
                space="$(df -kh $mp)"
                f_space="$(echo $space|awk '{print $9 " " $11}')"
                echo $sql_rec $f_space
        fi
fi
done < /tmp/tmp_${0}
#
 
 > ts_df.sh
TABLESPACE_NAME Path No_Of_files
------------------------------ --------------- -----------
SYSAUX /db1/ 1 135G 91G
SYSAUX 1
SYSTEM /db1/ 1 135G 91G
SYSTEM 1
UNDOTBS1 /db1/ 1 135G 91G
UNDOTBS1 1
USERS /db1/ 1 135G 91G
USERS 1
4
 
 > cat /tmp/tmp_ts_df.sh
TABLESPACE_NAME                Path            No_Of_files
------------------------------ --------------- -----------
SYSAUX                         /db1/                     1
SYSAUX                                                   1
SYSTEM                         /db1/                     1
SYSTEM                                                   1
UNDOTBS1                       /db1/                     1
UNDOTBS1                                                 1
USERS                          /db1/                     1
USERS                                                    1
                                                         4
 
Ideally:
TABLESPACE_NAME                Path            No_Of_files   Size      Free
------------------------------ --------------- ----------- -------   --------
SYSAUX                         /db1/                     1    135G        91G
SYSAUX                                                   1
SYSTEM                         /db1/                     1    135G        91G
SYSTEM                                                   1
UNDOTBS1                       /db1/                     1    135G        91G
UNDOTBS1                                                 1
USERS                          /db1/                     1    135G        91G
USERS                                                    1
                                                         4