Shell Programming and Scripting

Hi,
I want to calculate the table space usages an this result save as excel. It's saved but header coming two time within one excel file like :

TABLESPACE_NAME SIZE_MB FREE_MB USED_MB FREE_% USED_% a 10000 3395.63 6604.37 33 66 b 2048 1330.38 717.62 64 35 c 7964.1875 3898.88 4065.3075 48 51 TABLESPACE_NAME SIZE_MB FREE_MB USED_MB FREE_% USED_% d 2048 699.63 1348.37 34 65 e 627 1.19 625.81 0 99

I want to show only one header in one excel. Please find below my script :

Code:

#!/bin/bash
sqlplus -s sys/password@sid as sysdba << EOC  > /dev/null
set feed off markup html on spool on
spool table_space.xls
select
b.tablespace_name,
tbs_size size_mb,
a.free_space free_mb,
tbs_size-a.free_space used_mb,
Trunc((a.free_space/tbs_size) * 100) "FREE_%",
Trunc(((tbs_size-a.free_space)/tbs_size) * 100) "USED_%"
from  (select tablespace_name, round(sum(bytes)/1024/1024 ,2) as free_space
       from dba_free_space
       group by tablespace_name) a,
      (select tablespace_name, sum(bytes)/1024/1024 as tbs_size
       from dba_data_files
       group by tablespace_name) b
where a.tablespace_name(+)=b.tablespace_name;
spool off
set markup html off spool off
EOC

Thanks in advance.

Provide the output also in CODE tags .. Your getting output seems to be confusing ..

This is o/p what i had got when i ran ur query. i couldn't see two header .

TABLESPACE_NAME SIZE_MB FREE_MB USED_MB FREE_% ------------------------------ ---------- ---------- ---------- ---------- USED_% ---------- SYSAUX 290 9.06 280.94 3 96 USERS 130 6.69 123.31 5

SYSTEM 350 1.19 348.81 0 99 UNDO 305 296.31 8.69 97 2

Thanks for replay.

The problem is solved.
I had increased the page size.
set pagesize 200