mcc1asff4:/export/home/archieu/preprocessor>more stats.sh
#!/usr/bin/ksh
echo hello
echo $ORACLE_HOME
sample=`/orcl/app/oracle/product/8.1.7/bin/sqlplus  archuser/archuser@database << END >/export/home/arch/preprocessor/
ravi.txt
set head off
set echo  off
set verify off
set termout off
set feedback off
set pagesize 0
set show off

SELECT 'Tablespace:'||df.tablespace_name||', MB Free: '||ROUND(SUM(fs.MB_free)/(1024*1024))
        || ', MB Total: '||SUM(df.bytes)/(1024*1024)|| ', PCT Free: '||ROUND(100*SUM(fs.MB_free)/SUM(df.bytes))||'%'
FROM
 sys.dba_data_files df,
 (SELECT
  fs.tablespace_name,
  fs.file_id,
  SUM(fs.bytes) MB_free
  FROM
  sys.dba_free_space fs
  GROUP BY
  fs.tablespace_name, fs.file_id
 ) fs
WHERE
 fs.tablespace_name = df.tablespace_name AND
 fs.file_id = df.file_id
GROUP BY df.tabLespace_name


exit

END`

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 24 13:29:31 2007

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>   2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17
18  SQL> SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

GROUP BY df.tabLespace_name;

sqlplus -s archuser/archuser@database